Pages - Menu

▼
Saturday, May 28, 2011

How to Add a Histogram in Microsoft Excel for Macs

›
1. Install the StatPlus-Mac LE (full link in Resources). This free add-on provides Mac users with statistical analysis tools. Excel 2011 f...

How to Work With Pictures in Excel 2007

›
Inserting the Picture File 1. Open the Excel worksheet. 2. Click the 'Insert' tab on the command ribbon. 3. Click the 'Pic...
Friday, May 27, 2011

How to Create a Drop

›
1. Open an Excel spreadsheet. Click in an empty cell and type the first item for the drop-down list. Press 'Enter' and then type t...

How to Force Excel 2007 to Be Backwards Compatible With 2003

›
1. Open Excel 2007 and select the 'Office' button. Select 'Excel Options.' The Excel Options dialog box appears. 2. Sele...

How to Make Lower Case Data All Caps in Excel 2007

›
1. Find the cell that contains the lower case information. Make note of the cell number. Cells in Excel are marked by a letter (column) an...

How to Recover Deleted Excel Files

›
Enable Automatic Recovery and Saving 1. Open Excel and select 'File,' 'Help,' and then 'Options.' 2. Select ...

How to Use Autofilter in MS Excel

›
1. Look at your data and decide what columns (or rows) you want to be able to sort with. Highlight those columns or rows and select '...
Thursday, May 26, 2011

How to Email One Sheet in an Excel 2007 Workbook

›
1. Open the Excel file that you want to send. With the tabs at the bottom, find and click on the worksheet in the file that you want to em...

How to Make an Address Book in Excel

›
1. Click the 'Start' menu and go to 'All Programs.' Select 'Microsoft Office' followed by 'Microsoft Excel...

How to Alphabetize in Excel 2003

›
1. Open Excel 2003 and select a worksheet containing data. Click 'File' on the menu bar and select 'Open.' Search your f...

How to Learn MS Excel Fast

›
1. Open Microsoft Excel or download a free trial program. Explore the in-program tutorial options by clicking the 'File' tab in th...
Wednesday, May 25, 2011

How to Make Trend Charts With Excel

›
1. Create a chart with names and grades. This can be mock information. In cell A1, type 'Names' and in cell B2 type 'Grade...

How to Apply a Theme to a Worksheet

›
1. Open the Excel worksheet. 2. Click the 'Page Layout' tab on the command ribbon. 3. Click 'Themes' in the 'Theme...

How Can I Put Text a Formula Into the Same Cell in an Excel Spreadsheet?

›
Test the theory 1. Open a new workbook or spreadsheet and click in cell A1. Type the number 2. 2. Click in cell A2 and type the number 2...

How to Format Numbers in Excel 2003

›
1. Open your Excel worksheet and select a group of cells. Press the left mouse button and drag over the cells. 2. Click 'Format'...