1. Saturday 6th Aug & Saturday 13th Aug (9AM – 6PM Weekend Class) – Physical Classroom/Virtual Live Online
2. Saturday 17th Sep & Saturday 24th Sep (9AM – 6PM Weekend Class) – Physical Classroom/Virtual Live Online
3. Sunday 9th October & Sunday 16th October (9AM – 6PM Weekend Class) – Physical Classroom/Virtual Live Online
Physical Classroom Location: Lifelong Learning Institute, Paya Lebar MRT9
Upcoming Webinars – CLICK HERE
Next Available Schedule – WEEKEND CLASS! – FILLING FAST!
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
For Self-Sponsored Individuals (From 1st July 2022)
For Company-Sponsored Individuals (From 1st July 2022)
Join our 16 hours Advanced Analytics using Excel course and learn to work with data to create amazing and interactive reports!