Mastering Microsoft Excel Data Analysis with Functions

Microsoft Excel Data Analyze Faster and Smarter with Excel Functions—Perfect for Students, Analysts, and Professionals
Udemy
platform
English
language
Microsoft
category
instructor
Mastering Microsoft Excel Data Analysis with Functions
741
students
4 hours
content
Jul 2025
last update
$19.99
regular price

What you will learn

Entering and Editing Data in Cells

Data Alignment and Text Wrapping

Formatting Cells (number formats, fonts, colors)

Arithmetic Operators (+, -, *, /)

Using Functions with Cell References

Sorting Data in Ascending/Descending Order

Filtering Data Based on Criteria

Creating Data Validation Rules

Understanding Logical Tests and Cconditions

Using IF Function for Decision Making

Looking up Values in a Table

Adding Fields, Filters, and Calculations to Pivot tables

Understanding the Purpose of Pivot Tables

Conditional Calculations with SUMIF, COUNTIF, AVERAGEIF

Text Functions (LEFT, RIGHT, MID, CONCATENATE)

Different Chart Types (bar charts, line graphs, pie charts)

Customizing Chart Appearance

Adding Data Labels and Legends

Performing Regression Analysis

Course Gallery

Mastering Microsoft Excel Data Analysis with Functions – Screenshot 1
Screenshot 1Mastering Microsoft Excel Data Analysis with Functions
Mastering Microsoft Excel Data Analysis with Functions – Screenshot 2
Screenshot 2Mastering Microsoft Excel Data Analysis with Functions
Mastering Microsoft Excel Data Analysis with Functions – Screenshot 3
Screenshot 3Mastering Microsoft Excel Data Analysis with Functions
Mastering Microsoft Excel Data Analysis with Functions – Screenshot 4
Screenshot 4Mastering Microsoft Excel Data Analysis with Functions

Loading charts...

6737247
udemy ID
24/07/2025
course created date
31/07/2025
course indexed date
Bot
course submited by