Course Info
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?
Learn how to think like Excel, and write powerful and dynamic formulas from scratch
Automate, streamline, and completely revolutionize your workflow with Excel
Master unique tips, tools and case studies that you won't find in any other course, guaranteed
Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
Build formulas to analyse dates, text fields, values and arrays
Methodology
This course is Instructor led group-paced, hands-on classroom-training with activities. Manuals are provided for each student for after-class reference.
Pre-requisites
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
Financial Function
a. SLN
b. SYD
c. FV
d. PMT
Logical Functions
a. IF
b. NESTED IF
c. AND
d. OR
Text Category Functions
a. CONCATENATE
b. LEFT
c. MID
d. RIGHT
e. LOWER
f. PROPER
g. UPPER
Date and Time Functions
a. TODAY
b. NOW
c. DATEDIF
d. DAYS360
e. YEAR
f. YEARFRAC
g. WEEKDAY
h. WEEKNUMB
Lookup and Reference Category Functions
a. VLOOKUP
b. HLOOKUP
c. INDEX & MATCH
Math and Trig Category Functions
a. POWER
b. PRODUCT
c. CEILING
d. FLOOR
e. ROUND
f. ROUNDDOWN
g. ROUNDUP
h. SUBTOTAL
i. SUMIF
Statistical Category Functions
a. COUNT
b. COUNTA
c. COUNTIF
d. COUNTBLANK
