Pre-requisites
Basic English Literacy
Basic knowledge of Excel would be beneficial for this workshop.
+65 8303 9150 / +65 9138 9813
INFO@XALTIUS.TECH
ADVANCED ANALYTICS USING EXCEL
IBF Accredited Course
SkillsFuture Credit Claimable
Original Price: S$750
After Funding: $127.50 - $277.50
Virtual Live Online / Physical Classroom
This course is designed for learners who wish to design storyboards and data displays to communicate key insights, trends and findings derived from data, incorporating new and advanced visualization techniques and messaging aligned to business needs and audience.
Upcoming Runs!
1. Saturday 19th Nov & Saturday 26th Nov (9AM – 6PM Weekend Class) – Physical Classroom/Virtual Live Online
2. Thursday 8th December & Friday 9th December (9AM – 6PM Weekday Class) – Physical Classroom/Virtual Live Online
Upcoming Webinars – CLICK HERE
Course Schedule
Next Available Schedule – WEEKEND CLASS! – FILLING FAST!
- Start Date: Saturday, 19th Nov, 2022
- End Date: Saturday, 26th Nov, 2022
- Available Spots: 15
What you'll learn
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
Course Duration
1
Hours
Including 2 hours of Assessment
1
Days
Have a look
Course Outline
- In this module the learners will learn about various data transformation functions and will be able to apply the relevant function based on their use case with their own data.
● Logical functions: SUMIF, AVERAGEIF, IFS, and others
● Aggregation functions: SUM, AVERAGE, AGGREGATE, and others
● Additional functions for data transformation
- In this module the learners will learn about various lookup functions as well as on how to handle errors.
● VLOOKUP
● HLOOKUP
● IFERROR
- In this module the learners will learn XLOOKUP, FUZZY LOOKUP, partial lookup using wildcards as well as lookup using INDEX and MATCH. The learners will be able to understand the usage of the various lookup functions and its applications.
- In this module the learners will get comfortable with different date functions like
NETWORKDAY.INTL, WORKDAY.INTL and how to handle data related to the calendar.
- In this module the learners will learn to apply different text functions for data transformation.
● Split columns with delimiters
● Text functions: TEXTJOIN, CONCAT and others
- This module will allow the learners to learn powerful features to summarize and organize the data for analysis.
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
After the course
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!
Funding Information
*Participants need to meet the attendance and assessment requirements to be eligible for the funding
Ready to be a Data Enthusiast?
Join our 16 hours Advanced Analytics using Excel course and learn to work with data to create amazing and interactive reports!