Microsoft Excel Training Course – Level 4

This course is for advanced Excel users who want to update their skills in advanced data analysis. By its focus on working with nested functions, advanced Pivot Tables, complex use of Data Validation and Conditional Formatting, this course will give the skills to tackle the most complex data analysis. By completing structured exercises, using data relevant to your work, this course will increase your competence in advanced data analysis helping you meet those targets more efficiently. This course also prepares you for moving on to the Microsoft Excel VBA Course.

To get the most from this course you will have attended the Burningsuit Microsoft Excel Level 3 Course.

Or you have been using Excel for a reasonable length of time and you are competent in spreadsheet analysis work and have used formulae and functions. You now need to know how to use complex functions and perform difficult data analysis.

We specialise on on-site training and can come to you to run our course either on your PC’s or provide our own high specification equipment. If you want specific training for your staff, we’re happy to customise this course to your requirements, adding or removing topics as necessary

(Including Inquire Add-In for Excel 2013).

Download course informationGet a Quote for this Course

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