Excel 2016 Advanced Training Courses – Online or Face to Face

Duration: 1 Day

Course Objective:

Creating, Maintaining, Filtering and using Subtotals in a List Recording, Assigning and Using Macros, Creating and Using User Defined Functions, Performing “What If” Analyses, Working with Scenarios, Querying a Database, Importing, Exporting Files and Data, Protecting Data, Pivot Tables, Reports and Charts. Other Advanced Business Analysis Tools.

Course Contents:

Working with Lists

  • Creating a List
  • Maintaining a List
  • Editing Records Using the Data Form
  • Filtering a List
  • Using Subtotals in a List         
  • Assignment
  • Working with Macros and User‑Defined Functions
  • Recording and Using Macros
  • Assigning Macros
  • Using User‑Defined Functions
  • Assignment

Using Basic Analysis Tools

  • Performing “What If” Analyses
  • Working with Scenarios
  • Assignment

Using Advanced Analysis Tools and External Data

  • Querying a Database
  • Importing and Exporting Files
  • Protecting Data
  • Using Data Validation
  • Using Worksheet Protection
  • Password Protecting a Workbook
  • Assignment

Using Business Analysis Tools

  • Working with Pivot Tables and Pivot Charts
  • Identifying the Parts of a Basic Pivot Table
  • Pivot Table Reports
  • Create a PivotTable from worksheet data
  • Create a PivotTable from an external data sourc
  • Create a PivotChart report from an existing PivotTable report
  • Delete a PivotTable or PivotChart report
  • Slicers
  • Using slicers
  • Formatting slicers for a consistent look
  • Sharing slicers between PivotTables
  • Sparklines
  • Types of Sparklines
  • Create a sparkline
  • Customize sparklines
  • Control which value points are shown
  • Change the style of or format sparklines
  • Online Analytical Processing (OLAP)
  • Business intelligence
  • What is Online Analytical Processing (OLAP)?
  • OLAP features in Excel 2016

Enquire About Excel 2016 Advanced Training Courses – Online or Face to Face Course
This course can be tailored to meet your exact requirements.
 

* fields are mandatory.

What our attendees have said about us:
Tony was very knowledgeable and was very clear and precise in what he was talking about. If you was unclear on certain things then he was willing to show you until you understood.
Aerzen Machines Ltd
Very good, clear and showed good examples.
Tate Britain
Very Very pleasant and with a calming approach to learning all techniques.
C.RO Ports
Brilliant tutor, wonderful sense of humour which made the training even more enjoyable, thank you I will defiantly recommend this course.
London Borough of Barnet
I picked up a number of tips and shortcuts which will be useful in my work. Lively and friendly and kept the day flowing.
Islington Council
Very good, all my objectives were met. Pace of the course was just right.
Girls Day Trust School
A nice approachable chap, knows a lot about Excel, willing to help.
Vision Office Automation
Very clear explanations of examples and broke down into simple formats.
Apex Fund Services
Very helpful and gave good insight into Excel which will be useful in future.
Apex Fund Services