Home └Excel For Professionals : ATOM Myanmar
Excel For Professionals : ATOM Myanmar

Excel For Professionals : ATOM Myanmar

Login to Enroll
Responsible Chaw Hsu Htet
Last Update 09/26/2026
Completion Time 1 day 4 hours 2 minutes
Members 55
  • Introduction
    • Instruction and Disclaimer
  • Excel Shortcuts
    • Excel Shortcut Intro
    • Excel Shortcut Part -1
    • Excel shortcut Part -2
    • Excel Shortcut Practical Instruction Video
  • Formatting and Productivity
    • Text to Columns
    • Absolute and Relative Ranges
    • Fill Series
    • Flash Fills
    • Excel Table Uses
    • Filling Cells Down Function
    • Named Ranges
    • Remove Duplicates
    • Data Validation
    • Page Setup and Printing Documents
  • Pivot Tables
    • Pivot Table Introduction
    • Normalized Data Table Setup
    • Basic Pivot Table Setup
    • Slicers, Timelines, and Report Connections
    • Slicer Formatting and Dashboard Layout
    • Pivot Charts and Basic Chart Formatting
    • Pivot Options, Summarize, and Show Values
    • Pivot Design Ribbon Overview
    • Pivot Layers, Advanced Sorts and Filters
    • Conditional Formatting in Reporting
    • Sparklines in Reporting
    • Pivot Summary
  • Functions and Formulas
    • Maximum + Minimum + Average
    • Large + Small + Count + Index Part- 1
    • Large + Small + Count + Index Part -2
    • Left,right & join Functions
    • Index Match Functions
    • Vlookup Function
    • Index Match Lookup Review
    • Sumif,Sumif Functions
    • Large , Small Functions
    • Combined Formulas Review
    • Combined Formulas Assignment
    • Date Functions Introduction
    • WorkDay Calculation Part -1
    • WorkDay Calculation Part -2
    • Date Dynamic Ranges Part -1
    • Date Dynamic Ranges Part -2
    • Datedif Function
  • Storytelling through Visualization
    • Intro Storytelling Through Visualization
    • What is Visualization
    • Preparing Effective Spreadshreet and Table Visual
    • Do and Don'ts Part - 1
    • Do and Don'ts Part - 2
    • Do and Don'ts Part - 3
    • Do and Don'ts Part - 4
    • Dos & Dont's Summary
    • Understanding Chart Types
    • Excel Chart Ribbon and Chart Components
    • Summary Storytelling Through Visualization
  • Building Basic Charts
    • Building Line Charts
    • Building Bar Charts
    • Building Pie Chart & Stacked Bar Chart
    • Building a Scatter Plot Part -1
    • Building a Scatter Plot Part -2
  • Building other Charts
    • Building a Box & Whisker Chart
    • Building a Tree Map
    • Building a Sunburst Chart
    • Building a Waterfall Chart
    • Building a Funnel Chart
    • Building a Stock Chart
    • Building a Radar Chart
    • Building a Heat Map
    • Building Area Charts and Compare Line Chart
    • Creating Save as Template for Chart Uses
  • Power Query
    • 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
  • Power Pivot
    • 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
  • What-if Analysis Tools
    • 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 Introduction
    • Moving Average
    • Simple Linear Regression Part-1
    • Simple Linear Regression Part -2
    • Multiple Regression
    • Goal Seek Function -
    • Solver Function
  • Zoom Video Record
    • 20260821 Excel For Professionals ATOM Myanmar
    • 20260904 Excel For Professionals ATOM Myanmar
    • 20260910 Excel For Professionals ATOM Myanmar
    • 20260911 Excel For Professionals ATOM Myanmar
    • 20260918 Excel For Professionals ATOM Myanmar
    • 20260925 Excel For Professionals ATOM Myanmar