Select Page

Excel Master Class

Non-member price

£250.00 +VAT

Please login to purchase

Places Available


Location: Severn House, Prescott Drive, Warndon Business Park, Worcester, Worcestershire, WR4 9NE

Start: 22nd Oct 2019 9:30am to 4:00pm

SKU: d4554b59448c Categories: , ,

Description

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

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