Ms Excel Advanced Courses

Advanced Microsoft Excel Training Course Information

MS Excel – Advanced Training Course

1 Day Course | 1 delegate £245.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information

Introduction

This one-day instructor led course is designed to give delegates the ability to analyse data in a variety of ways. By the end of the course delegates will be able to use the built in Excel tools to compare data and create projections and also to understand and use the macro facility of Excel.

Course Objectives

  • Analyse data using pivot tables
  • Develop solutions to financial and budgeting questions
  • Control the output of printed work with report manager
  • Verify calculations and trace errors using auditing facility
  • Automate routine tasks with macros

Pre-requisites

This course is designed for experienced Excel users who have completed the Excel Intermediate course or have equivalent knowledge. Delegates should already be able to create detailed worksheets using complex formulas and should be familiar with conditional and nested functions.

Course Content

Pivot Tables

  • Creating a pivot table
  • Rearranging pivot tables
  • Formatting pivot tables
  • Creating charts

Analytical Tools

  • Using Goal seek and Solver
  • Creating Scenarios

Report Manager

  • Using Report Manager
  • Managing views and reports

Macros

  • Recording a simple macro
  • Editing a macro
  • Assigning a macro to keyboard or toolbar button

Auditing Facility

  • Tracing Precedents/Dependents
  • Checking for errors
  • Applying data validation to cells with input text and error messages