They are what make a spreadsheet a spreadsheet. This one-of-a-kind course delivers all the tips and techniques one needs to maximize one of the most powerful spreadsheet tools: formulas. The more you know about formulas, the better your spreadsheets will be. Hence the course is to aim to get the most out of worksheet formulas.
What Will I Learn From This Course?
This course is Instructor led group-paced, hands-on classroom-training with activities. Manuals are provided for each student for after-class reference.
Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training and to expand their analytics skill set, work more efficiently with data, and take their career to a new level.
Course Outline for This Programme
b. NESTED IF
Text Category Functions
Date and Time Functions
Lookup and Reference Category Functions
c. INDEX & MATCH
Math and Trig Category Functions
Statistical Category Functions