AI-Powered Microsoft Excel: ChatGPT, Claude & Visualization

Name: AI-Powered Microsoft Excel: ChatGPT, Claude & Visualization
Rating: 4.8 (285 reviews)

Master Excel Formulas, Shortcuts, Charts, Dashboards, VBA & Macros for Powerful Data Analysis and Visualization

Created byShahzad Khan

Last updated 10/2026

English

What you'll learn

Master essential Microsoft Excel skills — including data entry, formatting, formulas, and functions for efficient data management and analysis
Analyze and visualize data effectively using Excel tools such as charts, graphs, conditional formatting, and dynamic dashboards
Apply advanced Excel functions like VLOOKUP, HLOOKUP, IF, COUNTIF, CONCATENATE, and more to solve real-world data problems
AI tool integration with excel, utilization artifical intelligence for office productivity, precision and visual enhancements in assigned tasks
Use Excel shortcuts and tips to boost speed, accuracy, and workflow efficiency for business and personal projects
Build professional Excel projects — including data trackers, reports, and dashboards for clear, actionable insights

Course content

7 sections • 40 lectures • 3h 48m total length

1. Exploring the Excel Start Screen and Key Features5:18
Explore the Microsoft Excel start screen, open a blank workbook or templates, access recent and pinned files, and open workbooks from pc or OneDrive for data analysis and visualization.
2. Understanding Worksheets, Cells, Rows & Columns Structure5:56
Explore workbook and worksheet basics, learn how cells are defined by rows and columns, input and format data, create and rename sheets, and apply date, currency, and border formatting.
3. Formatting Tables and Applying Conditional Formatting4:42
Format and analyze data in excel tables with designs and a total row for min, max, and sum. Use conditional formatting color scales and status bar to interpret sales data.
4. Essential Excel Formulas, Functions & Data Sorting Techniques5:51
Master Excel formulas and functions, using the equal sign and sum on ranges like B2:B4 to compute totals. Learn to sort and filter data to analyze date and value.
5. Creating Charts and Sharing Workbooks with Collaborators2:31
Learn to create Excel charts from data using the insert chart options, customize colors, axis labels, and grids, and analyze sales data showing August peak at 97 (November 2024–March 2026).

1. Excel Data Types: Text, Numbers, Dates & Formulas11:44
Explore text labels, numbers, dates and times, booleans, errors, and constant versus formula data in Excel. Learn cell formatting, basic conditional logic, and common error handling.
2. Data Entry Methods: Manual, AutoFill & Flash Fill3:14
Learn manual data entry, autofill with the fill handle, and flash fill in Excel, including creating series for numbers, dates, times, and keyboard shortcuts like Ctrl E.
3. Data Validation: Drop-downs, Rules & Error Alerts6:21
Learn data validation and entry control in Excel, including restricting data types, setting numeric and date ranges, creating drop-down lists, and customizing error alerts and input messages.
4. Project: Build an Employee Tracker with Data Validation in Excel6:55
Build an employee tracker in Excel using a structured table, data validation, and drop-down lists to constrain departments and status, with date rules to prevent invalid join dates.
5. Assignment: Data Entry & Validation Practice1:38
Practice an Excel data validation assignment to design a student registration log, using auto fill for IDs, flash fill for names, date range limits, drop-downs, and error alerts.

1. Basic Text & Cell Formatting in Excel2:29
Learn to format cells in Excel by adjusting font style and size, applying colors and borders, and setting data types (text, date, number with two decimals) for clear spreadsheets.
2. Insert & Delete Rows and Columns3:24
Learn how to insert and delete rows, columns, and cells in Excel, shift data, and adjust column widths and row heights for clean, organized worksheets.
3. Merge, Wrap, Align Cells & Convert to Table2:42
Learn to merge cells to create a title across columns, wrap and align text, and convert data to a table with a header for sorting and filtering.
4. Text Orientation & Auto Adjust Column Width0:28
Learn to orient text in a cell with diagonal orientations and use a shortcut to adjust column width by selecting the header, choosing angle counterclockwise, and pressing Alt H.
5. Conditional Formatting & Freeze Rows/Columns4:29
Apply conditional formatting in Excel to highlight values with color scales and data bars. Hide or unhide rows and columns, find or replace values, and freeze the header for context.

1. Formula Bar & Basic Arithmetic Formulas4:06
Explore the formula bar in Excel to create basic formulas for add, subtract, multiply, and divide; apply them across rows, and handle division by zero errors.
2. Core Functions: SUM, MIN, MAX, COUNT & COUNTA3:54
Learn to use sum, min, max, count, and counta to analyze data: sum values, identify minimums and maximums, and understand how count vs counta treat numeric vs text entries.
3. Quick SUM Shortcuts in Excel Tables0:29
Learn a fast Excel shortcut to sum a range by highlighting numbers and pressing Alt plus equals, instantly totaling without typing formulas.
4. AVERAGE, MEDIAN & CONCATENATE Functions7:57
Classify values as greater or lower than three. Use count to tally values above ten, and vlookup with exact match to fetch prices and sum totals, locking with dollar signs.
5. IF, COUNTIF & VLOOKUP Explained7:57
Apply conditional statements in Excel with if to label values as greater or lower than three. Use countif and Vlookup to sum prices from a table, locking references with dollars.
6. Text Functions: PROPER, UPPER & LOWER0:26
Master three essential Excel formulas: proper for proper case, upper for uppercase, and lower for lowercase, to transform and standardize text.
7. IF & Nested IF with Practical Examples5:30
Master using if and nested if in excel to handle multiple conditions and assign grades based on student scores.
8. Multi-Column VLOOKUP in Excel0:33
Perform multi-column vlookup in Excel by selecting a range, using curly brackets 2 and 3 for the second and third columns, and 0 for an exact match; drag to apply.
9. HLOOKUP Function with Examples4:51
Learn how to use the hlookup function in Excel, including its four arguments and exact versus approximate match, with examples to fetch scores and grades from a table.

1. Data Visualization Using Pie Charts5:03
Visualize data in Excel by creating a dynamic pie chart from a source table and customizing colors. Resize and move the chart for more months with live updates.
2. Bar Charts for Data Analysis8:51
Learn to create and customize bar charts in Excel, including the clustered column bar chart, labeling values, adjusting colors, fonts, and chart styles using monthly sales data.
3. Scatter Plots for Trend Analysis14:06
Learn to create a scatter plot in Excel to visualize the relationship between two data sets, identify outliers, and customize colors and formatting.

Introduction to Chatgpt for Excel: Feature set, Skills, Prompt and Examples8:10
Explore how to integrate ChatGPT with Microsoft Excel to build, edit, analyze, and summarize workbooks, using precise prompts and verification steps.
Installing and Exploring Features of Chatgpt in Excel5:35
Example of Effective Prompt: Cleaning an Expense Workbook11:48
Writing effective Excel prompt13:44
Chatgpt Prompt for Correcting and Inserting formula in Excel Work sheet5:37
Chatgpt Prompt Example for Correcting an average formula5:20
Chatgpt Prompt to Analyzing data and identifying trends6:09
Chatgpt for Creating a Chart in Excel Worksheet2:20

Claude Plugin Installation, Setup, and the Interface7:09
Claude AI Plugin in Excel - Writing Effective Prompts for Spreadsheets6:53
Example Prompt Writing for Claude in Excel - Grade calculation for students8:31
AI Prompt for Excel: Use Claude to Generate a Summary Worksheet7:14
Explore how to craft a strong Claude prompt to generate a summary worksheet in Excel, covering context, scope, actions, and checks, with a monthly, category-based spending summary and charts.
Excel + Claude: Create Prompts for Lookup Between Two Worksheets8:21

Requirements

No prior experience with Excel or data analysis is required — this course is designed for complete beginners
A computer or laptop capable of running Excel smoothly
A willingness to learn by practicing — hands-on exercises will help you master the skills quickly
Basic computer knowledge (typing, file saving, navigation) is helpful but not mandatory

Description

Learn Microsoft Excel the modern way, with AI doing the heavy lifting.

Most Excel courses teach you to type formulas by hand. This course also shows you how to work faster with ChatGPT and the Claude plugin inside Excel, so you can write formulas, fix errors, and turn raw data into clear visuals in minutes.

You start from zero. No prior Excel experience is needed. By the end, you’ll be comfortable with the Excel interface, building clean worksheets, writing formulas, and presenting your data with professional charts.

What you’ll learn

Navigate the Excel interface and core features with confidence
Enter data accurately and efficiently
Format and lay out worksheets so they look clean and professional
Use essential Excel formulas and functions
Create charts, graphs and scatter plots that make data easy to understand
Use ChatGPT to write, explain and fix Excel formulas
Use the Claude plugin to speed up your work inside Excel
Write effective prompts to get accurate results from AI

Course sections

Excel Basics & Interface Overview
Data Entry Techniques in Excel
Formatting and Layout Design
Excel Formulas & Functions
Data Visualization in Excel: Charts, Graphs and Scatter Plots
Getting Started with AI-Powered Excel: ChatGPT for Microsoft Excel
AI-Powered Excel with the Claude Plugin

Who this course is for

Complete beginners who want to learn Excel from scratch
Students and job seekers who want Excel and AI skills on their resume
Office professionals who want to save time on reports and analysis
Freelancers and business owners who want to work with data faster

Requirements

A computer with Microsoft Excel installed
Access to ChatGPT and Claude (free accounts are enough to follow along)

Enroll today and start working smarter with Excel and AI.

Who this course is for:

Want to learn Microsoft Excel from scratch and gain practical data skills — from Beginner to Advanced, including Macros and VBA
Students and job seekers looking to strengthen their resume with Excel and data analysis expertise
Professionals, business owners, and managers who want to organize, analyze, and visualize data efficiently
Data enthusiasts and analysts who want to improve their Excel proficiency for reporting and dashboard creation
Anyone who wants to save time by learning Excel shortcuts, formulas, VBA, and Macros for automation.

AI-Powered Microsoft Excel: ChatGPT, Claude & Visualization

What you'll learn

Explore related topics

Course content

Excel Basics & Interface Overview5 lectures • 24min

Data Entry Techniques in Excel5 lectures • 30min

Formatting and Layout Design5 lectures • 14min

Excel Formulas & Functions9 lectures • 36min

Data Visualization in Excel, Charts, Graphs and Scatter plots3 lectures • 28min

Getting Started with Ai Powered Excel: Chatgpt for Microsoft Excel8 lectures • 59min

AI-Powered Excel with the Claude Plugin5 lectures • 38min

Requirements

Description

Who this course is for: