Excel 2016 Intermediate

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

   Watch Promo
 

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

Welcome to my site! I'm employed full-time as a Senior Training Specialist for SurePoint Technologies, headquartered in Cincinnati, Ohio. I love training, and my YouTube channel has over 700 technology videos covering Excel, Word, Gmail, Google Calendar, Zoom, Teams, Personal Finance in Excel, PowerPoint, and other applications.

You can view my Microsoft credential here.

In the past, I have trained the following clients:

  • Gwinnett Medical Center
  • Coca-Cola in Atlanta
  • Mizuno USA
  • The University of Georgia
  • The Georgia Society of CPAs
  • Clayton County Water Authority
  • Georgia-Pacific in Atlanta
  • Ronald Blue Trust – CPAs
  • Sparkmon & Associates – CPAs

My current public speaking client list includes The Georgia Society of CPAs, the Continuing Education Center for the University of Georgia, the Terry College of Business Executive MBA students, and the Professional MBA students.

Thank you for visiting my site.


Course Curriculum


  Before you begin
Available in days
days after you enroll
  Unit 1 - Managing workbooks and worksheets
Available in days
days after you enroll
  Unit 2: Advanced formatting
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!