Excel Data Mastery: Formulas, Functions, Charts, and Graphs
Master Excel's data analysis and visualization tools: formulas, functions, charts, and graphs.
19
students
3 hours
content
Jul 2025
last update
$19.99
regular price
What you will learn
Introduction to Excel Functions and Their Syntax
Understanding the Basics of Formulas
Working with Cell References: Relative, Absolute, and Mixed
Basic Arithmetic Operations in Excel
Text Functions: CONCATENATE, LEFT, RIGHT, MID
Logical Functions: IF, AND, OR, NOT
Date and Time Functions: TODAY, NOW, DATEDIF
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
Combining Functions in a Single Formula
Working with Array Formulas
Advanced Text Manipulation Functions: TRIM, LEN, SUBSTITUTE
Using Conditional Functions: SUMIF, COUNTIF, AVERAGEIF
Statistical Functions: AVERAGE, MEDIAN, MODE, STDEV
Error Handling Functions: IFERROR, ISERROR
Creating Basic Charts: Column, Line, Pie
Customizing Chart Elements: Titles, Labels, and Legends
Introduction to Sparklines for Data Trends
Creating Combo Charts for Comparative Analysis
Advanced Graphical Elements: Data Bars, Color Scales, Icon Sets
Using Macros to Automate Chart Creation
Introduction to VBA for Custom Chart Functions
Course Gallery
Loading charts...
6737369
udemy ID
24/07/2025
course created date
28/07/2025
course indexed date
Bot
course submited by