ACEFM – Excel for Business Analytics

About Course

This course is designed to give a practical exposure to one of the most sought after Data skills- Excel. Whether you are a beginner, a budding data enthusiast or someone looking to explore Data Science, this course would train you on exactly what industry is looking for. The course has been created to cater to both : technical or non-technical professionals

Session Plan:

16th Nov 2024
23rd Nov 2024
30th Nov 2024
7th Dec 2024
14th Dec 2024
21st Dec 2024

Start time: 10:30 am to 12 noon
Break: 12:00 to 12:30 pm
End time: 12:30 to 2 pm

Course Content

Knowing the portal

Getting used to Klaymatrix portal

00:00
Knowing your instructor

00:00

Day 1 – Excel Essentials

Day 2 – Working with Data & Lookup Functions

Day 3 – Advanced Functions and Data Manipulation

Day 4 – Visualizations and Storytelling

Day 5 – Building Dashboards and Advanced Analysis

Day 6 – Dashboards and Final Review
Roughly we would be covering: 1. Power Query - what they are and its basic functioning 2. Case Study: The problem statement (using the data shared with us) and creating an automated tracker with the help of power query. This would include creating a folder structure, standardization of data, writing power query and automatic collation in the tracker - month/client wise

ACEFM Case Study
ACEFM data based case study using their data in excel files. This case study is for demonstrating how powerquery in excel can be used to do automation to clean, transform and combine data.

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Knowing the portal

Getting used to Klaymatrix portal

Knowing your instructor

Day 1 – Excel Essentials

Pre Test

Introduction to Excel and Its Capabilities

Quickfire Quiz: Test Your Basics!

Walkthrough of Essential Excel Elements

Essential Keyboard Shortcuts

Cell Basics and Referencing (Absolute, Relative, and Mixed)

Quiz – Cell Referencing

Understanding Data Types in Excel

Day 2 – Working with Data & Lookup Functions

Mastering VLOOKUP and Data Validation

Quiz-vlookup and data validation

Introduction to Data Aggregation and Granularity

Working with Pivot Tables: Data Summarization and Insights

Conditional Formatting: Highlighting Key Data Points

Quiz-Pivot Table and Conditional Formatting

Day 3 – Advanced Functions and Data Manipulation

Text Functions: Transforming and Cleaning Data

Date and Time Functions: Managing Temporal Data

Sorting and Filtering Data for Insights and Organization

Excel- Text Functions

Day 4 – Visualizations and Storytelling

Introduction to Graphs and Charts for Visual Data Representation

Case Study on Data visualization

Day 5 – Building Dashboards and Advanced Analysis

Dashboards in Excel – Part 1

Combining Multiple Charts for Dynamic Dashboards

Introduction to Basic Statistics in Excel (Mean, Median, Mode)

Applying Basic Statistical Analysis in Reports

Dashboards in Excel – Part 2 (Interactive Elements, Slicers)

Advanced Pivot Table Techniques for Dashboards

Recap of Key Concepts Covered

Final Quiz: Dashboards and Key Topics

Practice Exercises and Group Activity

Quiz – Post-Test

How to add your certificate on LinkedIn

Case Study

ACEFM Case Study ACEFM data based case study using their data in excel files. This case study is for demonstrating how powerquery in excel can be used to do automation to clean, transform and combine data.

Case Study

Earn a certificate

Student Ratings & Reviews

ACEFM Case Study
ACEFM data based case study using their data in excel files. This case study is for demonstrating how powerquery in excel can be used to do automation to clean, transform and combine data.