Why take an Excel class with Chris Menard? Chris Menard is the first Microsoft Office Master Instructor in the world. He was featured on

Microsoft's training website and the Atlanta Journal twice. Just some of Menard's clients include:

1. Coca-Cola
2. Mizuno USA
3. Georgia-Pacific
4. Executive MBA students at the University of Georgia
5. Gwinnett Medical Center

In 2009, Menard created an Excel training video for Coca-Cola that went out to over 150 countries. He has also been featured on Certiport's Website twice, and featured in Yahoo Business News.

When Chris isn't teaching, he blogs about technology topics, and is a public speaker for the Georgia Society of CPAs (since 2005), and the University of Georgia's Administrative Profession Day conference for the past seven years. Many of the extra features covered in this course are from questions asked during his instructor-led training.

Covered in this Excel level 2 class, also know as Excel Intermediate, are a lot of data analysis features in Excel. All of the videos have Closed captioning (CC) available. Student files for every course can be downloaded so it is easy to follow along. Also available are Chris Menard's tips and tricks.

Table of contents for Excel Intermediate

Unit 1: Managing workbooks and worksheets

• Topic A: Viewing and printing large worksheets
• Topic B: Printing large worksheets
• Topic C: Working with multiple worksheets
• Topic D: Linking worksheets with 3-D formulas
• Topic E: Using multiple workbooks
• Topic F: Linking workbooks

Unit 2: Advanced formatting

• Topic A: Using special number formats
• Topic B: Working with themes
• Topic C: Other advanced formatting

Unit 3: Outlining and subtotals

• Topic A: Outlining and consolidating data
• Topic B: Creating subtotals

Unit 4: Cell and range names

• Topic A: Creating and using names
• Topic B: Managing names

Unit 5: Data structure and tables

• Topic A: Sorting and filtering data
• Topic B: Working with tables

Unit 6: Web and sharing features

• Topic A: Saving workbooks as Web pages
• Topic B: Using hyperlinks

Unit 7: Documenting and auditing

• Topic A: Auditing features
• Topic B: Comments in cells and workbooks
• Topic C: Protection
• Topic D: Workgroup collaboration