This is a selection of our course dates and locations, please call or email for other course details. Callback Request

Loading Public Courses

« All Public Courses

  • This public course has passed.

Advanced Excel Training Course

Tuesday, November 21st, 2017 @ 9:30 am - 4:30 pm

£250

 Advanced Course in Microsoft ExcelExcel Training Courses

CPD accredited coursenote: this Excel Advanced course is CPD certified.

This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as a diploma of completion.

  • 1-day Instructor-led, Courses never cancelled, 

    VERSIONS COVERED

    This course covers 2007, 2010, 2013 and 2016 versions

 Benefits

  • At the end of this course, you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

Who is this course for?

Our Microsoft Excel 2010 Advanced course is suitable for those with a sound working knowledge of Excel who wishes to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

Benefits

  • At the end of this course, you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.
MODULE 1:  Grouping & 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 2:  What-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 3:  PivotTables
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 4:  Charting 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 5 Advanced 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 6 Creating 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 7 Introduction 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

Tickets

Unlimited available
Advanced Excel Training Course£250.00

Please fill in all required fields

Details

Date:
Tuesday, November 21st, 2017
Time:
9:30 am - 4:30 pm
Cost:
£250
Public Course Categories:
, , , ,
Public Course Tags:
,

Venue

Birmingham City Centre
1 Victoria Square Regus Office, s B1 1BD + Google Map
Phone:
0843 289 1713

Organiser

Taylor Mason
Phone:
0843 289 1713
Email:
info@taylor-mason.co.uk
Website:
www.taylor-mason.co.uk
X

Send this to a friend