EXCEL Training

Learning Objectives

 
 
 

Beginner

  • Introduction to the Excel interface  

  • 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 

  • Formulas ribbon 

  • Building and using formulas and functions

  • Copying formulas/functions with the autofill command 

  • Relative and absolute cell References

  • Inserting rows & columns 

  • Moving, copying and pasting data 

  • Using autofill to complete a series of values 

  • Worksheet Themes 

  • Formatting worksheet data/Cell Styles 

  • 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 

  • Page Layout and Full Screen view 

  • Printing Your Worksheet 

 
 

Intermediate

  • List design

  • Formatting Lists As Tables

  • 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

  • Automatic subtotals in a list

  • Quick analysis tools

  • Creating, formatting and editing charts

  • Creating custom chart templates

  • Changing table and chart formatting through themes

  • Inserting sparkline

  • Creating Pivot Tables

  • Filtering Pivot Tables

  • Multi-Select slicers & timeline slicers

  • Working with Pivot charts

  • Data Validation rules

  • Built-in conditional formatting

  • Creating custom conditional formats

  • Comments

  • Linking data

  • Cell, sheet, and file protection

 

Advanced

  • Creating and applying names in a worksheet

  • IF Function

  • Nesting Functions

  • ROUND function

  • VLOOKUP Functions

  • Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)

  • IFERROR Function

  • Text Functions: Left, Right & Mid

  • Concatenate, Text-To-Columns

  • Formula auditing tools

  • Consolidate Data commands

  • Goal Seek and Solver tools

  • Data tables

  • Scenario Manager

  • Adding the Developer Tab to the ribbon

  • Recording and running macros

  • Creating buttons to run macros

  • Customizing the Ribbon

Don’t see the course you’re looking for?

Contact us for customized solutions to your training needs.