PREMIUM

Microsoft Excel Training Course

Excel Training: Beginners to Advanced

10 hrs 2 projects

Learn essentials in Excel like data visualization, pivot tables, conditional formatting, data cleaning, budgeting, and more. This course also explores how ChatGPT enhances productivity in Excel workflows.

$40 $80 50% off

Buy Course

Preview Course

Key Highlights of the course

Go from basic to intermediate level skills

Learn from top faculty & experts

Guided Projects for hands-on learning

Earn a recognized certificate

Doubt clearance and hints with AI

Key Highlights of the course

Go from basic to intermediate level skills

Learn from top faculty & experts

Guided Projects for hands-on learning

Earn a recognized certificate

Doubt clearance and hints with AI

Skills you will gain

Data Visualization

Pivot Tables

Conditional Formatting

Data Cleaning

Cell Referencing

If-Else Logic Budgeting Techniques

Business Intelligence

ChatGPT in Excel

Become a skilled professional

Learn from the best

Taught by top faculty & industry experts

Learn by doing

Apply skills with guided projects and interactive coding exercises

Mock Interview

Guided Projects

Coding Exercises

Learn with AI

Get AI-powered coding hints & instant doubt resolution

24x7 Doubt resolution

Coding Hints

Course outline

Industry focussed curriculum designed by experts

Introduction to Excel

18 Videos

In this module, you'll explore essential Excel techniques including cell referencing, sorting, filtering, data cleaning, conditional formatting, text manipulation, and dynamic chart creation to analyze and visualize data confidently.

18 videos

4 hours and 10 minutes

Introduction
Cell referencing
Tables and Borders
Sorting
Filtering
Date and Time
If Else
General Functions in Descriptive Analytics
Sub Strings
Text Data
Rounding Off
Conditional Formatting
Data Mapping
Offset and Dropdown
Data aggregation
Data Visualization
Charts - Part 1 and 2

Preview module

Excel - Case Study

2 Videos

In this module, you'll examine practical applications of Excel in business, tackling real-world challenges through data management, manipulation, financial analysis, and reporting to develop effective solutions.

2 videos

1 hour 30 minutes

Case Study Introduction
Case Study Briefing

ChatGPT for Excel

11 Videos

In this module, you’ll explore AI integration in Excel for data analysis, generating functions, analyzing dashboards, preparing financial statements, and mastering pivot tables to enhance your financial analysis skills.

11 videos

2 Hours

Introduction to AI
Introduction to ChatGPT
Understanding Excel using ChatGPT
Types of functions in Excel
Preparation of Financial statements using ChatGPT
Generating Excel functionals using ChatGPT
Interpretations of Financial Reports using ChatGPT
Pivot Tables and Pivot Charts using ChatGPT
Financial Report Dashboard Analysis using ChatGPT
Summary

Applications of Excel

16 Videos

In this module, you'll learn Personal Budgeting techniques in Excel, including goal setting and expense management, while exploring Business Intelligence principles, focusing on data analysis, visualization, and Excel tools for decision-making.

16 videos

2 hour 17 minutes

Introduction to Savings and Investments
Types of Financial Goals
Introduction to Budgeting
Budget Categories and Budgeting Methods
Creating Budget using Excel
Tips to avoid Debts
Summary of Personal Budgeting with Microsoft Excel
Business Intelligence using Excel - Agenda
Introduction to Business Intelligence
Data Analysis vs Business Intelligence
Advantages of BI solutions over Excel Reporting
Excel alternatives in BI
Excel-based Business Intelligence Software
Data Visualization and Export - Demo
Data Importing and Organizing - Demo
Business Intelligence using Excel - Summary

Guided Excel Project 1 : E-Commerce

Guided Project 1

E-Commerce Project : Functional requirements and step-by-step guide

Guided Excel Project 2 : Aviation Sector Analysis using Excel

Guided Project 2

Aviation Sector Analysis Project : Functional requirements and step-by-step guide

Guided Projects

Solve real-world projects with a step-by-step guide, starter code templates, and access to model solutions to boost your skills and build a standout resume.

GUIDED PROJECT 1
AeroMax Airways: Data-Driven Insights for Optimizing Airline Operations and Passenger Experience
This project involves analyzing a large dataset from the aviation sector, including flight delays, passenger demographics, ticket pricing, and operational costs. Participants will uncover insights into flight delays, identify congested airports, analyze passenger satisfaction trends, and evaluate financial performance. The project emphasizes data cleaning, processing, and visualization to derive actionable recommendations for improving punctuality, enhancing customer experience, and optimizing profitability in the airline industry.

Data Analysis

Data Cleaning

Data Processing

PivotTables

Data Visualization

Statistical Analysis

Customer Insights

GUIDED PROJECT 2
StellarMart Analytics: Optimizing Retail Performance Through Data Insights
This project focuses on analyzing a retail dataset from StellarMart to identify sales trends, seasonal patterns, regional performance, and underperforming product categories. We will clean and process data, create dynamic visualizations, and generate actionable insights to support strategic decisions and drive profitability. Deliverables include an organized Excel workbook with cleaned data, aggregated metrics, and visualizations tailored for retail analytics

Data Analysis

Excel

Data Cleaning

Data Processing

PivotTables

Data Visualization

Sales Trend Analysis

Seasonal Trends

Regional Performance

Statistical Functions

Retail Analytics

Customer Insights

Business Intelligence

Course instructors

Mr. Aniruddha Kalbande

AI & Data Science Educator

Aniruddha is a serial entrepreneur and trainer. He is reskilling and upskilling students, working professionals, and freshers from across the Globe in the field of Data Science, Machine Learning, and Artificial Intelligence. For the past 5+ years, he has been helping learners to have a successful job transition in this domain from multiple locations across Europe, USA & India. He is widely followed by 25k+ working professionals, students, and young leaders across the globe.

Mr. Aniruddha Kalbande

AI & Data Science Educator

Key highlights of our premium courses

Self-paced learning for your convenience

Comprehensive short courses with industry-relevant curriculum

Learn foundation to intermediate level skills

Hands-on guided projects and interactive coding exercises

Get recognised with a certificate of completion

AI support for interactive learning & mock interviews

Earn a certificate and verify your skills

Stand out to recruiters

Share on professional channels

Globally recognised

Land your dream job

$40 $80 50% off

Buy Course

Preview Course

Key Highlights of the course

Go from basic to intermediate level skills

Learn from top faculty & experts

Guided Projects for hands-on learning

Earn a recognized certificate

Doubt clearance and hints with AI

Key Highlights of the course

Go from basic to intermediate level skills

Learn from top faculty & experts

Guided Projects for hands-on learning

Earn a recognized certificate

Doubt clearance and hints with AI

Great Learning is a globally renowned education platform

4.8

4.89

4.94

4.7

Application-driven learning to

Become a Skilled Professional with Premium Courses

Gain work-ready skills with guided projects, top faculty and AI tools, all at an affordable price.

AI & Data science

PREMIUM

51 coding exercises 3 projects

Master Python programming

11.5 hrs

$40 $80

View Course

PREMIUM

2 projects

Master Data Analytics in Excel

5.5 hrs

$40 $80

View Course

PREMIUM

10 coding exercises 3 projects

Master Generative AI

8.5 hrs

$90 $180

View Course

PREMIUM

136 coding exercises 6 projects

Master Data Science & Machine Learning in Python

17 hrs

$90 $180

View Course

PREMIUM

39 coding exercises 4 projects

Master Data Analytics in SQL & Excel

8.5 hrs

$60 $120

View Course

PREMIUM

18 coding exercises 3 projects

Master Artificial Intelligence

12.5 hrs

$90 $180

View Course

PREMIUM

39 coding exercises 2 projects

Master Data Analytics in SQL

4 hrs

$40 $80

View Course

PREMIUM

2 projects

ChatGPT for Working Professionals

12 hrs

$40 $80

View Course

english for study abroad

PREMIUM

Complete IELTS Preparation Course

11.5 hrs

$40 $80

View Course

PREMIUM

Complete TOEFL Preparation Course

8.5 hrs

$40 $80

View Course

PREMIUM

Complete Duolingo English Test (DET) Preparation

7.5 hrs

$40 $80

View Course

Advance your career with

Top University programs

Gain industry-relevant skills through learning from top faculty, guidance from industry mentors, and hands-on projects.

UNIVERSITY

MIT IDSS

Data Science and Machine Learning Program

12 weeks • Online

UNIVERSITY

MIT Professional Education

No Code AI and Machine Learning: Building Data Science Solutions

12 Weeks • Online

Learn from MIT Faculty

UNIVERSITY

MIT Professional Education

Applied Data Science Program

12 weeks • Live Virtual

UNIVERSITY

Johns Hopkins University

Certificate Program in Applied Generative AI

16 weeks • Online

UNIVERSITY

McCombs School of Business at The University of Texas at Austin

PG Program in Artificial Intelligence and Machine Learning: Business Applications

7 months • Online

UNIVERSITY

McCombs School of Business at The University of Texas at Austin

PG Program in Data Science and Business Analytics

7 months • Online

UNIVERSITY

McCombs School of Business at The University of Texas at Austin

PG Program in Cloud Computing: Leveraging GenAI

6 months • Online

360° Cloud Learning

UNIVERSITY

Johns Hopkins University

Certificate Program in AI Business Strategy

10 weeks • Online