Microsoft Excel 2013/2016 Level 3 Training Course

Functions, Analysis & Automating

Course length – 1 day

Pre-requisites:

Delegates should have knowledge of the topics from, or have attended, the Excel Level 1 and Level 2 courses. It is essential that they have an understanding and are able to use calculations and simple formula.

Objectives:

  • Working with Excel functions
  • What if analysis
  • Using data valuation
  • Create and change PivotTables
  • Analyse your data
  • Share and track the changes to data
  • Record a macro
  • Customising Excel

Topics:

Working with Excel Functions
  • Logical (IF, SumIF, CountIF)
  • Vlookup, Hlookup
  • Database functions
  • Nested functions
Naming Ranges
  • Define, change and use names
What If Analysis
  • Data tables
  • Scenarios
  • Goal seek & solver
  • Conditional formatting
PivotTables
  • Creating and changing a PivotTable
  • Layout and formatting
  • Changing calculations
  • Slicers and Timelines
  • Refreshing the PivotTable
  • Inserting a PivotChart
Data Validation
  • Restrict data input
  • Creating a data validation list
Shared Workbooks
  • Sharing your workbook with others
  • Resolving conflicts
  • Tracking changes
  • Viewing change history
  • Remove a workbook from shared use
  • Use the reviewing toolbar
Macros
  • Recording and using simple macros
  • Assigning a macro to a shortcut key or button
Templates
  • Create and use a template
Customising Excel
  • Options, ribbons and toolbar

Topics not what you require? More information required? Contact us to discuss.

The topics in this course can be mixed and matched with Excel Level 2 and/or Excel Level 1 if required.


Prices

1 to 1 training: £299 + VAT per day
Each additional person: £40 + VAT per day

We come to you.  Courses take place at your offices.

We recommend no more than 8 people on a course.