reed.co.uk Courses

Header

Microsoft Excel Advanced Inhouse Training

Advanced Microsoft Excel course with CPD accredited certificate & free e-learning: become a fully competent Excel user


Activia Training

Summary

Price
£538.80 inc VAT
Payment options
The first delegate is £538.80 (inc VAT), additional delegates are then £48.00 (inc VAT)... Read more
Study method
On-site
Duration
1 Day, Part-time
Qualification
6 CPD points / hours

4 students enquired about this course

Add to basket or enquire

Enquire now

Overview

We offer In Company training at your offices. All you need is a suitable room, and we can bring your training to you.

Our Microsoft Excel Advanced course will push your Microsoft Excel skills to a new level.

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.

Course media

Description

This course contains the following modules:

Grouping & Outlining and Subtotals
- Outlining and Grouping Data
- Using the Subtotals Tool

What-If Analysis
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver

PivotTables
- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Slicers

Charting Pivoted Data
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart

Advanced Excel Tasks
- Excel and Hyperlinks
- Using Custom AutoFill Lists
- Sharing Workbooks

Creating HLOOKUP and VLOOKUP Functions
- Using the VLOOKUP Function
- Using the LOOKUP Function

Introduction to Macros in Excel
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros

'

Who is this course for?

Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Questions and answers

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals