Excel Functions 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
 
 
 
 
 
 

Excel Functions & Formula Course London

Our Excel Functions Course or Excel Formula Course is designed for users who have been using Excel but wishes to get fully to grips with understanding Excel Functions or Excel Formula's, how to create more complex Excel Formulae or how to edit existing Excel Functions or Formula's on a spreadsheet. The course will solely focus on the Excel'scalculation capability. Enhance your spreadsheet with this fantastic Excel Functions & Formulae training course in London.

Excel Functions Course Information

Duration :
   Our Excel Functions course is a 1 day course. The course will start at 09:30 and run until 16:30 to 17:00
Venue :
   We can run your Excel Formulae 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 Excel Functions & Formulae training 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 Functions & Formulae training course. We charge per day, not per delegate which means last minute changes to your Excel Functions & Formulae course is not affected.

1 to 1 training = £450 per day*. The Excel Functions & Formulae course will be tailored to your exact needs and you will not be held up (or holding up) other users on your Excel Functions & Formulae 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 Functions Training Course Excel Functions and Excel Formulae Training Course Content

Basic Formula
  • How to create basic Excel Formula's
  • Absolute, Relative and Mixed Referencing
  • Formula Auditing
Range Names
  • How to create and edit Range Names for Formula compiling
  • Applying range names in Formulae
Basic Functions
  • Sum, Average, Max, Min, Counting functions
  • Sumif and Countif
Logical and Lookup Functions
  • IF, AND, OR
  • VLOOKUP, , HLOOKUP
Nesting Functions
  • Understanding Nesting
  • Nesting using the Functions Dialogue
  • Nesting using spreasheet formula building
Other Functions Categories
  • Text Functions - Left , Right, Mid, Concatenate, Find, Len etc
  • Financial Functions - PMT, FV, NPV, NPER, IRR, XIRR
  • Database Functions - DSum, DMax etc
  • Informational Functions - IsError, IsNumber etc3
Function Auditing
  • Tracing Dependent, Precendents
  • Tracing Arrows
Worksheet Protection
  • Protecting only cells that contain Functions or Formulas
Sample VBA Functions
  • Showing you some sample VBA functions to enable you to explore creating your own User Defined Functions. See more on this on our Excel VBA Training Course
 

Please note the above Excel Functions training course content can be customized to suit your exact needs depending on your existing knowledge of Excel Functions & Formulae. Feel free to contact us to help you build the perfect Excel Functions & Formulae Training Course. We believe that we are the best Excel Functions & Formulae Training Provider in London and can provide training on any function if requested

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

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

Excel Functions & Formula Training Course Offer
Book your Excel Functions & Formulae Training course before the 01/03/2011 and we will give you 2 free movie tickets or get a 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