february, 2018

This is a repeating event

thu01feb9:30 am4:30 pmTraining course date passedAdvanced Excel TrainingAdvanced Microsoft Excel Learning83 Victoria Street London SW1H 0HW

Book Online Now!

Event Details

 7 essential excel tipsCOURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

 

 

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.

 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
CPD CERTIFIED COURSE
CPD accredited course

Note: 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 an Activia diploma of completion.

Time

(Thursday) 9:30 am - 4:30 pm

Location

London Victoria

83 Victoria Street London SW1H 0HW

Other training course dates-click to view

1st february 2018 9:30 am1st february 2018 9:30 am1st february 2018 9:30 am1st february 2018 9:30 am28th march 2018 9:30 am8th may 2018 9:30 am8th june 2018 9:30 am1st november 2018 9:30 am23rd november 2018 9:30 am12th december 2018 9:30 am

Organizer

Taylor Mason0843 289 1713 PO Box 3125 450 Brook Drive Reading RG1 9RX

Add your training course to cart

Advanced Excel Training

Book Online Now!

Tickets are not available for sale any more for this event!

X

Send this to a friend