Skip Main Navigation
Page Content

Save This Event

Event Saved

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

Touchstone Training and Consulting

Sunday, 18 December 2016 from 12:00 to 18:00 (GMT)

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

Ticket Information

Ticket Type Sales End Price Fee Quantity
MS Excel (Intermediate) - One to One 18 Dec 2016 £180.00 £6.18

Who's Going

Loading your connections...

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

Event Details

Microsoft Excel Intermediate Course Outline

 Our Excel Intermediate course will build on your basic Excel skills and show you more complex formalae, how to build formalae across worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.

 After the course, you will be able to:

  • Use Logical Functions, Financial and Statistical Functions
  • Nest Functions
  • Multiple Worksheet Management and Formulae
  • Build Charts
  • Protect Worksheets & Workbooks

 Course Prerequisite - To get the most from this course, you must be at a basic Excel level, equivalent of our introduction course content

Course Outline:

Lesson 1: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

 Lesson 2: Analyzing Data with Logical and Lookup Functions

  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data

 Lesson 4: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

 Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts

 Lesson 6: Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

 Lesson 7: Enhancing Workbooks

  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files
Do you have questions about Microsoft Excel 2007, 2010 & 2013 - Intermediate (One to One) Course? Contact Touchstone Training and Consulting

Save This Event

Event Saved

When & Where

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

Sunday, 18 December 2016 from 12:00 to 18:00 (GMT)

  Add to my calendar


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 - Intermediate (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.