Microsoft Excel 2016 Complete Mastery Online Training Course

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

Course Outline

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

PART 1 : BASICS

CHAPTER 01: MICROSOFT® EXCEL 2016 BASICS 4:04:11

• Introduction
• Selecting and Navigating
• Keyboard Navigation and Basic Data Entry
• The Ribbon
• The Quick Access Toolbar
• Creating a New Spreadsheet
• Compatibility Issues
• Cell Data & Data Types
• Accessing Help
• Creating Worksheet Formulas
• Insert Functions
• Re-using Formulas and Functions
• Insert, Delete, & Adjust Columns & Rows
• Find and Replace
• Use Proofing and Research Tools
• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Applying Styles and Themes
• Conditional Formatting
• Creating and Using Templates
• Preview and Print a Notebook
• Page Layout
• Configure Headers and Footers
• Managing Worksheets
• View Options
• Managing Workbook Properties

PART 2 : INTERMEDIATE

CHAPTER 01: FUNCTIONS 1:11:52

• Working with Named Ranges
• Using Named Ranges in Formulas
• Using Specialized Functions
• Working with Logical Functions
• Displaying Functions/Formulas
• Nesting Functions
• Date and Time Functions
• Text Functions

CHAPTER 02: DATA 32:24

• Sorting Data
• Filtering Data
• Using Database Functions
• Using Subtotals

CHAPTER 03: TABLES & CONDITIONAL FORMATTING 22:11

• Create and Modify Tables
• Manipulating Table Data
• Conditional Formatting Rules
• Using Logical Functions with Conditional Formatting

CHAPTER 04: CHARTS 28:35

• Creating Charts
• Modifying and Formatting Charts
• Creating a Dual Axis Chart
• Chart Templates

CHAPTER 05: SHAPES, TABLES, SLICERS & MORE 36:39

• Formatting Shapes and Objects
• Creating a PivotTable
• Analyzing PivotTable Data
• Pivot Charts
• Slicers and Timelines

PART 3 : ADVANCED

CHAPTER 01: MICROSOFT® EXCEL 2016 ADVANCED 2:53:26

• Using Links and External References
• Using 3D References
• Consolidating Data
• Using Lookup Functions, Part 1
• Using Lookup Functions, Part 2
• Tracing Precedent and Dependent Cells
• Watching and Evaluating Formulas
• Comments and Track Changes
• Comparing and Merging Workbooks
• Accessibility Checker
• Protecting Worksheets and Workbooks
• Applying Data Validation
• Search for Invalid Data
• Working with Macros, Part 1
• Working with Macros, Part 2
• Creating Sparklines
• 3D Maps
• Data Tables
• Using Scenarios
• Goal Seek
• Forecasting Data Trends
• Changing Your Display
• Importing Delimited Text Files
• Data Forms and Form Controls
• Calculated Fields and Cube Functions

Learn anytime, anywhere, at home or on the go.
Length of Subscription: 12 Months Online On-Demand Access
Running Time: 10 hours 10 min
Platform: Windows & MAC OS
Level: Beginner to Advanced

Stream your training via the internet, or download to your computer and supported mobile device, including iPad™, iPhone™, iPod™ Touch and most Android devices.