Functions in Excel
Our functions in Excel training course is suitable for those with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas & functions within Excel. Our half day course is ideal for you. All our courses are interactive, challenging and backed up by latest theory and best practice. And they’re delivered by experienced professionals with at least 5 years’ experience in the subject.
Building complex formulas
Using nested IF statements
Creating compound logical tests using AND, OR, NOT functions with IF statements
Using COUNTIFS, SUMIFS, & AVERAGEIFS for tabulating data based on single/multiple criteria
Text functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, TRIM excess space in cells
Combining IF with VLOOKUP to suppress error messages
Using the IS information function
Error checking functions; ISERR, ISERROR, IFERROR
For more information please email training@microsoftexceltraining.ie