Master Class Excel Tips & Tricks Advanced – 17th & 18th May 2021

Date Location Price / Members Price Places Trainer Book Online or Enquire
17th May 2021 @ 9.30-12.30 Online € 65.00 / € 65.00 2 available Systems & Software Training

This course is not suitable for beginners

ADVANCED – Online Workshop – Duration 2 x Half day workshops 17th & 29th May 9.30-12.30 (both days)

 

Objective

Many experienced excel users are self-taught. They know how to use most of the main Excel tools, but they don’t know how to use many of them to the best effect, or just aren’t using the power of excel to help them do their work. Taught by someone who has been working with and teaching Excel for 30 years, you will be amazed by how much you will learn.

 

Topics Include 

 

Overview – Tips & Tricks

Customise Excel – Quick Access Tool Bar

Audit Options- Advanced Options

Mixed Absolute Reference

Named Areas

Default Settings

The Outline Feature

Advanced Filter

Macros

Validation Lists

Macro Buttons

Nested If Statements

V Lookups – Nested V Lookups

 

 

 

Pivot Tables

Pivot Charts

Consolidation

Scenarios

Goal seek

Using more Advanced Formulas

( Indirect, Match Etc)

Templates

The Developer Tab

·       Index

·       Nested If Statements

·       PMT Function

 

Q&A and Review