Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Academy for Financial Professionals
Module 1 - Excel Basics
M1 Lecture 1 Introduction (1:13)
M1 Lecture 2 How is Excel used in Finance (2:24)
M1 Lecture 3 How much Excel should you know (2:14)
M1 Lecture 4 Mac vs. PC when it comes to Excel (2:59)
M1 Lecture 5 Use ready-templates to save time (2:36)
M1 Lecture 6 Navigation bar breakdown (2:47)
M1 Lecture 7 How to name your files and folders (3:08)
M1 Lecture 8 Amazing Shortcuts (4:58)
M1 Lecture 9 How to properly format an Excel Report (4:27)
M1 Lecture 10 Proper Formatting Continued (5:11)
M1 Lecture 11 Text to columns (3:05)
M1 Lecture 12 Create drop down menu (1:36)
M1 Lecture 13 Conditional formatting (3:51)
Module 2 - Data Cleaning & Mass Changes
M2 Introduction & Download Practice File (1:32)
M2 Lecture 1 Data Cleaning (6:06)
M2 Lecture 2 Mass Data Modification (5:48)
M2 Lecture 3 Statistical Functions (5:03)
M2 Lecture 4 Conditional Functions (7:02)
Module 3 - Data Lookup
Lectures Coming Dec 18th, 2023
Module 4 - Pivot and Macros
Lectures Coming Jan 18th, 2024
Module 5 - Using Excel as a Controller or Financial Analyst
Lectures Coming Feb 18th, 2024
M1 Lecture 13 Conditional formatting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock