Microsoft Excel 2007

Tutorials


For the lessons on this page, you will be working through information on creating or revising documents.  For some of the lessons you will be required to download files from this Web page.  These files can be located by clicking on this link. The files are in a compressed (zipped) folder. The folder contains all the files that are needed to complete all the exercises.  In order to use the files you will have to download them to a folder on your computer. To download the files, click on the link above and then choose Save.  While you are in the Save As dialog box, determine the location where the files are to be stored and then click Save.  After the files are downloaded, they will have to be extracted before they can be used.  For information on how to do this, click here.  Scroll down the page until you locate the information on Extracting Files.

General   Office Button
Excel Basics   Change Program Options
Data Storage Capability Comparison   Create Workbook
Excel Environment   Print
Moving Around Worksheet   Print Preview
Quick Access Toolbar   Save Workbooks
Sheet Tabs   Save Workbooks in PDF Format
Tabs and Ribbons   Save Workbook as Web Page
    View Selected Sheets
     
Home Tab   Charts
Conditional Formatting   Plan a Chart
Copy, Embed, Link Worksheets and Charts   Create Column Charts
Find-Replace   Create Pie Chart
Format Cells   Chart Tools Tab-Design
Number Formats   Chart Tools Tab -Format
Sorting Data   Chart Tools Tab-Layout
Worksheet Groups   Change Chart Type
    Change Location of Chart
     
Insert Tab   Page Layout Tab
Picture Tools Format Ribbon   Printing Row and Column Headings
Clip Art    
Header-Footer    
Smart Art    
Word Art    
     
Formulas Tab   Data Tab
Auto Fill   Data Consolidation
Create Worksheets with Formulas-Functions   Data Tables
Date-Time Functions   Data Validation
Display Formulas-Functions   Enter Field Names
Formulas   Filtering
Functions   Goal Seek
IF Functions   Scenarios
Link Workbooks   Sort Data
Name Groups of Data   Subtotals
     
Review Tab   View Tab
Comments   Workbook Views
Spell Checking    

Back to Home