Training

Advanced Excel

Digital & IT, Digital & Technology

03/09/2024 9:30 am

03/09/2024 4:30 pm

East Midlands Chamber, Chesterfield, S41 8ND

Chamber Members: £245

Non-members: £315

*All our business prices are excluding VAT at 20%

Book a place

In-Person

For further information on this event, please contact: Business Training Team on 03333200333 or email business.training@emc-dnl.co.uk

Description

This one-day course deals with automation and productivity features. It includes such areas as conditional formatting, validation and consolidation methods, data analysis tools such as pivot tables and data summarising.

Overview

Course Programme in Detail

• Custom Views
• Working with Comments
• Conditional Formatting
• Advanced Filtering
• Statistical Functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, MODE, MEDIAN, LARGE and SMALL)
• Validating Data
• Pivot Tables
• Creating and using Macros

What outcomes can you expect from joining us

On completion of this course you should be able to analyse and present your data visually, use advanced filtering techniques, validate and consolidate data; analyse your data using data summarising and pivot tables, use ‘what-if’ tools and automate repetitive tasks.

This course is for those who are familiar with, and have a good understanding of Excel. Those who use it regularly and write their own basic formulas. This is a “packed” course and due to the level of content, not all topics may be covered (to be agreed during training).

Martin Perry

The tutor for the course is Martin Perry who has many years experience as an IT Trainer. Martin's courses are geared to ensuring all delegates walk away with new skills regardless of their ability when they arrived. All courses are delivered in such a way that delegates continually use Excel throughout the day ensuring maximum hands on experience.

Additional Information

Lunch and refreshments are provided as part of this course. Please note, there is no requirement for delegates to bring any stationery or IT equipment unless otherwise stated in the joining instructions.

book your place

Are you interested in attending this event? Book today to secure your place.
Booking Form

Looking to book for our event?

Please complete with delegate details, we can only accept one delegate booking per form. If you wish to book multiple delegates, please email business.training@emc-dnl.co.uk or complete a form for each delegate.