The world is filled with two kinds of people: those who are masters at Excel and the millions who wish they were.

The world is filled with two kinds of people: A handful of people who are masters of Excel, and the millions of others who wish they were
When you master Microsoft Excel 2016, you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet expert can work wonders – from organizing lists to creating multi-layered, interactive reports. Spreadsheets can help businesses make decisions on critical issues involving accounting, budget allocations, expenditures, and inventory. This course builds on your existing knowledge of Excel and teaches you how to manage data, charts, and tables, including using tools such as Pivot Tables, Pivot Charts, Slicers, and Timelines.
Excel is our most requested training course! Once you learn Excel, you’ll quickly see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Barbara Evers walk you through additional features offered in Microsoft Excel 2016.
Topics covered include: - Working with named ranges and formulas - Using Logical, Text, Date, and other functions - Sorting, filtering, and summarizing data - Creating and modifying charts and tables - Creating Pivot Tables and Pivot Charts - Using Conditional Formatting - Adding Slicers and Timelines to analyze information
Quickly search and find the skills you want to master—then just point, click, and learn.
Enjoy over three hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Note: When combined with the Basics and Advanced versions of this course, you will cover all the objectives required in the Microsoft Office Specialist exam 77-727

Powering Productivity, One Brain at a Time!
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.