Course description
Excel Level 2 (In-House)
This course is for anyone who wants to gain an advanced skill set necessary for calculating data using functions and formulas, sorting and filtering data, creating PivotTables to analyse data and customising workbooks.
Upcoming start dates
Suitability - Who should attend?
Pre-Requisites
Before starting this course, it is recommended that you take the Microsoft Office Excel Level 1 course
Outcome / Qualification etc.
- You will use advanced formulas and work with various tools to analyse data in spreadsheets.
- You will also organise table data and present data as charts to enhance the look and appeal of workbooks.
Training Course Content
Introduction & Workshop Objectives
Lesson 1: Calculating Data with Advanced Formulas
- Apply Cell and Range Names
- Calculate Data across Worksheets
- Use Specialised Functions
- Concatenate, Proper, Left and Right
- Analyse Data with Logical and Lookup Functions
- If, SumIf, CountIf and Vlookup
Lesson 2: Organising Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort and or Filter Data
- Use Functions to Calculate Data
Lesson 3: Presenting Data using Charts
- Create a Chart
- Modify a Chart
- Format a Chart
Lesson 4: Analysing Data using PivotTables,
Slicers and PivotCharts
- Create a PivotTable Report
- Filter Data using Slicers
- Analyse Data using PivotCharts
Lesson 5: Customising and Enhancing the Excel Environment
- Customise the Excel Environment
- Customise Workbooks
- Manage Themes
- Create and Use a Template
Why choose GBC Learning & Development
Established in 1994 and still learning!
Trusted by 400 world-wide
Save! Bring a Buddy Half Price
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews
Average rating 5
Very enjoyable and informative gained understanding of myself and others.
Was very good, learnt a lot of usefull information.
Expenses
Course Price: £360 + VAT
Request info
GBC Learning & Development – Invest for High Performing People
Practical yet inspiring topics, comprehensive content, and passionate trainers. Tap into the expertise of our trainers who have a wealth of experience in business, coupled with an understanding of how people learn and put their learning into practice in the...
A fantastic trainer, very well prepared, fantastic interpersonal skills, very direct and confident – exactly the type of trainer you need for this type of course – leading us by...