Excel Mastery: Formulas and Functions

Learn all about formulas and functions. The ins and outs, the shortcuts, best practices and tips.
4.49 (80 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel Mastery: Formulas and Functions
1,627
students
1.5 hours
content
Jul 2024
last update
FREE
regular price

What you will learn

Taught by a 2 time Excel MVP

Learn the basics of entering formulas

Learn how to use the Insert Function tool to understand every function in Excel

Understand what absolute and relative referencing are

Utilize named ranges to make your spreadsheets more efficient

Learn lookup functions like: Xlookup, Vlookup, and Index-Match

Use IF statements to add dynamic flexibility to your spreadsheet models

Get a primer on the most frequently used text functions

Screenshots

Excel Mastery: Formulas and Functions - Screenshot_01Excel Mastery: Formulas and Functions - Screenshot_02Excel Mastery: Formulas and Functions - Screenshot_03Excel Mastery: Formulas and Functions - Screenshot_04
6071889
udemy ID
7/12/2024
course created date
7/26/2024
course indexed date
Bot
course submited by