Discount For Members

Excel Masterclass

Start: 13th March 2024
From: 09:00 to 15:45

Non-member price

£250.00+VAT

Member price

£200.00+VAT

Herefordshire & Worcestershire Chamber of Commerce
Severn House
Prescott Drive
Warndon Business Park
Worcester
Worcestershire
WR4 9NE

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 workplace.

• 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
• Understanding conditional formatting with formulas

Course Agenda
• Open workbook and Consolidations, ISERROR, VLOOKUP, IFERROR
• Pivot Tables, Charts, Sorting, Slicing
• Macros and Editing Macros
• Nested Statements using VLOOKUP
• Nested INDEX MATCH function and VLOOKUP with Indirect Functions
• Scenario manager and Data Tables
• Conditional formatting

Places Available


Location: Herefordshire & Worcestershire Chamber of Commerce, Severn House, Prescott Drive, Warndon Business Park, Worcester, Worcestershire, WR4 9NE

Start: 13th March 2024
From: 9:00 am to 3:45 pm
×

Excel Masterclass #1

£250.00

To book multiple delegates, increase the quantity