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 2007 Intermediate Training Course in London and the UK

Our Excel 2007 Intermediate course will build on your current Excel skills. The course will focus more on Excel Functions, Worksheet Management, Working with Lists and Charting your data. Our Excel Intermediate course requires you to have a good understanding of the basic topics, as covered in our Introduction course. Existing users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.


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 2007 Intermediate Training Course

 

MS Excel Intermediate Training Course

Duration - This is a 1 day course starting at 09:30 until 16:30
Course Objectives - This course is designed to build on the introduction course. It focuses on functions and formulae and better Excel Worksheet management. Also included is charting your data in Excel.

Naming Cell Ranges

  • Concept and Purpose
  • Naming individual cells
  • Naming ranges of cells
  • Deleting and amending named ranges
  • Using named cells/ranges in formulae
 
Conditional Functions
  • Benefits and purpose
  • If Statements
  • Nested If
  • And, Or, Not
    Combining If, And, Or, Not
    Sumif
  • Countif
  • Conditional Formatting
 

Working with Dates and Times

  • Entering Dates and Times
  • Different date/time formats
  • How dates are stored
  • Calculating working days
  • Using the DAY(),MONTH(),YEAR() functions
  • Time calculations
 

Checking for Errors

  • Formula Auditing Tools
  • Revealing Formulae
  • Tracing Precedents/Dependents
  • Goto Special
 
Excel Intermediate Training Courses in  London

Worksheet Management and Linking

  • Linking sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • Viewing different files at once
  • Saving a workspace
  • Viewing different sheets at once
  • Window Split
  • Data consolidation
 
Essential List Management
  • Sorting Data
  • Adding Subtotals
  • Autofilter
  • Freeze Panes
  • Group and Outline
  • Data Form
 

Charting your data

  • Using the Chart Wizard
  • Editing and Formatting charts
  • Saving custom chart types
  • Setting a default chart type
 

Worksheet Protection

  • Applying Data validation rules
  • Inserting comments
  • Protecting cells, sheets, files
  • Password protecting a file
 
 

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