Microsoft Excel Training Level 4 Course Contents - Duration: 1 day
Review Naming Cells and Ranges
- Correctly create named cells and use names in formulas accurately.
Advanced Use of Names
- Use names as “constants” and in complex formula work.
- Use Names to simplify formulas.
- Use Scope to duplicate names.
Advanced features of Excel Analysis Tables
- Using Excel Tables to analyse data
- Using implicit names automatically generated by Tables
Nesting Functions
- Nest functions by accurately putting one function inside another so that you can “customise” functions.
Concatenation
- In a single cell, accurately string together cell values, text and formulas into a single value.
Advanced Function Workshop
- Workshop session using a selection of challenging functions eg:- strong>And, Or, Match, Index, Indirect, Text Functions, Date Functions, IfError
Working with Advanced Pivot Tables
- Creating Dashboards using Slicers
- Consolidate Data using a PivotTable
- Create Calculated Items
- Create Calculated Fields
- Create a PivotChart reports
- Creating “Flattened” Pivots
- UnPivoting data
Brief Overview of Power Pivot
- How you can use the Data Model to create Pivot Tables for multiple data sources.
Brief Overview of Power Query
- How you can clean and transform data prior to analysing it
Advanced Use of Conditional Formatting
- Use conditional formatting to compare data ranges
- Use functions within conditional formatting
- Format entire rows of data rather than single cells
Working with Arrays
- Use Array Formulas to analyse data stored in a range of adjacent cells..
*Only applicable in an Excel 2013 training course
Speak to a trainer now
0800 0199 746
for any questions about the courses we offer