Participants will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.
At the end of this course, the participants are expected to be able to:
Understand the use of Excel’s advanced Functions
Gain Insights from vast array of data with ease
Make powerful dashboards
Analyse data like a professional
Understand shortcut techniques for faster and efficient use of Excel