Microsoft Excel Intermediate Course

Excel
Program Objective: Students will learn how to create more advanced Charts, database functions, logical formulas, creating Range Names, and working with large spreadsheets more efficiently.

Course Outline:

  • Various methods of selecting cells
  • Creating Range Names
  • Absolute Reference
  • Working with Logical formulas
  • Conditional formatting
  • Inserting Comments
  • Track Changes – the snitch report!
  • Working & Printing large Spreadsheets
  • Using Data Sort & Filters
  • Creating an Outline
  • Goal Seek
  • Creating Scenarios
  • Macros
  • Creating Subtotals
  • Grouping Spreadsheets
  • Advanced Linking of Spreadsheets
  • And of course, finding options in this new 2010 version

There are 11 practice examples you will work with in this 10-hour course. With the course divided into five 2-hour sessions, you are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!

Prerequisite: Introduction to Excel and a good working knowledge of the computer.