0845 450 6120

Microsoft Excel Advanced 2007-2016

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) class. 

DURATION

This is a one-day training course structured into 7 modules

COURSE AIMS

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.

TARGET AUDIENCE

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.

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

Reset

Course Content

MODULE 1Grouping & Outlining and Subtotals
Learning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.
Topics covered:
  • Outlining and Grouping Data
  • Using the Subtotals Tool
MODULE 2What-If Analysis
Learning outcomes: Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.
Topics covered:
  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver
MODULE 3PivotTables
Learning outcomes: Creating Pivot Tables in order to display and summarise large quantities of data effectively.
Topics covered:
  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers
MODULE 4Charting Pivoted Data
Learning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
Topics covered:
  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart
MODULE 5Advanced Excel Tasks
Learning outcomes: Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.
Topics covered:
  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks
MODULE 6Creating HLOOKUP and VLOOKUP Functions
Learning outcomes: Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.
Topics covered:
  • Using the VLOOKUP Function
  • Using the LOOKUP Function
MODULE 7Introduction to Macros in Excel
Learning outcomes: Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
Topics covered:
  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Our Customers Include