6 Free Excel 2003 Workshop Training Tutorials

Level 1 Classes: beginning topics designed to develop basic application skills.  
Level 2 Classes: intermediate topics that assume users have some working knowledge and experience with the application.
Level 3 Classes: advanced topics that assume the users have strong knowledge and experience but wish to extend their skills.

Level 1

Basic Excel Skills Training Manual

Learn all the basic skills necessary to start creating lists and tables of data in an Excel spreadsheet, as well as how to format it to be visually clear and attractive.

Topics:
  » The Excel Environment
  » Setting Up Your Data
  » Modifying Data And Worksheets
  » Formatting Your Data
  » Conditional Formatting

Excel Formulas and Functions Training Manual

This workshop will illustrate how to create formulas and functions in Excel so that your calculations are automated. 

Topics:
  » Creating Formulas
  » Creating Functions
  » Editing
  » Absolute Referencing
  » Auditing
Sample File

Using Multiple Excel Worksheets and Workbooks Training Manual

There are times when you might need to organize your data into multiple worksheets or even multiple workbooks.  This workshop will illustrate the tools, tips, and skills you need to manage your data and calculations that span multiple sheets and files. 

Topics:
  » Creating Formulas and Functions Across Spreadsheets
  » Moving Sheets to New Files
  » Creating Links
  » Protecting Sheets
  » Sharing
Sample File

Level 2

Excel Graphs Training Manual

Learn how to create graphs of your data.  It is quick and easy with the Chart Wizard.  The workshop includes tips on formatting your graphs to achieve the perfect visual results.

Topics:
  » Using the Chart Wizard
  » Editing your Graphs
  » Tips and Tricks
Sample File

Using Data Tools in Excel Training Manual

Excel has tools that enable database like record keeping right in your spreadsheet.  Use the tools to view and summarize your records the way you want. 

Topics:
  » Sorting
  » Autofilter
  » Advanced Filter
  » Importing Data
  » Saving as a .csv
  » Group and Outline
Sample File

Level 3  

Excel Macros Training Manual

Automate the tasks you need to do repeatedly, or make quick shortcuts.  Macros allow you to record a string of commands that will execute automatically.  This workshop teaches macros within the context of Excel, but the skills are applicable in Word as well.

Topics:
  » Recording a Macro
  » Running a Macro
  » Debugging and Editing a Macro
Sample File

Popularity: 9% [?]