COURSE FINDER

Microsoft Excel Advanced

£290 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.
Telephone Hotline 01933 233884

Enter a location to find distance

Location Region Start Date Days Price ex. VAT    
London London, London All Areas, London West, South East Thu 21 Dec 17 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 21 Dec 17 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 21 Dec 17 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 28 Dec 17 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 28 Dec 17 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 28 Dec 17 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 4 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 4 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 4 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 11 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 11 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 11 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 18 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 18 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 18 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 25 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 25 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 25 Jan 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 1 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 1 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 1 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 8 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Milton Keynes East Anglia, Midlands, South Central England Thu 8 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Southend-on-Sea East Anglia, London All Areas, London East, London North, South East Thu 8 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
London London, London All Areas, London West, South East Thu 15 Feb 18 Single day duration, date as indicated. 1 £290 + VAT BOOK ENQUIRE
Courses found 1 to 25 of 48 1 2
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Gold Cross Training Services Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • MecSafe Logo
  • Health Life and Safety Logo
  • CSM Services Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Complete Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • Le Breton Training Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • ATC Risk Management Logo
  • CCAS Health and Safety Logo
  • MGM Training Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • SWL Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Genesys Training Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Safe Life Logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • Arthur Adams logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • Whites forklift training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Smallpeice Enterprises logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Highlander logo
  • Total Construction Training logo
  • e-testing logo
  • UTN Training logo
  • Ideal IT training logo
  • PQMS Training logo
  • Paradise Training logo
  • Collective Safety Solutions logo

Telephone Hotline

01933 233884

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

© 2017 Book My Course Limited. All rights reserved

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