Course curriculum

  • 1

    Welcome to the course!

    • A message from your Trainer

    • Download Complete Course Exercises

  • 2

    COMPETENCY 3: BUSINESS MODELING

    • Explaining Business Modeling

  • 3

    Spinner

    • Spinner: Demonstration

    • Spinner: Whole Number

    • Spinner: Whole Number above 30,000 units

    • Spinner: Percentage

    • Spinner: Text

    • Your Turn: Spinner Workshop

  • 4

    Scenario Manager

    • Scenario Manager: Concept Facilitation

    • Scenario Manager: Demonstration

    • Scenario Manager: Demonstration using Pivot Tables

    • Your Turn: Scenario Manager Workshop

  • 5

    Goal Seek

    • Goal Seek: Demonstration

    • Your Turn: Goal Seek Workshop

  • 6

    Data Tables

    • Data Tables: Explaining the Concept

    • Data Tables: Demonstration

    • Your Turn: Data Tables Workshop

  • 7

    List Box Data Model

    • List Box: Explaining the Concept

    • List Box: Demonstration

    • Your Turn: List Box Workshop

  • 8

    Check Box Data Model | IF Statement

    • IF Statement: Explaining the Concept

    • Check Box Data Model: Demonstration

    • Your Turn: Check Box Data Model with IF Statement Workshop

  • 9

    Option Button Data Model

    • Nested IFs Statements

    • Option Button: Demonstration

  • 10

    Next steps

    • Congrats on Finishing Business Modeling! Here's what's next...

  • 11

    COMPETENCY FOUR: DATA INTEGRATION

    • Explaining Data Integration

    • Connecting Excel to .CSV or .TXT Files: Demonstration

    • Connecting Excel a Database: Demonstration

    • Connecting Excel to Web: Demonstration

    • Connecting Excel to Excel: Demonstration

    • Your Turn: Integration Workshops

    • Congrats on Finishing Integration! Here's what's next...

  • 12

    COMPETENCY FIVE: AUTOMATION / MACRO / VBA

    • Explaining Automation

    • Automation Basics: Demonstration

    • Automation Control Board: Demonstration

    • Planning a Macro: Demonstration

    • Recording a Macro: Demonstration

    • Testing a Macro: Demonstration

    • Editing a Macro: Demonstration

    • Your Turn: Macro Workshops

  • 13

    Congratulations!

    • Congrats! You have completed Data Analysis & Business Reporting Using Excel - Level 2

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.