Log On/Register  

855.838.5028

Excel 2016

Duration: 3 Days, 6 Modules
Module Price: $130

Module 1: Excel Essentials & Intro to Formulas and Functions

  • Introduction To The Excel 2016 Interface 
  • Tell Me
  • Zooming In And Out Of A Worksheet
  • Navigating And Selecting Cells
  • Keyboard Shortcuts
  • Entering And Editing Data
  • Smart Lookup
  • Deleting/Replacing Cell Data
  • Performing Simple Calculations
  • Saving The Workbook File
  • Checking Compatibility With Older Versions Of Excel
  • Overview Of The Formulas Ribbon
  • Building Basic Formulas
  • Using Simple Functions
  • Copying Formulas/Functions With The Autofill Command
  • Using Relative And Absolute Cell References In Calculations

 

 Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

  • Inserting Rows & Columns
  • Moving, Copying And Pasting Data
  • Using Autofill To Complete A Series Of Values
  • Introduction To Worksheet Themes
  • Formatting Worksheet Data/Using Cell Styles
  • Using Excel Templates/Creating Custom Templates
  • Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy
  • Grouping Worksheets
  • Freezing Or Splitting Panes
  • Grouping And Hiding Rows/Columns
  • Creating Custom Views
  • Spell Checking Your Worksheets
  • Setting Print Options Through Page Setup
  • Using The Page Layout View
  • Using The Full Screen View
  • Printing Your Worksheet

 

 Module 3: List/Table Essentials & Charting

  • Overview Of List Design
  • Formatting Lists As Tables
  • Using The Flash Fill Option
  • Single And Multi-Level Sorting
  • Removing Duplicates From A List Or Table
  • Filtering Records In A List Or Table
  • Search By Filter
  • Inserting Automatic Subtotals In A List
  • Using The Quick Analysis Tools
  • Inserting Data Charts
  • New 2016 Chart Types (Waterfall, Sunburst & More)
  • Formatting And Editing Chart Elements
  • Adding/Removing Data From A Chart
  • Creating Custom Chart Templates
  • Printing Charts
  • Changing Table And Chart Formatting Through Themes
  • Inserting Sparkline

 

 Module 4: Importing Data, Pivot Tables, Protecting & Linking Data

  • Importing Data From Other Sources
  • Overview Of Exporting Options
  • Creating A Database Query
  • Creating Pivot Tables From Lists Or Tables
  • 2016 Pivot Table Enhancements
  • Filtering Pivot Tables
  • Multi-Select Slicers & Timeline Slicers
  • Working With Pivot Charts
  • Data Validation Rules
  • Applying Built In Conditional Formatting
  • Creating Custom Conditional Formats
  • Comments
  • Linking Data
  • Cell, Sheet, And File Protection

 

 Module 5: Creating Advanced Functions

  • Creating And Applying Names In A Worksheet
  • Using The IF Function
  • Introduction To Nesting Functions
  • Using the Formula Auditing Tools
  • VLOOKUP Functions
  • Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
  • Using The IFERROR Function
  • Text Functions: Left, Right & Mid
  • Concatenate, Text-To-Columns & Flash Fill
  • Round Function

 

 Module 6: Using the "What If" Analysis Tools & Recording Macros

  • Using the Consolidate Data commands
  • Using the Goal Seek and Solver tools
  • Creating Data Tables
  • Using the Scenario Manager
  • Adding the Developer Tab to the Ribbon
  • Recording and Running Macros
  • Editing Macros with the Visual Basic Editor
  • Creating Buttons to Run Macros
  • Microsoft OneDrive Overview
  • Simplified Sharing
  • Customizing the Ribbon

Module 1: Excel Essentials & Intro to Formulas and Functions

  • Introduction To The Excel 2016 Interface 
  • Tell Me
  • Zooming In And Out Of A Worksheet
  • Navigating And Selecting Cells
  • Keyboard Shortcuts
  • Entering And Editing Data
  • Smart Lookup
  • Deleting/Replacing Cell Data
  • Performing Simple Calculations
  • Saving The Workbook File
  • Checking Compatibility With Older Versions Of Excel
  • Overview Of The Formulas Ribbon
  • Building Basic Formulas
  • Using Simple Functions
  • Copying Formulas/Functions With The Autofill Command
  • Using Relative And Absolute Cell References In Calculations

 

 Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

  • Inserting Rows & Columns
  • Moving, Copying And Pasting Data
  • Using Autofill To Complete A Series Of Values
  • Introduction To Worksheet Themes
  • Formatting Worksheet Data/Using Cell Styles
  • Using Excel Templates/Creating Custom Templates
  • Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy
  • Grouping Worksheets
  • Freezing Or Splitting Panes
  • Grouping And Hiding Rows/Columns
  • Creating Custom Views
  • Spell Checking Your Worksheets
  • Setting Print Options Through Page Setup
  • Using The Page Layout View
  • Using The Full Screen View
  • Printing Your Worksheet

 

 Module 3: List/Table Essentials & Charting

  • Overview Of List Design
  • Formatting Lists As Tables
  • Using The Flash Fill Option
  • Single And Multi-Level Sorting
  • Removing Duplicates From A List Or Table
  • Filtering Records In A List Or Table
  • Search By Filter
  • Inserting Automatic Subtotals In A List
  • Using The Quick Analysis Tools
  • Inserting Data Charts
  • New 2016 Chart Types (Waterfall, Sunburst & More)
  • Formatting And Editing Chart Elements
  • Adding/Removing Data From A Chart
  • Creating Custom Chart Templates
  • Printing Charts
  • Changing Table And Chart Formatting Through Themes
  • Inserting Sparkline

 

 Module 4: Importing Data, Pivot Tables, Protecting & Linking Data

  • Importing Data From Other Sources
  • Overview Of Exporting Options
  • Creating A Database Query
  • Creating Pivot Tables From Lists Or Tables
  • 2016 Pivot Table Enhancements
  • Filtering Pivot Tables
  • Multi-Select Slicers & Timeline Slicers
  • Working With Pivot Charts
  • Data Validation Rules
  • Applying Built In Conditional Formatting
  • Creating Custom Conditional Formats
  • Comments
  • Linking Data
  • Cell, Sheet, And File Protection

 

 Module 5: Creating Advanced Functions

  • Creating And Applying Names In A Worksheet
  • Using The IF Function
  • Introduction To Nesting Functions
  • Using the Formula Auditing Tools
  • VLOOKUP Functions
  • Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
  • Using The IFERROR Function
  • Text Functions: Left, Right & Mid
  • Concatenate, Text-To-Columns & Flash Fill
  • Round Function

 

 Module 6: Using the "What If" Analysis Tools & Recording Macros

  • Using the Consolidate Data commands
  • Using the Goal Seek and Solver tools
  • Creating Data Tables
  • Using the Scenario Manager
  • Adding the Developer Tab to the Ribbon
  • Recording and Running Macros
  • Editing Macros with the Visual Basic Editor
  • Creating Buttons to Run Macros
  • Microsoft OneDrive Overview
  • Simplified Sharing
  • Customizing the Ribbon
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):