Advanced Analytics using Excel

ADVANCED ANALYTICS USING EXCEL

IBF Accredited Course
SkillsFuture Credit Claimable

Original Price: S$750
After Funding: $285 - $435
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. 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.

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

Hours

Including 2 hours of Assessment

Days

Have a look

Course Outline

LOGICAL AND AGGREGATION FUNCTIONS IN EXCEL

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

REFERENCING - LOOKUP AND HANDLING ERRORS

In this module the learners will learn about various lookup functions as well as on how to handle errors.
● VLOOKUP
● HLOOKUP
● IFERROR

ADVANCED LOOKUP FUNCTIONS

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.

DATE FUNCTIONS

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.

WORKING WITH TEXT

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

SUBTOTAL AND GROUPING

This module will allow the learners to learn powerful features to summarize and organize the data for analysis.

PIVOT TABLES

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

DATA MODELLING AND VISUALIZATION – POWER QUERY AND CHARTS

ADVANCED DATA ANALYTICS

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!