Link
  •  Home
  •  
  •  
  •  
    Your Basket is empty

  •  

We are in business for your business,
Supporting you at every turn

Excel Master Class

Home / Training / Business Training / IT and Microsoft / Excel Master Class - 04-09-2018

Excel Master Class

Severn House, Worcester WR4 9NE
£200 Members
+ VAT
 
Tuesday 04 September 2018
Event begins from 09:30 AM
Tuesday 04 September 2018 Event begins from 09:30 AM
£0
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
Trusted By companies in Herefordshire and Worcestershire including:
  • Tyrrell's Potato Crisps
  • Herefordshire and Worcestershire Fire & Rescue Service
  • Worcester Bosch
  • Kingspan Insulation
  • SMH Fleet Solutions
  • Oakland International
  • CMCA UK
  • Andrew Grant LLP
  • University of Worcester
  • Thomas Vale Construction
    and many more


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

Membership Saving £50

Login is required to receive the membership discount while booking online

Dates Available:

For more information please contact the Training Team

  training@hwchamber.co.uk      01905 673611