Excel
Pages - Menu
(Move to ...)
Home
▼
Tuesday, August 28, 2012
How to Convert Numbers to Text in Microsoft Excel
›
1. Open a new workbook in Microsoft Excel. 2. Type the list of numbers you would like to convert to text down a column. 3. Type =Text(...
Monday, August 27, 2012
How to Create a Drop
›
1. Select the data you want the drop-down menu to contain. This can be any list of information. Highlight those cells and click the 'D...
How to Use a Chart Wizard in MS Excel 2007
›
1. Open the Excel workbook with the data that you wish to chart. 2. Select all the cells containing the relevant data. Press 'CTRL...
How to Add a Header and Footer in Excel
›
1. Create or open the file you will be working with. A header and footer can be changed in an existing file or added to a new or existing ...
Sunday, August 26, 2012
How to Create a Timeline Using Word
›
Create a Timeline in Word 2003 1. Open the Word document on which you want to create a timeline. Go to the 'File' menu, click on ...
How to Print Bar Codes in Microsoft Excel
›
1. Launch Microsoft Excel from the Microsoft Office folder in your Start menu. 2. Click the 'Tools' drop-down menu. Select the ...
How to Print Mail Labels From Excel
›
1. Open Excel 2010 and select the 'Mailing' tab on the ribbon. Select 'Start Mail Merge.' Click 'Labels.' Select t...
Saturday, August 25, 2012
How to Transform a Spreadsheet into a Web Page in Excel 2003
›
1. Fill out your Excel 2003 worksheet. You will create the Web page from this version of the worksheet. 2. Format your worksheet. Make s...
How to Evaluate Multiple Columns in Excel 2003
›
1. Choose a formula or function that you want to use. For example, use the 'Sum' function to add columns or the 'Average' ...
How to Make an Invoice Using Excel
›
1. Navigate to the Excel templates website (see References below for link). 2. Select a template option and examine it for relevance to ...
Friday, August 24, 2012
How to Find Standard Deviation on Excel 2007
›
1. Open Excel 2007 and select the 'Formulas' tab. Click the 'Statistical' button. A drop-down list appears. 2. Click ...
How to Make a Stem Leaf Plot in Excel 2007
›
1. Rename a blank Excel worksheet “Data” by clicking the bottom tab for the worksheet and typing the new name. 2. Rename another blank E...
How to Reduce the Size of a Large Excel 2007 File
›
1. Press 'Ctrl' and 'End' at the same time. This will bring you to the bottom right cell of the worksheet. 2. Select all...
How to Use Scatter Plots in Excel
›
1. Open the Excel 2010 file containing the data you want to make into a scatter chart. 2. Arrange the data so the first row for each col...
How to Generate a Random Number in a Range in Excel
›
1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files or create a new blank spreadsheet into which you want to g...
‹
›
Home
View web version