Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Excel Intermediate

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

This Microsoft Excel course is designed to offer training for those that have know the basics of Microsoft Excel (see beginners course),but want to fill in the gaps in their knowledge. The outline is only a suggestion and can be tailored to your business needs. To accompany the instructor lead training, each delegate will receive manuals and practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed. Alternatively a more complete self study package can be purchased from our e-learning catalogue.

Regions:
  • London
  • South East England
Delivery:
  • In House
Category:
Difficulty:
  • Intermediate

Further Details

Formulae Revision of formulae basics (see beginners course) Conditional Functions Nested IF IF OR IF AND SUMIF COUNTIF Lookup Functions VLOOKUP HLOOKUP MATCH INDEX Condtional formatting using formulae Workbook Consolidation Using 3D formulae Using data consolidation Forms/Templates Worksheet protection Workbook protection Data validation Form controls Creating a template Database Work Autofilters Advanced filter Pivot tables Subtotals SUBTOTAL function Database Functiions - DSUM, DAVERAGE etc Custom views

Guide price

£450 per group of 8 delegates

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net