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
  • E4P Introduction
    • Introduction Materials
    • E4P Introduction
    • E4P Course Overview
    • Excel Interface and Setup
  • Excel Shortcuts
    • Excel Shortcuts Materials
    • Excel Shortcut Intro
    • Excel Shortcut Part -1
    • Excel shortcut Part - 2
    • Excel Shortcut Practical Instruction Video
  • Formatting and Productivity
    • Formatting and Productivity Materials
    • 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 Tables Materials
    • 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
    • Functions and Formulas Materials
    • 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 Range part -1
    • Date Dynamic Ranges Part - 2
    • Datedif Function
  • Storytelling through Visualization
    • Storytelling through Visualization Materials
    • 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 Basic Charts Materials
    • 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 other Charts Materials
    • 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