Hidden Secrets of Data Analysis in Power Excel
This course is specially designed to help executives and managers who are currently preparing their reports using manual calculations, auto-filter, and wish to learn how to prepare and analyze their reports faster using Pivot Table, one of the best tools hidden in Excel.
At the end of the course, they will be able to skillfully create and design their reports using worksheet functions, Pivot Tables, Pivot Charts, and Dashboards.
The skills learned mark the start of their journey in Data Analytics, a skill much sought after by many companies around the world. Learn More
Grow Your Profit Through Data Analytics and Data Modelling
This course is specially designed to help executives and managers who already know Pivot Table and feel that they are not proficient with it yet. In this course, we will reveal the secret of creating highly efficient Pivot Tables that are instantly updated month after month.
At the end of the course, they will be able to use Pivot Table to compare 2 sets of values, calculate growth/variance within Pivot Table and learn how to make use of the Power functions in Excel, namely Power Query, Power Pivot.
The skills learned are Data Analytics driven and equip you with the relevant skills for new data-driven economy. Learn More
Productivity Boost: 100+ Tips and Tricks
This course is for existing Excel users who are seeking shortcuts and tricks to speed up what they have already done. The tips and tricks are easy to pick up and make working with Excel simple.
At the end of the course, they will be able to immediately apply these tricks back at work. There is no macros/VBA/programming involved in these tips and tricks. Learn More
Unleash the Power of PowerPivot
This program is a deep dive into advanced Pivot Table by Microsoft. In this course, you will learn all the essential DAX functions to help you create the most robust and instantly updated dashboard.
With PowerPivot, creating calculations within Pivot Table is no longer a wishlist. You can now compare 2 different sets of numbers, show the differences, find percentages based on the full total, calculate YTD, with a click of the button. Learn More
Learning the Magic of Macros (VBA)
Learning the Magic of Macros is a coaching program designed to help business professionals automate their data collection and distribution activities. The main objective is to create highly accurate and reliable data sources for reporting. Through the program, the participants are coached to create their own macros that they can customize and use immediately upon completion. Learn More