We have developed our Excel Functions Formula's training course for users whome would like to get to grips with performing calcuations in Excel. The course will start from basic calculations and progress to creating complex nested functions and formulae in MS Excel. We cover all Excel Function categories and could teach any formulae not listed below with prior notice. The Functions Formulae Excel Course can also be tailored to your exact needs. Simply contact us to build your perfect Excel Functions 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.
Excel Functions Formulae Course Contents
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
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
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.
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
