We have developed our Excel Functions Formula's training course for users whom would like to get to grips with performing calculations 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
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 spreadsheet 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
More Excel Courses
