arrow_back
Module 1
Module1_Intro ppt
Module1_Revision_Guide
1.1 Setting Expectations_ Introduction to the Course
1.2 what is financial modelling
1.3 How model works
1.4_ same Machine, different questions
1.5_ Heart of model - 3 statements
1.6 _ Your Toolkit - Excel, VBA, AI
1.7_ Modeller_s Mindset
Module 2.0 Excel Intro & Setting Expectations
Module 2.0_ excel intro and setting expectations
Module 2.1 Excel Basics (Referencing, copy paste, formula, calculation across sheets)
2.1 Excel core basics
2.1 Excel Core basic Skills Cheatsheet.docx
2.1 Excel interface + how to save
2.2 Cell address, cell value,undo,redo
2.3 adjusting width, selecting multiple columns
2.4 Cell formatting basics
2.5 Basics of formula
2.6 Bodmas
2.7 Fill Handle
2.8 Fill handle & calculation in action
2.9 sum,max,min,average functions
2.10 Cell reference(relative,absolute,mixed)
2.11 Cell Reference+fill handle in action
2.12 copy,paste,paste special,cut
2.13 Copy paste part 2
2.14 CALCULATION ACROSS SHEETS
Module 2.2 Datatypes & Formatting (V.IMP)
2.2 datatypes and formatting
2.2 data types and formatting Cheat sheet_
2.21 why are datatypes and formatting are needed
2.22 Lets talk Datatypes
2.23 Number formatting 1
2.24 Number formatting 2
2.25 Dates 1
2.26 dates 2
2.27 Time
2.28 Custom Format 1
2.29 Custom Format 2
2.210 Merge,Wrap text,Borders,alignment,Shrink to fit