Mastering Excel Functions
In previous Excel courses, you would have learnt to write formulas and functions to perform calculations using a variety of techniques. This course takes your use of functions to the next level and teaches you many more functions within Microsoft Excel.
The course examines the use of functions with real-world scenarios.
Course Prerequisites
This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of the following:
-
Create, edit, and format spreadsheets
-
Navigate within worksheets and books
-
Use Insert Function to create functions
-
Work with absolute references (e.g. $A$1)
-
Create formulas using functions such as IF or VLOOKUP
-
Create named ranges
-
Create Tables within Excel
-
Sort and filter data
Mastering Excel Functions Key Facts |
Course Duration (days) |
2.00
|
Course Price (ex VAT) |
£1135.00
|
Course Vendor |
Microsoft
|
Recent Comments