Sitemap

Resources

Help / FAQ





Advanced Excel Course - Level 3 Excel Course

Our Advanced Excel course will benifit more experienced users, or users that have spesific questions or tasks to perform. The course will cover list functions, what-if tools and basic macro recording. This will enable you take 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 Functons
  • Create Pivot Tables
  • Use What-If Tools
  • Sharing and Tracking Workbooks
  • Record Basic Macros

Audience - This course is aimed for experienced users of Excel and you must be equivelant of our Intermediate level.
Course Duration - This is a 1 day Advanced Excel course
Course Dates - This course can run on any date you request
Course Versions - All versions from 97 to 2007

Advanced Excel CourseExcel Advanced Course Content

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

Advanced Lists

  • Advanced Filters
  • Subtotals
  • Grouping

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

What If Analysis

  • Goal Seek
  • Solver
  • Scenarios
  • Data Tables

Workbook Sharing and Reviewing

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

Introduction to Macros

  • Understanding the benifits of Macros
  • Recording / Running macros
  • Absolute and relative recording
  • Running macros: Custom buttons, menu items, keyboard shortcuts

 

More Excel Courses

Training Formats and Locations

  • Onsite Training - We come to you
  • Our London city based training center
  • One to One - Dedicated to your needs
  • Classroom - for groups up to 8
  • All our courses are instructor led, and closed to you.

read more

Course Cost

  • This course is charged at £595 per group of 8 per day
  • One to One is charged at £450 per day
  • All prices exxclude VAT
  • No travel cost except outside M25

Why choose us?

  • Experienced trainers
  • Best rates for groups and One to One courses
  • Most flexible cancellation terms
  • Easy payment terms
  • Simple pricing structure
  • After course support by your trainer
  • Free Training Needs Analysis

read more
Home  |  About Us  |  Contact Us
Microsoft Training Courses © 2009 All Rights reserved  | Privacy Policy