- Emmy Farha Alias
- Nur Azreen Mokhyi
- This event has passed.
EXCEL for Data Analytics
17-05-2022 - 18-05-2022
Instructors
Introduction to the Course
Excel for Data Analytics introduces participants with little-to-no statistical or software expertise to basic statistical and visualisation tools using the intuitive and popular features in Microsoft Excel, such as Functions, Charts and PivotTables. The course covers data processing to regression modelling with varying degrees of complexity and requires much more advanced skills to manage. This course aims to enhance your expertise in Excel to the highest level and ensure a comprehensive understanding of all the advantageous features Excel can off your workplace.
Topics Covered
This course covers the data analysis tool in Microsoft Excel to help in making better decisions. This course provides from basic operations such as reading data into excel using various data formats, organising, and manipulating data, to various advanced functionality of Excel. Other topics include how to perform data analysis and reporting using the most popular features in Excel, such as pivot table, data model and regression. Towards the end, an introduction to the automation processes in Excel using Visual Basic for Applications will be carried out.