Excel
Pages - Menu
(Move to ...)
Home
▼
Tuesday, November 22, 2011
How to Create a Form for the Web in Excel
›
1. Go into Microsoft Excel and open the worksheet you want to make into a Web form. 2. Open the Tools menu and select Wizard, then selec...
How to Set Up Monte Carlo in Excel 2003
›
1. Access the Monte Carlo program by either placing the CD in your computer's CD drive or by connecting to the program's network d...
Monday, November 21, 2011
How to Convert New Excel From R1C1 to A1
›
1. Double-click the Excel file you want to work with to open it using Excel 2010. 2. Click the 'File' tab at the top of the Exce...
Sunday, November 20, 2011
How to Create a Pivot Table in Excel 2010
›
Use Excel Data 1. Open the Excel 2010 file that holds the data you want to make into a PivotTable. 2. Check the top of each column to en...
How to Use Excel's AveDev Function
›
1. Learn the syntax of AVEDEV. It is (number_1,number_2,...,number_n) where number_1,number_2,...,number_n are 1 to 30 arguments for which...
How to Delete Redundant Cells in Excel
›
1. Right-click the Excel file you want to edit, and click 'Open With.' Click 'Microsoft Excel' in the list of programs. 2....
Saturday, November 19, 2011
How to Convert Lotus to Excel 2007
›
1. Open the file you need to convert in Lotus. Click on the 'File' menu button in the top bar then click on 'Save As.' Th...
How to Calculate Discount Levels on an Excel Spreadsheet
›
1. Open Microsoft Excel. Click the 'A1' cell in the blank document. Type 'OP' in the cell to label the original price colu...
Friday, November 18, 2011
How to Repeat Header Rows in Excel
›
1. Launch Microsoft Excel and open the worksheet that you want to use. 2. Click the 'Page Layout' tab, and then click 'Print...
How to Insert Drop
›
1. Open your workbook to a blank page or add a new worksheet. To keep your active worksheet tidy, you will want your list stored on a sepa...
How to Use a VLookup in Excel 2003 to Reference the Data in a CSV
›
1. Start Excel with a blank worksheet. 2. Click on the 'Data' menu, and select 'Import.' Select 'Text File' and ...
How to Delete Blank Rows in Excel
›
1. Make a backup copy of your spreadsheet. This is most important during the learning process. 2. Select the entire area that contains ...
Thursday, November 17, 2011
How to Hide the Tool Bar Menu in Excel
›
1. Click the icon consisting of a down-facing arrow with a short horizontal line above it. In Excel 2007, this icon is located near the up...
How to Do Trend Charts
›
Insert Chart 1. Open the saved Excel worksheet. 2. Click the 'Insert' tab on the command ribbon. 3. Click and drag the cells w...
How to Set the Default Font Size in Excel 2003
›
1. Open Excel 2003 and select the 'Tool' on the menu bar. Select 'Options.' The Options dialog box appears. 2. Click th...
‹
›
Home
View web version