Fee: RM1007 per pax
Fee is inclusive of SST
Users of Microsoft Excel are familiar with its common functions and formulas but many have yet to discover the potential and its application of these tools. In learning and maximizing its specific & relevant functions, common and tedious tasks can be simplified and made easy. Some formulas are relatively straight-forward and some can be made more powerful when they are combined. Participants will discover how to avoid common pitfalls in using them, from learning the basic facts in using formulas to leveraging the usage of more complex functions.
OBJECTIVE:
• Master the dynamics about Formulas,
• Working with Names,
• Applying the Logical & Information Functions,
• Using Arrays to Solve Multiple Functions, Text Functions,
• Leveraging Lookup Functions,
• Applying Count and Sum Functions,
• Optimizing Mathematical and Trigonometry Functions
• Working with Dates and Time Functions