Welcome to Master Excel Functions
Intro to Excel Functions
-
Quick Intro (1:47)
-
Formulas Basics (For Complete Beginners) (4:27)
-
Absolute and Relative Referencing (5:10)
-
Sum and Product Function (4:16)
-
Named Ranges (2:55)
-
Average, Min and Max (4:47)
-
Calculating Across Sheets (3:31)
-
Calculating Across Workbooks - Intro to 3D Formulas (4:57)
-
3D Formulas - Options (3:42)
-
Consolidate by Position (4:06)
-
Consolidate by Category (4:46)
Text and Date Functions
-
Quick Intro (2:05)
-
Combine Text (7:07)
-
Change Case (3:40)
-
Clean Text - Clean, Trim and Substitute (5:21)
-
Split and Extract - Left, Mid and Right (5:09)
-
Split and Extract - Len and Find (6:16)
-
Extract Text - Office 365 (6:49)
-
Split Text - Office 365 (5:45)
-
Date Basics (6:02)
-
Generate Dates (3:28)
-
Calculate Days - Days, Networkdays, Workday (6:20)
-
Calculate Deadlines - EDATE and EOMONTH (5:19)
Conditional Functions
Lookup and Reference Functions
-
Quick Intro (1:44)
-
VLookup - Approx Match (3:59)
-
VLookup - Exact Match (4:27)
-
HLookup Function (4:01)
-
Index and Match Function (4:41)
-
XLookUp - VLookUP + More (8:46)
-
XLookUp - HLookup+Index Match (5:06)
-
XLookUp - Everything Else (7:29)
-
Unique Function (4:11)
-
Filter Function (2:24)
-
Sort and Sort by Function (6:09)
-
Offset Function (12:12)
-
Indirect Function (12:07)
Statistical and Financial Functions
-
Quick Intro (2:06)
-
Count Functions (3:29)
-
Small, Large, Min, Max, and Average Functions (5:49)
-
PV, FV and PMT Functions (5:47)
-
NPER Function (1:31)
-
Monthly Loan Payment (2:02)
-
Loan Payment Schedule (8:56)
-
Loan Payment Schedule - the easy way (4:40)
-
NPV and XNPV Functions (4:31)
-
IRR and XIRR Functions (4:03)
-
MIRR Function (2:49)
Excel 365 Functions
Auditing and Protecting Sheets
Excel 101 - Complete Beginners Start Here
Productivity Features
