Home └E4P: Productivity, Formatting, and Functions Batch-1
E4P: Productivity, Formatting, and Functions Batch-1

E4P: Productivity, Formatting, and Functions Batch-1

Login to Enroll
Responsible Chaw Hsu Htet
Last Update 04/10/2026
Completion Time 11 hours 42 minutes
Members 2
  • Introduction
    • Instruction and Disclaimer
      New
  • E4P Introduction
    • Introduction Materials
      New
    • E4P Introduction
      New
    • E4P Course Overview
      New
    • Excel Interface and Setup
      New
  • Excel Shortcuts
    • Excel Shortcuts Materials
      New
    • Excel Shortcut Intro
      New
    • Excel Shortcut Part -1
      New
    • Excel shortcut Part - 2
      New
    • Excel Shortcut Practical Instruction Video
      New
  • Formatting and Productivity
    • Formatting and Productivity Materials
      New
    • Text to Columns
      New
    • Absolute and Relative Ranges
      New
    • Fill Series
      New
    • Flash Fills
      New
    • Excel Table Uses
      New
    • Filling Cells Down Function
      New
    • Named Ranges
      New
    • Remove Duplicates
      New
    • Data Validation
      New
    • Page Setup and Printing Documents
      New
  • Pivot Tables
    • Pivot Tables Materials
      New
    • Pivot Table Introduction
      New
    • Normalized Data Table Setup
      New
    • Basic Pivot Table Setup
      New
    • Slicers, Timelines, and Report Connections
      New
    • Slicer Formatting and Dashboard Layout
      New
    • Pivot Charts and Basic Chart Formatting
      New
    • Pivot Options, Summarize, and Show Values
      New
    • Pivot Design Ribbon Overview
      New
    • Pivot Layers, Advanced Sorts and Filters
      New
    • Conditional Formatting in Reporting
      New
    • Sparklines in Reporting
      New
    • Pivot Summary
      New
  • Functions and Formulas
    • Functions and Formulas Materials
      New
    • Maximum + Minimum + Average
      New
    • Large + Small + Count + Index Part-1
      New
    • Large + Small + Count + Index Part -2
      New
    • Left,right & join Functions
      New
    • Index Match Functions
      New
    • Vlookup Function
      New
    • Index Match Lookup Review
      New
    • Sumif,Sumif Functions
      New
    • Large , Small Functions
      New
    • Combined Formulas Review
      New
    • Combined Formulas Assignment
      New
    • Date Functions Introduction
      New
    • WorkDay Calculation Part -1
      New
    • WorkDay Calculation Part -2
      New
    • Date Dynamic Range part -1
      New
    • Date Dynamic Ranges Part - 2
      New
    • Datedif Function
      New
  • Storytelling through Visualization
    • Storytelling through Visualization Materials
      New
    • Intro Storytelling Through Visualization
      New
    • What is Visualization
      New
    • Preparing Effective Spreadshreet and Table Visual
      New
    • Do and Don'ts Part - 1
      New
    • Do and Don'ts Part - 2
      New
    • Do and Don'ts Part - 3
      New
    • Do and Don'ts Part - 4
      New
    • Dos & Dont's Summary
      New
    • Understanding Chart Types
      New
    • Excel Chart Ribbon and Chart Components
      New
    • Summary Storytelling Through Visualization
      New
  • Building Basic Charts
    • Building Basic Charts Materials
      New
    • Building Line Charts
      New
    • Building Bar Charts
      New
    • Building Pie Chart & Stacked Bar Chart
      New
    • Building a Scatter Plot Part - 1
      New
    • Building a Scatter Plot Part - 2
      New
  • Building other Charts
    • Building other Charts Materials
      New
    • Building a Box & Whisker Chart
      New
    • Building a Tree Map
      New
    • Building a Sunburst Chart
      New
    • Building a Waterfall Chart
      New
    • Building a Funnel Chart
      New
    • Building a Stock Chart
      New
    • Building a Radar Chart
      New
    • Building a Heat Map
      New
    • Building Area Charts and Compare Line Chart
      New
    • Creating Save as Template for Chart Uses
      New