Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Mastery - Essential Excel to Maximise Performance
Introduction
Introduction
Excel Mastery
Overview (8:14)
Using the keyboard (6:00)
Excel settings (5:09)
Basic excel shortcuts & navigations (10:38)
Basic formatting (5:57)
Referencing cells in worksheet (6:24)
Referencing cells in workbook (1:13)
Freezing & Splitting Pans (5:32)
Editing Cells (3:27)
Inserting Rows & Columns (7:51)
Paste Special (7:04)
Essential Control Shortcuts (2:05)
Cell Name (4:32)
Anchoring Cells (5:48)
Worksheet (0:43)
Grouping (4:37)
Auditing Cells (4:15)
Center Alignment (2:54)
Go To Special (1:45)
Finance Function
IF Excel function (4:42)
SUMIF (4:15)
COUNTIF (4:39)
Vlookup (7:30)
IfERROR (2:56)
RANK (2:26)
Sensitivity Analysis (4:59)
NPV (5:57)
IRR (2:33)
COUNTIF
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock