Home └Excel for Analysts: Advanced Tools and Data Modeling Batch-1
Excel for Analysts: Advanced Tools and Data Modeling Batch-1

Excel for Analysts: Advanced Tools and Data Modeling Batch-1

Login to Enroll
Responsible Chaw Hsu Htet
Last Update 04/10/2026
Completion Time 11 hours 12 minutes
Members 1
  • Introduction
    • Instruction and Disclaimer
      New
  • Introduction
    • Advanced Excel for Analytics Introduction
      New
  • Power Query
    • Power Query Materials
      New
    • Power Query Introduction
      New
    • Power Query Editor Overview
      New
    • Unpivoting and Basic Transformation
      New
    • Importing Unknown No of Columns
      New
    • Filtering Non Dates Using Parse and Connection
      New
    • Pivot Grouped Headers and Duplicate Columns
      New
    • Organizing Folder, Removing Ghost Columns, Refe
      New
    • Splitting Columns Using Delimiters, No of Characters
      New
    • Intro to M Code and Create Comments
      New
    • Aggregating and Group By
      New
    • Merging Queries and Left Outer Join
      New
    • Appending Queries From a Folder
      New
    • Tracking Basic Errors and Fixing
      New
    • Using Date Locale
      New
    • Solving Error Using Conditional Column
      New
    • Using Parameter to Solve File Location Error
      New
  • Power Pivot
    • Power Pivot Materials
      New
    • Power Pivot Introduction
      New
    • Power Pivot Setup
      New
    • Building a Regular Pivot Table
      New
    • Building a Basic Data Model Power Pivot
      New
    • Calculating Basic Measures in Power Pivot
      New
    • Power Pivot Analysis for Basic Data Model
      New
    • Power Pivot Case Study Introduction
      New
    • Adding Data to Data Model
      New
    • Creating Relationships in Tables
      New
    • Basic Measures Units, MarginAmt, SumX
      New
    • Date Time Dimesion and Sorting
      New
    • Pivot Slicer and Timeline Connections
      New
    • Adding PDF File to Data Model
      New
    • DAX Daily Sales Proportion of Selected Periods
      New
    • DAX Sales Performance Same Period Last Year
      New
    • DAX Margin Performance Same Period Last Year
      New
    • DAX Contribution to Total Sales
      New
    • DAX Promotion Value to Total Sales
      New
    • DAX SalesDay, YTD Calculation
      New
    • Creating and Editing KPIs in Power Pivot
      New
    • Power Pivot Case Study Summary
      New
  • Functions and Formulas
    • Functions and Formulas Materials
      New
    • Nested If Case Introduction
      New
    • If, Min, Max Formulas
      New
    • Auditing Formulas
      New
    • Counter Model Building to Check
      New
  • What-if Analysis Tools
    • What-if Analysis Tools Materials
      New
    • One Variable Data Table
      New
    • Two Variable Data Table
      New
    • Data Table Case
      New
    • Data Table Case with Conditional Formatting
      New
    • Goal Seek Function
      New
  • Forecasting and Statistics Functions
    • Forecasting and Statistics Functions Materials
      New
    • Forecasting Introduction
      New
    • Moving Average
      New
    • Simple Linear Regression Part - 1
      New
    • Simple Linear Regression Part - 2
      New
    • Multiple Regression
      New
    • Goal Seek Function -
      New
    • Solver Function
      New
  • Developer Tools
    • Developer Tools Materials
      New
    • Workbook1 Introduction to Macro and VB Editors
      New
    • Workbook1 Explanation
      New
    • Macro Absolute vs Relative Reference
      New
    • Recording and Running Macro
      New
    • Creating Button for Macro
      New
    • Commenting In VB Editor
      New
    • Saving File In Xlsm Format
      New
    • Project User Form Introduction
      New
    • UserForm Control Design Creation
      New
    • Naming the Form Control and Properties
      New
    • Adding Codes to the UserForm Part - 1
      New
    • Adding Codes to The UserForm Part - 2
      New
    • Looping The Worksheets
      New
    • Adding Codes to the UserForm Part - 3
      New
    • Adding Button to The Userform Entry
      New
    • Project UserForm Conclusion
      New
  • Building Combo Charts
    • Building Combo Charts Materials
      New
    • Building a Formatted Combo Chart Part - 1
      New
    • Building a Formatted Combo Chart Part - 2
      New
    • Building Target Vs Actual Stacked Column Part - 1
      New
    • Building Target Vs Actual Stacked Column Part - 2
      New
    • Building a Pareto Chart Part - 1
      New
    • Building a Pareto Chart Part - 2
      New
    • Building Breakeven Scatter and Line Part -1
      New
    • Building Breakeven Scatter and Line Part -2
      New
    • Building Dropdown List Part -1
      New
    • Building Dropdown List Part -2
      New
  • Building Advanced Charts
    • Building Advanced Charts Materials
      New
    • Gauge Chart Part - 1
      New
    • Gauge Chart Part - 2
      New
    • Gauge Chart Part - 3
      New
    • Gauge Chart Part - 4
      New
    • Gauge Chart Part - 5
      New
    • Building Bullet Charts
      New
    • Building Highlight Ranges
      New