MS Office Training Course Provider
 
Go to Mouse Training Home Page All Software,  Computer and IT Training Courses in London and the UK Personal Development and Management Training Courses Bespoke System Training Experts in London MS Office - Excel, Access, Word and PowerPoint Consultancy in London All Mouse Training Services About Mouse Training - The Best London Training Course Provider Contact the Experts - Mouse Training!

London Training Courses

Microsoft Courses

IT Training Courses

Mac Office Courses

IT Training Courses

Adobe Courses

IT Training Courses

More Courses

IT Training Courses

Google Docs Courses

IT Training Courses

Get Expert Tailored Training Solutions

 
MS Office Training Provider

MS Excel Training LondonMicrosoft Excel 2000 Advanced Training Course in London and the UK

Our Excel Advanced course will build on your current Excel skills. The Excel Advanced course will concentrate on Lookup Functions, Analysing lists using Pivot Tables, Using What If Analysis and customising Excel. Users attending this class must be able to demonstrate an Intermnediate level of competence, or have attended our Intermediate course.


If this sounds like the training course you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.

 
 

MS Excel 2000 Advanced Training Course

 

MS Excel Advanced Training Course

Duration - This is a 1 day course starting at 09:30 until 16:30
Course Objectives - To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros.

Lookup Functions

  • Vertical Lookup (Vlookup)
  • Horizontal Lookup (Hlookup)
  • Match and Index
 

Informational Functions

  • IsText
  • IsValue
  • IsDate
  • IsNull
  • IsErr, Is Error, IsNa
 

Summarising Data with Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Chart
 
Advanced List Management
  • Advanced Filters
  • Using List Features
  • Dynamic Lists
 
MS Excel Advanced Training Courses
What If Analysis Tools
  • Scenarios
  • Custom Views
  • Reports
  • Goal Seek
  • Solver
  • Data Tables
 

Protecting and Sharing Excel Files

  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments
 

Customisation Options

  • Showing / Hiding Toolbars
  • Customizing Toolbars
  • Customizing Menus
  • Adaptive Menus
  • Default Options
  • Addins
 

Introduction to Macros

  • Purpose of Macros
  • Recording macros
  • Where to save macros
  • Absolute and relative record
  • Running macros:
  • Custom buttons, menu items, keyboard shortcuts
 

All Micorosoft Excel Training Courses and Levels

 
Excel 2007 Introduction
Excel 2007 Intermediate
Excel 2007 Advanced
Excel 2007 VBA
 
Excel 2003 Introduction
Excel 2003 Intermediate
Excel 2003 Advanced
Excel 2003 VBA
 
Excel 2002 Introduction
Excel 2002 Intermediate
Excel 2002 Advanced
Excel 2002 VBA
 
Excel 2000 Introduction
Excel 2000 Intermediate
Excel 2000 Advanced
Excel 2000 VBA
 
Excel 97 Introduction
Excel 97 Intermediate
Excel 97 Advanced
Excel 97 VBA
 
How to book your course

How to book

  • Contact us via email or call us on 020 7920 9500
  • We agree a date and course outline with you
  • Confirmation takes place by email or phone
  • That's it!

Contact Us for Training course advice and tailoring

Training Course Costs On-Site

Training Course Info

You can also download our MS Office Training Manuals for Microsoft Office 2000, 2002(XP) and 2003

Training Course Costs On-Site

Course Costs

1-to-1 training courses are charged at £450 per day. (Our offices or your venue)

All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.

We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.

For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Get an Instant Quote for your training course

On-site Training Course Quote

Build your course

With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page

Custom Course Builder

Tailored Access  Training Courses Access
Tailored Excel Training Courses Excel
Tailored PowerPoint  Custom Training Courses PowerPoint
Tailored Word Custom Training Courses Word
Tailored Project Custom Training Course Project
Outlook Custom Training Course Outlook
Visio Custom Training Course Visio
Publisher Custom Training Course Publisher
Home | Software Training | Soft skills Training | Bespoke Training | Consultancy | Services | About Us | Contact Us | Privacy Statement | Links | Sitemap © 2007 MTC All rights reserved