Laraonlinetraining
Financial Modeling Ms Excel Online Training
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Enquire Now

Course sections

Section 1
Spreadsheet modelling techniques
1
Basic structure (separation of data from processing & output)
2
Cell referenced formulas (no hard coding of data)
3
Modularisation (break a complex model into simple bits)
4
Prototype development and refinement
5
Sensitivity analysis
6
Troubleshooting and debugging
7
Reasonability testing (common sense)
Section 2
Microsoft Excel functions and methods useful for modeling
1
Named cell ranges
2
Lookup functions
3
Conditional functions (IF, COUNTIF, SUMIF)
4
Financial functions (IRR, NPV)
5
Formula nesting (pros and cons)
6
Autofilters
7
Advanced filters
8
Goal seeking
9
Conditional formatting
10
Navigation buttons
Section 3
Automating your model with macros
1
Pros and cons
2
Setting the macro security level
3
Recording and running simple macros
4
The Visual Basic editor
5
Modifying a recorded macro for general use.
Section 4
Protecting your model from undesired changes
1
Model structure
2
Locking cells
3
Worksheet and workbook protection
4
Password protection
5
Cross checks and error reports
6
Data validation
Section 5
Output presentation (tips for effective reporting of results)
Section 6
The importance of documentation
Section 7
Spreadsheet model multimedia
1
Adding sound to your model
2
Providing video with your model
3
Make your model talk

Microsoft Excel functions and methods useful for modeling

Autofilters

Lesson is locked. Please Buy course to proceed.

Prev lesson
Complete
Next lesson