Microsoft Excel Advanced

Learn all about the advanced functionality Microsoft Excel has to offer...
Overview

Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information.

There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you!

This course can be run using Excel 2010, 2013 or 2016. Please discuss your version requirements with us when booking.

Course Code
MSE1ADV
Duration
1 Day
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info

Book your place

Purpose of this course

This course will continue your journey with Excel and give you the skills to use advanced functions and features.

Who is this course for

Anyone that manages, stores or looks at data as part of their role.

You will learn how to
  • Create pivot tables and graphs
  • Use Excel functions and formulae for mathematical processes and automation
  • Program Excel using Visual Basic

If you wish to keep a copy of the exercises that you produce on this course, please remember to bring a USB memory stick along with you.

Benefits for your organisation

This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts.

Benefits for you as an individual

An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.

Advanced Data Management

  • Automatic grouping, outlining and subtotalling
  • Scenario Manager
  • Data analysis tools
  • One and two data input tables
  • Goal Seek
  • Solver

Pivot Tables

  • Creation and formatting of Pivot Tables
  • External Data
  • Slicers
  • PowerPivot

Pivot Charts

  • Creation and formatting of Pivot Charts
  • Advanced Tasks
  • Scenarios

Advanced Excel Tasks

  • Advanced functions
  • Vlookup
  • Hlookup
  • Logical functions
  • Pivot consolidated data

Excel Programming

  • Macros
  • Keyboard Shortcuts
  • Visual Basic
Prerequisites

Delegates are expected to have attended Microsoft Excel Fundamentals or to have equivalent knowledge.

About the Lead Trainer

Hamish Pearson

Hamish has been training IT systems for many years and has seen MS Windows develop through all of its various versions. He can even remember some of the earlier ones! Whilst Hamish is not training for Quanta you will find him in a field somewhere, surrounded by members of the Scouts camping, climbing or playing with fire or during the run up to Christmas you will find him acting as Rudolph whilst pulling Santa on his Sleigh for the local Lions Club collecting for many local charities.