" rel="stylesheet">
Skip Main Navigation
Page Content

Save This Event

Event Saved

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

Touchstone Training and Consulting

Sunday, 23 October 2016 from 12:00 to 18:00 (BST)

Microsoft Excel 2007, 2010 & 2013 - Advanced (One to...
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
MS Excel (Advanced) - One to One 23 Oct 2016 £180.00 £6.18

Who's Going

Loading your connections...

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

Save This Event

Event Saved

When & Where


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

Sunday, 23 October 2016 from 12:00 to 18:00 (BST)


  Add to my calendar

Organiser

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!

www.touchstonetc.com

info@touchstonetc.com

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.