Log On/Register  

855.838.5028

Excel

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

Microsoft Excel Training Courses

Learn iT! offers training courses for various versions of Microsoft Excel including 2016, 2013, 2010 and earlier. Our Excel training classes are delivered by our world-class trainers ready to help you or your employees get the most out of Microsoft Excel.  Excel students currently have the options of taking excel courses in a variety of formats, Instructor-Led, live online, private, and E-learning.

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. Browse our various Microsoft Excel training courses today, and register online!

Excel: Day 1

Module 1: Excel Essentials & Intro to Formulas and Functions 

  • Introduction to The Excel 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 

 

Excel: Day 2

 

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 
  • Recommended Charts 
  • 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:  Pivot Tables, Protecting & Linking Data 

  • 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 

 

Excel: Day 3

 

Module 5: Advanced Functions 

  • Creating And Applying Names In A Worksheet 
  • Using The IF Function 
  • Introduction To Nesting Functions 
  • The ROUND function 
  • 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 
  • Other Useful Functions 
     

  

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 
  • Introductions to Editing Macros with the Visual Basic Editor 
  • Creating Buttons to Run Macros 
  • Customizing the Ribbon 

Microsoft Excel Training Courses

Learn iT! offers training courses for various versions of Microsoft Excel including 2016, 2013, 2010 and earlier. Our Excel training classes are delivered by our world-class trainers ready to help you or your employees get the most out of Microsoft Excel.  Excel students currently have the options of taking excel courses in a variety of formats, Instructor-Led, live online, private, and E-learning.

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. Browse our various Microsoft Excel training courses today, and register online!

Excel: Day 1

Module 1: Excel Essentials & Intro to Formulas and Functions 

  • Introduction to The Excel 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 

 

Excel: Day 2

 

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 
  • Recommended Charts 
  • 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:  Pivot Tables, Protecting & Linking Data 

  • 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 

 

Excel: Day 3

 

Module 5: Advanced Functions 

  • Creating And Applying Names In A Worksheet 
  • Using The IF Function 
  • Introduction To Nesting Functions 
  • The ROUND function 
  • 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 
  • Other Useful Functions 
     

  

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 
  • Introductions to Editing Macros with the Visual Basic Editor 
  • Creating Buttons to Run Macros 
  • Customizing the Ribbon 
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited, used under permission of AXELOS Limited. The Swirl logo is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.