Microsoft Excel 2003

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 hereScroll down the page until you locate the information on Extracting Files.

Program Elements

 

Workbooks/Worksheets

   Basic Elements  

   Create a Worksheet

   Formatting Toolbar  

   Insert Headers and/or Footers

   Menu Bar  

   Move Around the Worksheet

   Standard Toolbar

     Range Names
   Sheet Tabs      Spell Check a Worksheet and/or Workbook
     
 Charts   Databases
   Add and Delete Data Series      Conditional Formatting
   Change a Chart Type      Enter Field Names and Data
   Change the Location of a Chart      Enter a Series of Data Automatically
   Chart Elements       Filter a Database
   Create Column Charts      Insert Subtotals
   Create Pie Charts        Search for Records
   Draw on a Chart      Sort Data
   Edit a Chart      Use the Data Form
   Enhance a Chart      What is a Database?
   Format the Chart    
   Move and/or Resize a Chart    Previewing/Printing
   Plan a Chart      Change Page Setup in Print Preview
   Tasks Performed with the Chart Wizard      Print a Workbook or Worksheet
       Print Row and Column Titles on Every Page
Formulas/Functions      View Selected Sheets in a Workbook
   Copy, Embed, and Link Worksheets and Charts    
   Data Consolidation   What-If Analysis
   Data Validation      Goal Seek
   Date and Time Functions      Scenarios
   Display Formulas and Functions    
   Find and Correct Errors in Calculations   Web Pages/Workgroup Collaboration
   IF Functions      Insert Comments
   Link Workbooks      Merge Workbooks
   Lookup Functions      Save Workbooks as Web Pages
   Payment Functions      Share Workbooks
   Work with Formulas      Review, Accept, and Reject Changes
   Work with Functions      Track and Manage Changes
   Work with Worksheet Groups    
   Year Function   Additional Worksheet Features
       Auto Fill
Worksheet and Workbook Protection      Clip Art
   Apply and Remove File Passwords      Styles
   Worksheet-Workbook Protection      Word Art

Back to Home