Excel
Pages - Menu
(Move to ...)
Home
▼
Monday, November 28, 2011
How to Use the Quartile Function in Excel
›
1. Open a new Microsoft Excel 2010 spreadsheet. Click on the top-left cell in the spreadsheet. 2. Type your data set into the first colu...
How to Create a Calendar Using Excel
›
1. Open Microsoft Excel. Click on the 'Tools' menu, point to 'Macro' and click on 'Visual Basic Editor' if using E...
Sunday, November 27, 2011
How to Change the Text Orientation in Cells in Excel 2003
›
1. Open your Excel worksheet. 2. Select the text cells you wish to change. Hold down the left mouse button and drag across the cells or ...
How to Change the Cursor in Microsoft Excel
›
1. Open Excel. 2. Navigate around the spreadsheet. The mouse cursor remains as a white plus sign whenever the cursor is located over a c...
Saturday, November 26, 2011
How to Group and Outline Data in Microsoft Excel 2003
›
1. Select the data that you wish to group and outline. The fastest way to select data for this operation is by clicking and holding the mo...
How to Calculate Payback on Excel
›
1. Open a new Microsoft Excel worksheet and type 'Initial Investment' in cell A1. Put the cost of the project in cell B1. For exam...
How to Change the Background Color in MS Excel
›
1. Select the cell or cells in which you wish to change the background color. In Excel 2007, click on the 'Home' tab to view the ...
Friday, November 25, 2011
How to Restore Data on Microsoft Excel
›
1. Run 'Detect and Repair' if you are using Excel 2003 or earlier. Go to the 'Help' menu and select 'Detect and Repair...
How to Create Spread Sheets in Excel 2007
›
1. Click on the 'Office' button. This is the round button with the Microsoft logo at the upper left-hand corner of the ribbon menu...
How to Calculate Time Duration in Excel 2007
›
1. Format the relevant cells as time by selecting them and choosing 'Time' from the Number group drop-down menu in the Home tab. 2...
How to Learn Excel 2007
›
1. Purchase a copy of Microsoft Excel or download a 60-day free trial of Microsoft Office Professional, which includes Excel 2007. 2. Vi...
How to Install Analysis ToolPak for Excel 2003
›
1. Open any Excel document. 2. Navigate to the 'Tools' menu. Click on 'Add-Ins.' 3. Select the check box next to Analy...
How to Combine Column and Scatter Charts in Excel
›
1. Open the Excel worksheet with the data you wish to chart. 2. Click and drag the cursor to select the data series and the categories. ...
How to Change the Order of the Legend in an Excel Chart
›
1. Right-click on one of the names listed on your legend. 2. Click on the 'Select Data' option from the list that appears. 3. ...
How to Create a Searchable Database in Excel
›
1. Type the following data into a new spreadsheet, pressing 'Tab' in place of the commas. This data is for a hypothetical art supp...
‹
›
Home
View web version