Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Complete Microsoft Excel Data Analysis Basic to Advanced
Rating: 4.3 out of 5(78 ratings)
6,811 students

The Complete Microsoft Excel Data Analysis Basic to Advanced

Microsoft Excel Data Analysis: Build Your Excel Data Analysis Skills from Scratch and Advance to Professional Level
Created bySkillify Academy
Last updated 8/2025
English

What you'll learn

  • Understanding the Excel Interface
  • Basic Formulas and Functions
  • Working with Data Types and Formats
  • Data Validation and Error Checking
  • Identifying and Handling Missing Data
  • Cleaning and Formatting Data
  • Removing Duplicates and Outliers
  • Pivot Tables and Pivot Charts Basics
  • Pivot Tables and Pivot Charts Basics
  • Descriptive Statistics
  • Correlation and Regression Analysis
  • Data Analysis ToolPak
  • Correlation and Regression Analysis
  • Creating Effective Charts and Graphs
  • Customizing Charts and Graphs
  • Dashboard Creation
  • Connecting to Data Sources
  • Transforming and Shaping Data
  • Merging and Appending Data
  • Creating Data Models
  • Building Relationships Between Tables

Course content

1 section • 28 lectures • 3h 58m total length

  • Understanding the Excel Interface7:26
  • Basic Formulas and Functions9:02

    Learn the basics of Excel formulas and functions, including sum, average, min, max, and if. Explore proper formula syntax, autofill, and relative versus absolute references for data analysis.

  • Working with Data Types and Formats8:17

    Learn how to identify and format data types in Excel, including text, numbers, currencies, and dates, apply number formats, decimals, and conditional formatting to create professional, consistent spreadsheets.

  • Data Validation and Error Checking8:44
  • Identifying and Handling Missing Data7:30
  • Cleaning and Formatting Data9:07

    Learn to clean and format data in Excel using five techniques: remove duplicates, fix blanks, split into columns, standardize formatting, and apply data validations.

  • Removing Duplicates and Outliers6:41
  • Text to Columns and Text to Rows5:11

    Master text to column and text to row in Excel to split names into first and last columns and convert rows to columns using delimited space or fixed width data.

  • Pivot Tables and Pivot Charts Basics8:34

    Master pivot tables and pivot charts to quickly summarize and visualize data, analyze sales by regions and products, and use filters and slicers to refine insights.

  • Logical Functions (IF, AND, OR, NOT)9:44
  • Text Functions (CONCATENATE, LEFT, RIGHT, MID)6:12

    Learn how to manipulate and clean data in Excel using text functions: concatenate, left, right, and mid to combine names, extract prefixes, suffixes, and middle parts with practical examples.

  • Date and Time Functions (TODAY, NOW, DATEDIF)4:11
  • Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)11:02

    Master lookup and reference functions in Excel, including vlookup, hlookup, xlookup, index, and match, to locate data across tables, perform exact matches, and build flexible dynamic reports.

  • Statistical Functions (AVERAGE, SUM, COUNT, MAX, MIN, STDEV)6:43

    Master how to use average, sum, count, max, min, and stdev as statistical functions in Excel to analyze data, summarize results, and understand datasets.

  • Descriptive Statistics10:47

    Explore descriptive statistics in Excel by calculating mean, median, mode, rank, variance, and standard deviation using built-in functions and the data analysis Toolpak to summarize sales data efficiently.

  • Correlation and Regression Analysis9:14

    Explore correlation and regression analysis in Excel to understand relationships between variables and predict sales based on ad spend, using the Data Analysis Toolpak and a scatter plot.

  • Hypothesis Testing6:34

    Learn to run hypothesis testing in Excel, using a two-sample t test to compare mean sales between two stores, guided by data prep, the data analysis toolpak, and p-value interpretation.

  • Creating Effective Charts and Graphs5:34

    Learn how to create effective charts and graphs in Excel by selecting data, choosing chart types, and customizing layouts, titles, colors, and labels to clearly communicate your data.

  • Customizing Charts and Graphs8:16

    Learn to customize Excel charts and graphs to communicate data clearly in reports, dashboards, and presentations. Create a chart from sales data, and adjust titles, fonts, colors, labels, and legend.

  • Formatting and Styling Charts10:03
  • Dashboard Creation11:35
  • Connecting to Data Sources9:52

    Learn to connect Excel to external data sources—workbooks, text/CSV, databases, web pages, and online services—and refresh data automatically for a dynamic dashboard.

  • Transforming and Shaping Data11:17

    Learn to transform and clean data in Excel using text functions, text to columns, concatenate and text join, and reshape with pivot tables and Power Query for well-organized analysis.

  • Merging and Appending Data11:57

    Learn to merge and append data in Excel using Power Query, combining multiple sources into a single, clean table with consistent headers and key-field joins.

  • Introduction to Power Pivot8:27

    Explore Power Pivot in Excel to link tables, build relationships, create calculated columns, and build pivot tables for faster data analysis across large datasets.

  • Creating Data Models9:34

    Learn to create and manage data models in Excel by linking tables, establishing relationships, and using PivotTables and PowerPivot to analyze multi-table data.

  • Building Relationships Between Tables7:25

    Link related tables using relationships in Excel to unlock pivot tables and Power Pivot for advanced data analysis.

  • Creating Slicers, Time Sliders, and Filters9:14

Requirements

  • No prior Excel experience is needed — start from the basics and gradually build up to advanced analytics.

Description

Microsoft Excel remains one of the most powerful tools for data analysis — trusted by professionals in business, finance, research, and beyond. This comprehensive course will guide you step-by-step from the very basics of Excel data handling to advanced analytical techniques used by experts.


Are you tired of:

  • Spending hours manually cleaning and organizing messy data?

  • Struggling to find key insights hidden within large datasets?

  • Creating static reports that fail to tell a compelling story?

  • Missing out on career opportunities that require strong data analysis skills?


If so, this course is your solution!


Begin with the essential tools for data preparation. You'll master techniques for importing, cleaning, and transforming raw data into a usable format. I'll cover powerful features like Text to Columns, Flash Fill, Remove Duplicates, and advanced filtering, ensuring your data is always ready for analysis.


Next, I'll dive deep into the world of Excel's functions and formulas for data analysis. You'll master crucial functions like SUMIFS, COUNTIFS, AVERAGEIFS, and learn how to perform complex lookups with VLOOKUP, XLOOKUP, and the powerful INDEX/MATCH combination. I'll also explore array formulas and logical functions to automate decision making processes.


The core of this course is dedicated to data visualization and reporting. You'll learn to create dynamic and interactive dashboards using PivotTables and PivotCharts. I'll show you how to use slicers and timelines to filter data with a single click, allowing you to present compelling, data driven stories to your stakeholders. I'll also cover a wide range of chart types, teaching you which one to use for a given dataset to maximize impact.


Finally, I'll tackle advanced topics that will truly set you apart. You'll be introduced to Power Query, Excel's revolutionary tool for automating data extraction and transformation. I'll also explore data modeling, basic statistical analysis, and learn how to use What If Analysis tools like Goal Seek and Data Tables to make data backed predictions and strategic decisions.


What You Will Learn:

  • Excel Fundamentals – Navigate the interface, work with workbooks, and manage data efficiently.

  • Data Cleaning & Preparation – Remove duplicates, handle missing values, and structure data for analysis.

  • Formulas & Functions – Apply essential and advanced functions like SUMIF, VLOOKUP, INDEX-MATCH, and more.

  • Data Analysis Tools – Use PivotTables, PivotCharts, and slicers for quick insights.

  • Statistical Analysis in Excel – Perform descriptive statistics, trend analysis, and forecasting.

  • Advanced Data Visualization – Create interactive charts, dashboards, and reports.

  • Power Query & Power Pivot – Automate data import, transformation, and modeling.

By the end of this course, you will not only be proficient in Excel but will possess the analytical mindset to tackle any data challenge. You'll have the skills to transform raw data into actionable insights, making you a valuable asset in any organization.


Take the step from beginner to Excel data analysis expert and supercharge your productivity.

Who this course is for:

  • Anyone who wants to transition into a data analysis role.
  • Business professionals, managers, and students who need to analyze and report on data.
  • Financial analysts, marketing specialists, and operations managers who want to automate their reporting.
  • Excel users who want to move beyond basic functions and master data analysis.

Report abuse