You are here: Home » Microsoft » Excel » Microsoft Excel 2010 » Microsoft Excel v2010 Advanced
Monday, 16 Jul 2018

Microsoft Excel v2010 Advanced

Course Objectives

This one day course covers Excel's advanced features. The course will look at the more advanced functions and analysis techniques, and particular emphasis will be given during the course to Excel's macro commands.

Who Should Attend?

Those who have used Excel 2010 yet require a more in-depth knowledge of more advanced features and macros.

Previous experience of using Excel 2010 to an intermediate level will be assumed. Delegates who do not have this level of knowledge of Excel should first attend our "Microsoft Office Excel 2010 Intermediate" course.

Course Contents

Excel Database Features.

  • Advanced Filter
  • Database Functions
  • Pivot Tables

Data Tables.

Sharing Workbooks.

Using Outlines.

Using Consolidation Commands.

Advanced Analysis Techniques.

  • Scenario Manager
  • Goal Seek
  • Solver

Advanced Reporting Techniques.

  • Custom Views
  • Report Manager


  • Recording a macro
  • The Macro Language
  • Running a Macro
  • Relative Addresses
  • Using Input Boxes
  • Using Message Boxes

Microsoft Excel 2010 Course DetailsDownload Course Details

Event Properties

Event date: 10-01-2018 09:30 AM
Event end date: 10-01-2018 05:00 PM
Individual Price £150.00
Location AJP IT Services
Please phone us on 0117 929 1509 to book this course