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!
Logical and lookup functions
Prev
Formula auditing
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