Course Levels and Duration
We can provide training on all versions of Microsoft Excel at Foundation, Intermediate, Intermediate+ and Advanced levels. All courses are 1 day in duration and delivered onsite at your own offices.
Excel Foundation
- Entering & editing data: shortcuts & tips to increase productivity
- Formatting text and values
- Resizing data, formatting data & cell colours
- Formatting data types: values, currency, dates
- Modifying worksheets
- selecting / resizing columns & rows
- entering & deleting columns & rows
- moving & copying data
- renaming worksheet tabs
- Adding & working with comments and notes
- Constructing basic formulas
- Adding, subtracting, multiplying & dividing
- Combining formulas & when to use brackets
- Calculating percentages
- Introduction to Excel functions
- How to use SUM, MIN, MAX, AVERAGE, COUNT & COUNTA
- Using functions to analyse data
- Working with large spreadsheets
- Filtering data
- Using Freeze Panes
- Hiding columns and rows
- Introduction to Excel charts
Excel Intermediate
- Using absolute cell references
- Copying formulas
- Linking formulas across worksheets
- Conditional formatting
- Creating custom rules
- Highlighting cell colours
- Conditional logic
- Using the IF function
- Outputting text
- Working with the VLOOKUP function
- Searching databases
- Understanding range lookup types
- Data validation
- Creating drop-down menus
- Using validation menus with VLOOKUP functions
- Introduction to Pivot Tables
- Sorting & filtering data
- Grouping & sub-totalling
- Creating Pivot Charts
Excel Intermediate plus
- Nested functions
- Working with AND & OR
- Nesting multiple IF functions
- Maths & Statistical functions
- SUMIF, COUNTIF, AVERAGEIF
- SUMIFS, COUNTIFS, AVERAGEIFS
- Using the MATCH & INDEX functions as an alternative to VLOOKUP
- Working with Text Data
- Using Text to Columns on imported data
- Tidying the database
- Using the TRIM function
- FIND & MID functions
- Working with FLASHFILL
- Advanced PivotTables
- Working with multiple columns & fields
- Using the filter fields
Excel Advanced
- Working with Tables
- Naming tables
- Entering rows & columns
- Working with total rows
- Formatting table styles
- Advanced conditional formatting
- Using formulas to determine which cells to format
- Highlighting whole rows
- Checking data length
- Working with array formulas
- Understanding array formulas & their uses
- Using the TRANSPOSE function
- The OFFSET function
- Querying databases
- Creating dynamic graphs
- Using the database functions
- DSUM, DAVERAGE, DCOUNT
- Using SLICERS with Pivot Tables & Pivot Charts
- Creating a dashboard with Pivot Tables, Pivot Charts & Slicers
- Introduction to Power Query & Power Pivot
- Importing data from multiple files & sources
- Creating Queries
- Transforming data