Microsoft Excel Data Analysis & Visualization Bootcamp

Name: Microsoft Excel Data Analysis & Visualization Bootcamp
Rating: 4.9 (262 reviews)

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

Created byShahzad Khan

Last updated 1/2026

English

English [Auto],

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
Automate tasks with Excel VBA and Macros to save time and improve productivity in data processing and reporting
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

5 sections • 27 lectures • 2h 11m 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
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.

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

Welcome to the Microsoft Excel Data Analysis & Visualization Bootcamp — your complete guide to mastering Excel skills fast!

In this practical and beginner-friendly course, you’ll learn how to use Microsoft Excel for data entry, data analysis, and visualization with real-world examples and projects. From building your first spreadsheet to creating dynamic dashboards and automating tasks with Excel VBA and Macros, you’ll gain the skills you need to work smarter, faster, and more efficiently.

Start by understanding Excel’s main interface, data types, and formatting tools. Then move on to formulas, functions, and shortcuts that help you clean, organize, and analyze data with ease. You’ll explore essential Excel features like SUM, IF, COUNTIF, VLOOKUP, HLOOKUP, and CONCATENATE, while learning conditional formatting, data validation, and table management.

Next, you’ll dive into Excel charts and dashboards, transforming raw data into clear, professional-quality visuals. You’ll also learn the basics of Excel VBA and Excel Macros — powerful tools that automate repetitive tasks and save valuable time.

By the end of this course, you’ll be able to:

Confidently use Excel formulas, functions, and shortcuts for quick data analysis
Create professional charts, graphs, and dashboards for impactful data visualization
Apply conditional formatting and data validation to clean and control data
Automate workflows using Excel VBA and Macros
Use Excel effectively for business, finance, analytics, and reporting

This Excel Bootcamp is perfect for beginners, professionals, students, and anyone who wants to improve their data skills. No prior experience is needed — just a willingness to learn and practice!

Join now and start mastering Microsoft Excel, Data Analysis, Data Visualization, Excel VBA, and Excel Macros — all in one comprehensive, time-efficient course.

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.

Microsoft Excel Data Analysis & Visualization Bootcamp

What you'll learn

Explore related topics

Course content

Module 1: Excel Basics & Interface Overview5 lectures • 24min

Module 2: Data Entry Techniques in Excel5 lectures • 30min

Module 3: Formatting and Layout Design5 lectures • 14min

Module 4: Excel Formulas & Functions9 lectures • 36min

Module 5: Data Visualization in Excel3 lectures • 28min

Requirements

Description

Who this course is for: