Excel intermediate Training Course

Excel Training Courses London
Expert Excel Training Course Provider

 
 
line decor
Our Expertise: Excel Training Course in London | Advanced Excel Training Courses | VBA Excel Training Course | London's Best Excel Training Courses
line decor
 
 
 
 

 
 

MS Excel Intermediate Course London

If you are new to MS Excel, or are an existing Excel user that need to bridge gaps in your basic excel skills, this course is perfect. Our Excel Intermediate training course in London is designed to provide you with all the skills required to build spreadsheets from scratch, create formulas and prepare the sheets for printing using page setup and formatting techniques. Our experienced and qualified Excel trainers will provide expert Excel intermediate training. Although we have a guideline Excel intermediate Course Outline, you can customize the Excel intermediate content to suit your needs. Contact us if you would like more information on our Excel intermediate Training Course (London).

Excel Intermediate Training Course Information

Duration :
  This is a 1 day Excel Intermediate training course. The course will start at 09:30 and run until 16:30 to 17:00
Venue :
  We can run your Excel Intermediate training course in London either at our Excel Training center in the City or on-site at you office. We can even provide the training equipment if you do not have a dedicated IT training room
Dates:
  We run the course when you need it, not to a predefined schedule. That means your team can decide a date that is suitable for all.
Cost :
 

We have a unique pricing structure for our Excel Intermediate training course. We charge per day, not per delegate which means last minute changes to your Excel intermediate course is not affected.

1 to 1 training = £450 per day*. The Excel Intermediate course will be tailored to your exact needs and you will not be held up (or holding up) other users on your Excel Course.

2-8 delegates = £695 per day*. If you have 8 delegates on the course, this equates to less than £100 per person. You will not find a more cost effective rate anywhere else. As mentioned on our home page, clients like Google, HSBC and many more make use of us, as we are the best Excel training course provider with a cost that won't rob your training budget

Excel Intermediate Training Course Content (High Level)

Using Range Names
Learn how to use Range Names for Navigation and to simply formulae and calculations accross worksheets. Simple but extremely useful tool!
Functions
  • Logical Functions - If, And, Or, Not
  • Date and Time Functions - Today, Weekday, Networking days and many more
  • Nesting Functions - How to use 1 function as an argument of another
  • Financial Functions - PV, PMT and NPER (More if Required like IRR, XIRR etc)
Advanced Formatting
  • Custom Number formatting
  • Conditional Formatting
  • Formatting accross sheets
Data Consolidation and Validation
  • Linking data between sheets and workbooks
  • Managing Links
  • Data Consolidation
  • Group and Outlining
  • Data Validation
List Management
  • Using Excel Lists
  • Dynamic Range Names
  • Sorting
  • Autofilter
  • Advanced Filter
  • SubTotals
Excel Charting
  • Everything you need to know on creating charts or graphs
  • Exporting and Linking Graphs + Charts

Please note the above Excel Intermediate course content can be customized to suit your exact needs. Feel free to contact us to help you build the perfect Excel Intermediate Training Course. We believe that we are the best Excel Training Provider in London.

 

 

* All prices are excluding VAT and subject to a 5 day cancellation period. Also have a look at our Excel Training Courses from MTC

 
 

 

Contact Us
Tel: 020 7920 9500 info@exceltraininglondon.co.uk


Excel intermediate Training Course Offer
Book your Excel intermediate Training course before the 01/03/2011 and we will give you an Excel Bible free!


Free Excel 2010
Advnaced Manual!

You can now download our Excel 2010 Advanced training manual for free!
Excel 2010 Advanced Manual

If you wish to purchase the entire suit of Office 2010 manuals, please contact us

 
 
 
 
Excel Training London is part of the MTC Group of Training Providers  

Mini Site Map