Excel 2016: Mastering Excel 2016

$149.97 $30.00

This 3-part ’Mastering Excel 2016’ course includes basic, intermediate, and advanced level lessons. Learn about functions, charts, macros, Sparklines, and so much more.  By the time you’ve completed this 10+ hour training, you’ll be a Microsoft Excel master.

Length: 10 hrs 10 min

This title is available in the
Total Training All-Access library.

Subscribe Now


This complete ’Mastering Excel 2016’ training course gets you up and running with Microsoft Excel 2016. Start by learning to navigate the interface and familiarizing yourself with the essential tools. Then move on to working with Functions, Data, Charts, and Tables. Finish up by learning advanced features such as Macros, Sparklines, 3D Maps, and more!

If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are are an experienced Excel user, let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through everything you need to know about Microsoft Excel 2016, including:

  • The basics of Functions and Formulas
  • Managing Workbook properties
  • Sorting, Filtering, and Summarizing Data
  • Creating PivotTables and Pivot Charts
  • Using Scenarios and Goal Seek
  • Working with Macros
  • Using Data Forms and Form Controls

Sample clip




  1. Introduction
  2. Selecting and Navigating
  3. Keyboard Navigation and Basic Data Entry
  4. The Ribbon
  5. The Quick Access Toolbar
  6. Creating a New Spreadsheet
  7. Compatibility Issues
  8. Cell Data & Data Types
  9. Accessing Help
  10. Creating Worksheet Formulas
  11. Insert Functions
  12. Re-using Formulas and Functions
  13. Insert, Delete, & Adjust Columns & Rows
  14. Find and Replace
  15. Use Proofing and Research Tools
  16. Apply Text Formats
  17. Apply Number Formats
  18. Align Cell Contents
  19. Applying Styles and Themes
  20. Conditional Formatting
  21. Creating and Using Templates
  22. Preview and Print a Notebook
  23. Page Layout
  24. Configure Headers and Footers
  25. Managing Worksheets
  26. View Options
  27. Managing Workbook Properties


1. Working with Named Ranges
2. Using Named Ranges in Formulas
3. Using Specialized Functions
4. Working with Logical Functions
5. Displaying Functions/Formulas
6. Nesting Functions
7. Date and Time Functions
8. Text Functions

CHAPTER 02: DATA 32:24
1. Sorting Data
2. Filtering Data
3. Using Database Functions
4. Using Subtotals

1. Create and Modify Tables
2. Manipulating Table Data
3. Conditional Formatting Rules
4. Using Logical Functions with Conditional Formatting

1. Creating Charts
2. Modifying and Formatting Charts
3. Creating a Dual Axis Chart 
4. Chart Templates

1. Formatting Shapes and Objects
2. Creating a PivotTable
3. Analyzing PivotTable Data
4. Pivot Charts
5. Slicers and Timelines



  1. Using Links and External References
  2. Using 3D References
  3. Consolidating Data
  4. Using Lookup Functions, Part 1
  5. Using Lookup Functions, Part 2
  6. Tracing Precedent and Dependent Cells
  7. Watching and Evaluating Formulas
  8. Comments and Track Changes
  9. Comparing and Merging Workbooks
  10. Accessibility Checker
  11. Protecting Worksheets and Workbooks
  12. Applying Data Validation
  13. Search for Invalid Data
  14. Working with Macros, Part 1
  15. Working with Macros, Part 2
  16. Creating Sparklines
  17. 3D Maps
  18. Data Tables
  19. Using Scenarios
  20. Goal Seek
  21. Forecasting Data Trends
  22. Changing Your Display
  23. Importing Delimited Text Files
  24. Data Forms and Form Controls
  25. Calculated Fields and Cube Functions

Barbara EversIt doesn’t take long for people who meet Barbara Evers to recognize her talents in written and verbal communication. Tapping into this strength, Barbara has found success in many facets of her life. Her mission is to help others do the same professionally and personally.

Barbara received a Bachelor of Arts degree in Zoology and a Master of Arts in Professional Communication from Clemson University. She is an active member of the Association for Type International, and her certifications include:

  • Myers Briggs Type Indicator
  • Coaching Using Multiple Models
  • Global Corporate College (GCC)
  • Development Dimensions International (DDI)
  • Zig Ziglar
  • Achieve Global

Barbara  has over twenty-five years’ experience in training and public speaking with an emphasis in Career Development. With a broad list of clients in the corporate, non-profit, and government arenas, she excels in teaching participants the skills and techniques that will advance their careers. Her educational and career pursuits have provided a diverse background for her to use in instructional design and in the classroom.  She draws from this experience to customize her materials and provide a valuable, interactive experience for each participant. Her areas of expertise include Communication, Customer Service, Management, and Leadership as well as software training. 

Barbara lives in Greer, SC and is a published writer and the recipient of several writing awards, including a Pushcart Prize nomination. She writes for several blogs including two of her own and is an active member of South Carolina Writers Association and HubCity Writers.

For more information, visit her website, http://eversworks.com/ and her writing blog, https://aneclecticmuse.blogspot.com/.

Christina Tankersley

Christina Tankersley has been involved with software education and project management since 1994. Her career includes working on software development and varying manufacturing projects, helping people understand the power of diverse thinking, and continue to learn tools to share with customers, students, and the population at large.


Her primary focus for instruction includes:

  • Project Management
  • Leadership
  • Microsoft Software
  • Herrmann Brain Dominance Index
  • Customer Relationship Management Tools
  • Business Analysis
  • Information Technology Infrastructure Library

She has a BS in Business from the University of Charleston, an MBA from North Greenville University, and certifications including Project Management Professional (PMP), Comptia A+, Comptia Certified Technical Trainer, and Microsoft Certified Trainer.

When not working or studying, she loves to travel, read, and spend time with friends and family.

You may also like…