Skip Main Navigation
Page Content

Save This Event

Event Saved

Looks like this event has already ended.

Check out upcoming events by this organiser, or organise your very own event.

View upcoming events Create an event

Microsoft Excel 2007, 2010 & 2013 - Advanced (One to One) Course

Touchstone Training and Consulting

Microsoft Excel 2007, 2010 & 2013 - Advanced (One to...
Available Dates
No tickets available for upcoming dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
MS Excel (Advanced) - One to One 1 hour before event starts £180.00 £6.18

Share Microsoft Excel 2007, 2010 & 2013 - Advanced (One to One) Course

Event Details


Microsoft Excel Advanced Course Overview


Our Advanced Excel course will benefit more experienced users, or users that have specific questions or tasks to perform. The course will cover list functions, what-if tools and basic macro recording. This will enable you take your spreadsheets to the next level! The course also covers PivotTables to analyse your data.

 After the course, you will be able to:

  • Use Lookup Functions
  • Create Pivot Tables
  • Use What-If Tools
  • Sharing and Tracking Workbooks
  • Record Basic Macros

 Course Prerequisite - This course is aimed for experienced users of Excel and you must be equivalent of our Intermediate level.

Course Outline

Lesson 1: Functions

  • Lookup Functions - H + VLookup, Index, Match
  • Text Functions - Left, Right, Mid, Concatenate, Search + more
  • Information Functions - IsError, InNull, IsBlank, IsDate, IsText + more
  • Database Functions - DSum, DAverage, DCount + more

 Lesson 2: Advanced Lists

  • Advanced Filters
  • Subtotals
  • Grouping

 Lesson 3: Pivot Tables

  • Create and Edit Pivot Tables
  • Understanding Different Layouts
  • Applying different calculations, e.g. Sum, Count, Average etc.
  • Grouping
  • Calculated Fields + Items
  • Formatting PivotTables
  • PivotCharts

 Lesson 4: What If Analysis

  • Goal Seek
  • Solver
  • Scenarios
  • Data Tables

 Lesson 5: Workbook Sharing and Reviewing

  • Sharing Workbooks
  • Tracking Changes, Accept and Reject Changes
  • Workbook Protection Review

 Lesson 6: Introduction to Macros

  • Understanding the benefits of Macros
  • Recording / Running macros
  • Absolute and relative recording
  • Running macros: Custom buttons, menu items, keyboard shortcuts
Do you have questions about Microsoft Excel 2007, 2010 & 2013 - Advanced (One to One) Course? Contact Touchstone Training and Consulting

When & Where

E14 5RB
The Idea Store (Canary Wharf Library)
E14 5RB London
United Kingdom


Touchstone Training and Consulting

Touchstone Training and Consulting offers an extensive range of affordable application courses (including Microsoft Office 2003, 2007 and 2010) from Beginner to Advanced level.

All our courses can be customised to suit your specific needs and we also offer courses in small groups of up to 10 people or on a one to one basis.

Our course portfolio will help you build the skills, knowledge and techniques you need to advance your career or business.

Why Touchstone Training and Consulting?

• High Impact, Quality Training Delivered By Experts 
• Perfectly Crafted Training Tailored to Suit You. All our course contents can be customised and delivered at a location of your choice! 
• Small Class Sizes Up to 10 people so we deliver personalized and interactive courses 
• Price Match Guarantee - If you find an identical training course at a cheaper price, let us know and we will match the price and offer you 10% off your next course with us!

Like us on Facebook 

Follow us on Twitter 

  Contact the Organiser
Microsoft Excel 2007, 2010 & 2013 - Advanced (One to One) Course
Things to do in London Course Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.