Microsoft Excel Advanced Training Course

Course length – 1 day

Pre-requisites:

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

Objectives:

  • Work with and identify Excel functions and calculations
  • Analyse your data
  • Create and change PivotTables and PivotCharts
  • Protect data and workbooks
  • Share your workbook and track the changes to data
  • Record simple macros to automate repetitive tasks
  • Customising Excel

Topics:

Customising Excel
  • Options, ribbons and Quick Action
    Toolbar
More Excel Functions
  • Review of functions
  • Examine more functions (Date
    Text, Financial, Database)
Auditing a Worksheet
  • Working with Comments
  • Displaying formulas
  • Finding, viewing and identifying
    formulae and functions
  • Watch and evaluate formulas
What If Analysis
  • Data tables
  • Scenarios
  • Goal seek
Working with Large Data
  • Group & Outline
  • SubTotals
  • Advanced filter
PivotTables
  • Creating and changing a PivotTable
  • Layout and formatting
  • Changing calculations
  • Slicers and Timelines (2013/2016)
  • Refreshing the PivotTable data
  • Recommended PivotTables (2013/2016)
  • Inserting a PivotChart
Protecting your Data
  • Protecting worksheet cells
  • Applying passwords to a workbook
  • Use Data Validation to restrict data input
Templates
  • Create and use a template
Shared Workbooks
  • Sharing your workbook
  • 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

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

The topics in this course can be mixed and matched with Excel Intermediate and/or Excel Introduction if required.

Prices

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

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

We recommend no more than 8 people on a course.