Microsoft Excel Formulas and Functions: Beginner to Expert
Master Spreadsheet Skills with Step-by-Step Guidance on Formulas, Functions, and Data Analysis.
18
students
4 hours
content
May 2025
last update
$49.99
regular price
What you will learn
Navigating Worksheets and Workbooks
Cell Referencing: Relative, Absolute, and Mixed References
Basic Operators: +, -, *, /, ^
Common functions: SUM, AVERAGE, COUNT, MAX, MIN
Text Formatting and Data Cleaning
Conditional Formatting
Calculating Durations and Deadlines
VLOOKUP, HLOOKUP, INDEX, MATCH
Data Analysis and Interpretation
Formatting and Customizing Charts
Filtering and Grouping Data
Adding Data Labels and Legends
Creating and Using Array Formulas
Advanced Data Analysis Techniques
Creating Drop-Down Lists
Restricting Data Entry with Data Validation
Course Gallery
Loading charts...
6634655
udemy ID
25/05/2025
course created date
29/05/2025
course indexed date
Bot
course submited by