Harxwmh0s4ypgxztfw5s

Excel 2016 Intermediate

Learn Excel the right way with Microsoft Office Master Instructor Chris Menard

   Watch Promo

Click here for August 2017 special. Get this class for $29.

 

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

Chris Menard and Gracie the Beagle - Excel Trainer

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


Your Instructor


Chris Menard
Chris Menard

Chris Menard is a Microsoft Office Master Instructor and have been featured on Microsoft's website, Yahoo Business News, and the Atlanta Journal twice. He created an Excel video for the Coca-Cola Company in Atlanta that went out to over 150 countries.

Client list includes:

  1. Executive MBAs at the University of Georgia
  2. Gwinnett Medical Center
  3. Georgia-Pacific
  4. Coca-Cola in Atlanta
  5. Mizuno USA
  6. Kids II in Atlanta
  7. The Georgia Society of CPAs
  8. Ronald Blue CPAs
  9. Many other companies

Chris previously worked for Georgia-Pacific and IBM and has a BBA in Accounting.

Links for Chris Menard



Class Curriculum


  Before you begin
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
What version of Excel do I need?
The course was designed using Excel 2016 for the PC, but prior versions of Excel for the PC or Mac will work. When Chris teaches the Executive MBA students they are on a variety of Excel versions.
Do you have closed captions?
Yes. All the videos have closed captions. Closed captioning displays the audio portion of our videos as text on your monitor. Closed captioning was developed for individuals who are deaf or hard-of-hearing, but it is used by everyone. We went through our CC to make sure the right word is spoken and make our videos ADA approved.

Get started now!