Home / Events / Advanced Excel

Share event:

Description

This one-day course deals with Data Analysis, productivity features and data cleansing features. It includes tools such as Pivot Tables, Data Validation, Dynamic Array Formulas and Power Query

Overview

Course Programme in Detail
• Creating Custom Views
• Using the Excel Camera
• Using Power Query
• Using Dynamic Array functions including FILTER, SORT, UNIQUE, XLOOKUP TEXTSPLIT and HSTACK and more
• Validating Data
• Advanced Pivot Table techniques
• Automating Excel tasks

Tips, tricks and shortcuts throughout

Outcome

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

Additional Information

Lunch and refreshments are provided as part of this course.

Please note, you are required to bring a laptop to this training, if this is a problem, please advise us prior to the training.

This event is available for: Members and Non Members

9:30am - 4:30pm

In-Person

East Midlands Chamber, Chesterfield, S41 8ND

Select your tickets

Members must Sign in / Register to purchase member only tickets

Price Type

Clear

*All our business prices are excluding VAT at 20%.

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

Presenters & Panelists

Martin Perry

Learn more

Events

Our Services

Members

About

Advanced Excel