Due to the Coronavirus (COVID-19), the health and safety of our students, visitors, staff and the community at large is our first priority. Social distancing is a must, as such Microtrain will be delivering courses using a remote live solution for all courses until further notice.

Now is the time for us to come together to support each other and tackle the challenges we are facing. Please let us know what we can do for you during this time; we’re always here to assist and help however we can.

We invite you to share your insights, ideas, and strategies with us at requests@microtrain.net.

About this Course

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, inserting graphics, and enhancing workbooks. This course is broken up into lessons. Each lesson focuses on several key topics, each of which are broken down into easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions for you to answer. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.


Lesson 1: Enhancing Workbooks

Lesson 2: Organizing Worksheet Data with Tables

Lesson 3: Visualizing Data with Charts

Lesson 4: Creating Advanced Formulas

Lesson 5: Analyzing Data with Logical and Lookup Functions

Lesson 6: Inserting Graphics


This class assumes the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Excel 2016 courseware, including:

§  Using absolute, relative, and mixed references

§  Using formulas and functions in a worksheet

§  Managing and organizing worksheets

§  Editing and formatting Excel data

§  Printing and saving Excel files

§  Customizing the Excel interface

Exam Pass Guarantee

At Microtrain we are committed to your success! Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Raves & Praise

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top