Course curriculum

  • 1

    Welcome to the course!

  • 2

    COMPETENCY 1: MASSAGING DATA

  • 3

    Consolidation

  • 4

    Data Validation

    • Data Validation: What is Data Validation

    • Download Data Validation Workshop(s)

    • Data Validation: Demonstration - Whole Number

    • Data Validation: Demonstration - List

    • Data Validation: Demonstration - Date

    • Data Validation: Demonstration - Text Length

    • Data Validation: Demonstration - Custom

  • 5

    Table Tools - Ctrl T

    • Download Ctrl T Workshop(s)

    • Ctrl T (Table Design): Demonstration of Functionality

    • Ctrl T (Table Design): Demonstration of Technical Part 1

    • Ctrl T (Table Design): Demonstration of Technical Part 2

  • 6

    Naming Cells & Ranges

    • Download Naming Cells & Ranges Workshop(s)

    • Naming Cells & Ranges: Demonstration

  • 7

    Surgeon Functions

    • Download Surgeon Functions Workshop(s)

    • Surgeon Functions: Explaining the Concept

  • 8

    Date Analysis

    • Download Date Functions Workshop(s)

    • Date Functions: Demonstration

  • 9

    Vlookup

    • Download VLookup Workshop(s)

    • Vlookup: Date Demonstration

    • Vlookup: Bank Account Demonstration

    • Vlookup: Corporate Sales Demonstration

  • 10

    Select, Shift, Select

    • Download Select-Shift-Select Workshop(s)

    • Select Shift Select: Explaining the Concept

  • 11

    Subtotal

    • Download Subtotal Workshop(s)

    • Subtotal: Explaining the Concept

  • 12

    Text Change Functions

    • Download Text Change Case Workshop(s)

    • Text Change Functions: Explaining the Concept

  • 13

    Text-To-Columns

    • Download Text-To-Columns Workshop(s)

    • Text-To-Columns: Explaining the Concept

  • 14

    Conditional Formatting

    • Download Conditional Formatting Workshop(s)

    • Conditional Formatting: Explaining the Concept

  • 15

    What is Next!

    • Congratulation: Completing Data Massaging

  • 16

    COMPETENCY 2: REPORTING, ANALYSIS, & DASHBOARDING

    • Explaining: Reporting, Analysis, & Dashboarding

      FREE PREVIEW
    • The 19 Rules of Pivot Tables

      FREE PREVIEW
    • Download Pivot Table Rules 1 -12

    • Rule 1: Creating Pivot Tables

      FREE PREVIEW
    • Rule 2: Number Formatting

    • Rule 3: Design Report Layout

    • Rule 4: Sorting in Pivot Tables

    • Rule 5: Filtering in Pivot Tables

    • Rule 6: Drill-down in Pivot Tables

    • Rule 7: Data Analysis Type 1 - Summarize Value by

    • Rule 8: Data Analysis Type 2 - Show Values As

    • Rule 9: Data Analysis Type 3 - Inserting Formulas

    • Rule 10: Date Analysis & Grouping

    • Rule 11: Show Report Filter Pages

    • Rule 12: Copying Pivot Tables

    • Review Workshop - Pivot Tables 1

    • Rule 13: Pivot Charts

    • Rule 14: Dynamic Chart Labeling

    • Rule 15: Linking Pivot Tables with Power Points

    • Rule 16: Pivot Table Options

    • Rule 17: Conditional Formatting in Pivot Tables

    • Rule 18: GetPivotData

    • Rule 19: The Magical Slicer

    • Review Workshop - Pivot Tables 2

    • Rule Dashboard: Creating an Excel-Based Dashboard

    • Congratulations: Completing Pivot Reporting, Analysis, and Dashboards

Course Fees

Instructor(s)

Aiman Sadeq

Managing Director | Virginia

Aiman is a Finance, Investment, and Analytics Consultant. A CPA, CFE, and a CFA level 1, and a Microsoft Certified Specialist. Aiman delivers Training and Consulting in | Financial Management | Financial Modeling | Financial Analysis | Investment | Portfolio Management | Equity Valuation | Data Analytics | Excel | PowerQuery | PowerPivot | Power BI