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