Free Udemy Course __ Microsoft Excel: Master Data Analysis, Cleaning & Dashboards

Learn to clean, analyze, and visualize data in Excel to create stunning, interactive dashboards with real insights.

4.5 (928 students students enrolled) English
professional Office Productivity
Microsoft Excel: Master Data Analysis, Cleaning & Dashboards

What You'll Learn

  • Introduction to Excel for Data Analysis
  • Understanding the Excel Interface
  • Importing Data into Excel
  • Formatting Data for Analysis
  • Removing Duplicates
  • Handling Missing Data
  • Standardizing Data Formats
  • Using CONCATENATE, LEFT, RIGHT, and MID
  • TRIM, CLEAN, and SUBSTITUTE Functions
  • Using Conditional Formatting
  • SUM, AVERAGE, COUNT, and COUNTA
  • Logical Functions: IF, AND, OR
  • Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
  • Creating and Formatting Pivot Tables
  • Using Calculated Fields and Items
  • Creating Bar, Line, and Pie Charts
  • Customizing Chart Styles and Layouts
  • Choosing The Right Chart for Your Data
  • Linking Charts to Dynamic Data
  • Descriptive Statistics (Mean, Median, Mode)
  • Variance and Standard Deviation
  • Using Analysis ToolPak for Statistical Functions
  • Transforming and Shaping Data
  • Merging and Appending Data
  • Creating Data Models
  • Relationships Between Tables

Requirements

  • You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
  • No microsoft excel experience needed

Who This Course is For

  • Anyone who wants to save time and get the most out of Microsoft Excel.
  • Anyone who wants learn Microsoft Excel.
  • Students and professionals who want to improve their excel skills.
  • Entrepreneurs and office workers who prepare financial report regularly.

Your Instructor

Logic Labs

Instructor at Udemy | Programming | Data Analytics | AI Tool

4.5 Instructor Rating

9 Reviews

5,097 Students

25 Courses

Get This Course For FREE

Get This Course

Limited time offer. Enroll now!

Never Miss a Coupon!

Subscribe to our newsletter to get daily updates on the latest free courses.