COURSE FINDER

Microsoft Excel Advanced - Online Classroom

£305 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 1 day

Trainer: WC315P

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Aims:

This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of Excel tools and concepts in order to further increase their knowledge and productivity.

Who Should Attend?

Users with a solid understanding of, and experience with, Microsoft Excel who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

Course Outline:

Advanced Conditional Formatting

- Editing Standard Formatting Rules
- Input Validate rules
- Using Formulas in Conditional Formatting

Using Form Controls and Templates

- Using Form Controls
- Creating Templates

Macros

- Advanced Calculations
- Goal seek, consolidate and scenarios

Advanced Lookup Functions

- Using Hlookup and VLookup Functions
- Using the Index Function
- Using the Match Function
- Using Index and Match Together
- Using the Indirect Function

Advanced Functions

- Using Error Functions
- Using Logical Functions
- Using Array Formulas
- Using Rounding Functions

Advanced Pivot Table Tools

- Importing Pivot Table Data
- Calculated Fields in Pivot Tables
- Showing Pivot Data as a Percentage
- Creating Custom Pivot Tables Styles

 
Additional Information: 
 
Please note that this training can focus on either Microsoft versions 2007, 2010 or 2013 - please state at the time of enquiry which version you would like this training to be held on. 
 
Delegates can also bring their own device to take the training on - please state that you wish to do this at the time of booking so that we can inform the training provider. 
 
Additional Information: 
 
Please note that this training can focus on either Microsoft versions 2007, 2010 or 2013 - please state at the time of enquiry which version you would like this training to be held on. 
 
Delegates can also bring their own device to take the training on - please state that you wish to do this at the time of booking so that we can inform the training provider. 
 
This course can be offered both as an open course and as a one-to-one private session with the trainer.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Safety & Health Logo
Hawks Logo
Know How Logo
SYNERGIETRAINING Logo
Induct Ltd Logo
BAM Construction Training Logo
Citrus Training Logo
3B Training Logo
Construction Industry Training Providers Logo
Health Life and Safety Logo
MI Construction Training Logo
Innov8 Training Logo
OM Safety Training Logo
Construction Skills People Logo
Phoenix Health and Safety Logo
Harris Safety Training Logo
First Response Training Logo
KeyOstas Logo
CCAS Health and Safety Logo
OMS Logo
Tala Training Logo
PRS Health and Safety Training
SSG Training and Consultancy Logo
RB Services Logo
Safety Training Services Logo
Lighthouse Training Logo
The Building Safety Group Logo
Kentec Training Logo
NTSS logo
Frinton Training logo
The Safety Maintenance Company logo
PC Workshops logo
Zero Harm Training logo
Risk Health and Safety logo
Sibbald Training logo
Total Construction Training logo
UTN Training logo
Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2024 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy