Select Page

Excel Masterclass

An advanced workshop based course for a small group of 6.

This will include Excel sophisticated exercises of a lengthy nature to stretch your Excel imagination and skills!

Who is this course for?

This should only be attended by a trainee who has been on a Chamber Advanced Excel course and wants to improve further their skills in the work place.

  • Logistics planner
  • Office specialist
  • Accountant or finance specialist
  • IT person
  • Involved with regular Excel work

Course Overview

This highly interactive course will take the format of:

  • Looking at problems and solutions using nested statements
  • Developing Pivot Tables and Charts
  • Writing macros and editing them
  • Understanding scenario and Indexes
  • Writing MS Query Programs

Course Agenda

  • Open workbook and Consolidations, IS Error, Vlookup, IF
  • Pivot Tables, Charts, Sorting, Slicing
  • Macros and Editing Macros
  • Nested Statements using Vlookup
  • Nested Index function and Vlookup with Indirect Functions
  • Scenario manager
  • MS Query link to Access

Course Content

By the end of this course, delegates will be able to:

  • Write complex nested functions
  • Generate data tables using the Pivot function and chart
  • Compile a macro and perform some simple VB editing
  • Write a Query using MS Query
  • Perform a number of scenarios

 The Business Benefit

  • Be able to optimise time using Excel
  • Become an Excel specialist with confidence
  • Extract data from Access using MS Query
  • Solve business problems in an efficient manner

Your Course Tutor 

John Legge runs all the Chamber MS Office courses and has done so for over 15 years. He’s been in business for 20 years and has a unique informal and enthusiastic approach to teaching

 Why not try one of our other courses to compliment your development such as:

  • Finance Skills for Non-finance Managers
  • PowerPoint for Presentations
  • HR for the Non HR Manager
  • Internal Quality Auditor – ISO 9001:2008

£200.00 Members (excludes VAT) / £250.00 Non members (excludes VAT)

Showing the single result

Your Feedback
Your Feedback
Questions? We're here to help you!
Connecting...
Thanks for using our brand new website. We would love to hear your thoughts and suggestions.
Our operators are busy. Please try again later
:
:
:
Have you got a question? Write to us!
:
:
This chat session has ended
Was this conversation useful? Vote this chat session.
Good Bad