Skip to content
  • +255 713 298 054 | +255 746 881 216 | support@learnmark.org
LM_Logo2-White
  • 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 sectionsCollapse 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!
Editing macros in the VBA editor
Prev
Securing and sharing macro files
Next
Courses
  • Leadership
  • Management
  • Finance
  • Investment
  • Technology
Trainings
  • Case studies
  • Workshops & Coaching
  • eLearning Webinars
  • On-job Training
  • Interactive & Hybrid
Website
  • Home
  • About Us
  • Courses
  • Contact
  • Register

Newsletter

Sign up to our newsletter to get relevant updates, information, news and free insight.
Copyright© 2023 Learnmark, All rights reserved. Powered by Imarasoft
Facebook-f Instagram Twitter Youtube

Modal title

Main Content