skillstopaythebills

MS Excel 2010 - Level 3

Course Length: 8 Hours (Three sessions)

Description: This course explores Excel's advanced analysis features. Students learn to create and modify custom templates and how to validate input data. We cover protection for both worksheets and workbooks. Students experiment with advanced analysis features (What-If and Pivot Tables).

Please note that this course is most effective if students can practice on their own computer between classes.

Prerequisite: Excellent working knowledge of Excel

Next Start Date:  June 17, 2013

Registration Deadline:  June 3, 2013

Tuition: $184 + Tax

Manual: (Required): $70 + Tax

Topics:

  • Functions (Lookup, Database, Logical, Statistical)
  • Templates
  • Data Validation
  • Protecting Worksheets
  • Analysis Tools

(Content for this course is currently under review and subject to change)