On completion of this course you will be able to:
- Use Lookup and Reference Functions to Bring your Data Together
- Consolidate Data from Multiple Worksheets
- Create & Work with Pivot Tables and Pivot Charts
What are the Benefits?
- 3 Hours Hands on training
- Live Instructor Led Interactive Training - No Prerecordings.
- Comprehensive online courseware for delegates to keep
- Online certificate of completion for each delegate
- 1 Month post training support
Live Online Microsoft Excel Intermediate
Lists, lists, lists it seems as if the whole world is a bundle of lists. It doesn't matter what industry you are associated with you will need to analyse and present data. You don't have to have attended the beginners Excel course to attend this one. However, being a little familiar with Excel will of course be a great help.
Course Outline
Formulas
- Vlookup
- Index Match
- If Function
- COUNTIF
- SUMIF
Pivot Tables
- Creating a Pivot Table
- Using Slicers & Timelines
- Creating a Dashboard
- Formatting
- Create a Pivot Chart
Data Handling
- Creating a Table
- Filtering Data
- Conditional Formatting
- Removing Duplicate Data
This Live Online Instructor led Microsoft Excel Intermediate training course is available from wherever you are.
What do I need to participate?
Technical Requirements
To get the best out of your training sessions it is recommended that you have a:
- Internet connected Computer
- Webcam (usually already on most laptops)
- Microphone (usually on laptops)
- Nice comfy place to learn
- Big cup of tea
How Much is it?
£40 + VAT
How do I Book?
Simply Book online or send us an email and we will be happy to help.
If you have any questions at all, please don't hesitate to ask.
