Skip to content
+255 713 298 054 | +255 746 881 216 | support@learnmark.org
Home
About
Courses
Log In
Register
Menu
Home
About
Courses
Log In
Register
Contact
Home
All Trainings
Credit Management
Advanced MS Excel for Business Modelling
Curriculum
4 Sections
15 Lessons
7 Hours
Expand all sections
Collapse all sections
Advanced Formulas
4
1.1
Logical and lookup functions
1.2
Named ranges and data validation
1.3
Formula auditing
1.4
Text, date and array functions
Data Analysis Tools
4
2.1
PivotTables and PivotCharts
2.2
Power Query basics
2.3
What-if analysis and Goal Seek
2.4
Solver for optimisation
Macros and Automation
4
3.1
Recording macros
3.2
Editing macros in the VBA editor
3.3
Automating repetitive reports
3.4
Securing and sharing macro files
Dashboards and Visualisation
3
4.1
Final business modelling exercise
4.2
Interactive dashboards with slicers
4.3
Building a finance dashboard
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content