1. Thu 13th Apr & Friday 14th Apr 2023 (9AM – 6PM Weekday Class)
2. Wed 10th May & Thu 11th May 2023 (9AM – 6PM Weekday Class)
Upcoming Webinars – CLICK HERE
Pre-requisites
Basic English Literacy
Basic knowledge of Excel would be beneficial for this workshop.
This course provides participants with the knowledge and skills to work with raw data, perform data wrangling, build data models and analyze data with business cases using Microsoft Excel. Participants will learn to use Excel gather data, shape the data, use data models and create interactive reports.
Through this course, participants can learn that Excel is a powerful tool as well and can help centralize, simplify, and streamline data tasks efficiently at a small scale.
Learn Excel functions, data aggregation, pivot tables, and other advanced analytics features that Excel has to offer!
Key Takeaways:
After going through the course, participants will:
● Be able to work with and shape data on Excel
● Be able to understand why Excel Functions are powerful
● Be able to control the transformation of data
● Be able to summarize and aggregate data efficiently
● Be able to have a grasp over data analytics
● Be able to build interactive reports for analysis
● Experience varying business cases from different perspectives
Including 2 hours of Assessment
By the end of this module, the learners will get a hands-on experience working on pivot table and the various components of pivot tables. Additionally, the learners will also learn how to perform quick analysis.
● Data summarization using pivot tables
● Quick analysis using sparkline charts
● Top N Filtering using LARGE Function
By the end of this module, the learners will get an understanding of ETL process, get comfortable in extracting data from multiple sources both live and static, cleaning them in power query and finally loading them in Excel. The learners will also learn to create an interactive dashboard for detailed analysis.
By the end of this module, the learners will get an understanding of ETL process, get comfortable in extracting data from multiple sources both live and static, cleaning them in power query and finally loading them in Excel. The learners will also learn to create an interactive dashboard for detailed analysis.
● What If Analysis and Scenario Manager
● Statistical analysis using Descriptive Statistics
● Correlation analysis to identify relationships
● Forecasting in Excel
Post course participant perks!
● Up to two weeks post course support
● Access to a Telegram channel with like-minded people and course alumni
● Access to our job placement partners
Don’t miss this amazing opportunity!
*Participants need to meet the attendance and assessment requirements to be eligible for the funding
Join our 16 hours Advanced Analytics using Excel course and learn to work with data to create amazing and interactive reports!