Next In take: 21, 22 January 2014

Microsoft Excel Function and Formulas

Course overview:
Users of Microsoft Excel are familiar with its common functions and formulas but many have yet to discover the far potential and application of these tools.
In learning and maximizing its specific and relevant functions, the common and tedious tasks can be simplified and made easy.
Participants will discover how to avoid common pitfalls in using them, from learning the basic facts in using formulas to mastering the usage of more complex functions.


Learning objectives
At the end of the programme, participants will be able to:
• Understand the four common cell references
• ‘Test a condition’ using logical functions
• Learn concept of array and array formula.
• Working with text strings in formulas.
• Learn to work with date and time values in formulas.
• Learn to round number and getting randomize numbers.
• Advanced technique to sum or count similar items in a worksheet.

Who Should Attend:
Anyone who wants to take their Excel skills to the next level can benefit from this class, but it will be especially useful for:
• Data analyst
• Finance managers
• Product analysts
• Sales managers
• Small business owners
• Analyst
• Professionals seeking deeper insights into their data.


For a completed course outline, please email me at sales(at)ugrowit.net.

Bonus: Those who attend this class will receive a "Customer Relationship Building Tool" written in Excel macro.
You can use it to send Chinese New Year card, birthday card, many other usage.
You can send multiple cards to multiple clients all in just one click.

So, PM me today for the fee and also your email address. Thank you.

For my profile, please visit:
https://forum.lowyat.net/topic/1555561/all

This post has been edited by kent_lau7: Jan 16 2014, 10:33 AM