Full program description
Excel Useful Formulas and Functions
What's In It For Me
- AutoCalculate and Manual Calculation
- Using and Managing Defined Names
- Displaying and Tracing Formulas
Its 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.
Who Should Attend
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.
7 hours (1 Day)
Formulas with Multiple Operators
Inserting and Editing a Function
- Insert Function dialog box
- Function Library
- Edit a function
AutoCalculate and Manual Calculation
- Use Auto Calculate and change options
- Manual formula calculation options
- Define a name for a cell range
- Define names with a dialog box
Using and Managing Defined Names
- Use and view defined names
- Edit and delete defined names
Displaying and Tracing Formulas
- Display formulas
- Trace precedents and dependents
- Use the Watch Window
Understanding Formula Errors
Using Logical Functions (IF)
Using Database Functions (DSUM)
Using Lookup Functions
Using Text Functions
Date & Time Functions
Math & Trig Functions
Certification Obtained and Conferred by
Certificate of Attendance from NTUC LearningHub
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.
For more information on this course (including discounts and promotions), please enquire with us.