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