HOME
 

Excel Advanced

Activia Training
Course summary
1 day
154 - 199 GBP excl. VAT
English
Open / Scheduled
Next available date: 01/04/2020 09:15 - Manchester
Course Dates
Manchester
01/04/2020 09:15  (English)
199 GBP
24/04/2020 09:15  (English)
199 GBP
Leicester
08/04/2020 09:15  (English)
199 GBP
20/05/2020 09:15  (English)
186 GBP
London
08/04/2020 09:15  (English)
199 GBP
29/04/2020 09:15  (English)
199 GBP

Course description

Our Excel Advanced course will push your 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.

Training Course Content

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

Get Inspired! Watch the Video

About provider

Activia Training

Activia Training

When you organise your training, you need a partner who is able to deliver the skills improvements you need, and Activia have grown into a major UK provider on the strength of excellence in key areas. Whether it's competitive prices,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel Advanced.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Berkshire
Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number
www.activia.co.uk Course homepage


Request information

Find out more about this Excel Advanced course - simply fill out your details:

What do you want to know more about?
Do you offer this course online/virtually
I want to know more about this course
Do you offer discounts on more than one applicant?
I have another question
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here