Course Code: ODEEUFF
It’s a common need for working professionals to apply anything from simple calculations to complex formulas in their Excel spreadsheets to gather the results they need at their workplace daily.
In this one day lesson, students will also learn how to create numerical calculation and logical formulas they need to use and common useful functions such as define names to make more sense in formulas and VLOOKUP to find corresponding values faster. The course is for users at all levels, from beginners to intermediate.
This course is intended for information workers such as decision makers, accountants, analysts and even sales managers who have frequent needs to analyze large amount of business performance information such as sales figures and volume of production.
Students must be to use the keyboard/ mouse and be familiar with the Microsoft Windows Operating System. It is preferable that students also know the basics of Microsoft Excel.
7 hours (1 Day)
Formulas with Multiple Operators
Inserting and Editing a Function
AutoCalculate and Manual Calculation
Using and Managing Defined Names
Displaying and Tracing Formulas
Understanding Formula Errors
Using Logical Functions (IF)
Using Database Functions (DSUM)
Using Lookup Functions
Using Text Functions
Date & Time Functions
Math & Trig Functions
Certificate of Attendance by Next U (Executive Arm of NTUC LearningHub)