MS Excel - intermediate

Unlock the power of Microsoft Excel 2003. Excel is a spreadsheet package that provides the tools to access, process, analyse and display numeric and financial information, accurately and professionally.

This is the second of three MS Excel courses offered by Tooling Intelligence. If you don't already have a basic understanding of Excel you will need to look at our MS Excel Introduction course, or if you need a more advanced level of Excel training look at our MS Excel Advanced course.

Course outline

  • Window Menus
    • Freezing Titles and Using Panes
    • Viewing several Workbooks at a Time
    • Renaming, moving, deleting Worksheets
  • Using Workbooks
    • Grouping Worksheets
    • Entering and Editing Data in Groups
    • Copying Across Grouped Sheets
    • Linking Workbooks and Sheets
  • Outlining
    • Automatic Outline
    • Manual Outline
    • Displaying Different Levels
  • Databases and Filters
    • Sorting
    • Using a Data Form
    • Using Criteria to Search
    • Autofilter and Advanced Filter
  • Conditional Logic
    • The IF Function
    • Multiple Conditions
  • Macros
    • Recording a Macro
    • Running a Macro
  • Introduction to Charts
    • Using the Chart Wizard
    • Chart Types
    • Chart Elements
    • Embedded Charts and Chart Sheets
    • Printing Charts
    • Enhancing Charts