Responsible Administrator
Last Update 11/30/2025
Completion Time 19 hours 47 minutes
Members 38
  • Instruction
    • Instruction and Disclaimer
  • Support Materials
    • Day 1
    • Day 2
    • Day 3
    • Day 4
    • Day 5
    • Day 6
    • Day 7
    • Day 8
  • Formatting & Productivity
    • Excel Shortcut Part-1
    • Excel Shortcut Part-2
    • Group and Shortcut Part-1
    • Group and Shortcut Part-2
    • Text to columns
    • Excel Exercise
    • Introduction + Formatting Part-1
    • Formatting Part-2
    • Remove Duplicate Function
    • Data Validation
  • Pivot Tables
    • Pivot Table Part-1
    • Pivot Table Part-2
    • Pivot Ribbon
    • Pivot Chart
    • Slicer Timeline
    • Conditional Formatting
    • Spark-line
    • How to Use Format as Table
    • How to Use Page Setup for Printing Purposes
  • Using Date Functions
    • Introduction + Date
    • Workday Part-1
    • Workday Part-2
  • Coffee Shop Setup (Functions - vlookup, index, match, sumif, sumifs)
    • Left & Right
    • Index Match
    • Vlookup
    • Index+Vlookup+Format
    • Sumif+Sumifs+Condition
    • Large + small + index + condition
  • Visualization and Story Telling
    • Excel Story Introduction
    • Data Visualization
    • Dos and Don't of Charts
    • Excel Formatting Ribbons
  • Basic Chart Types
    • Chart Types Part 1
    • Chart Types Part 2
    • Chart Types Part 3
    • Line Charts
    • Bar Chart
    • Pie Chart & Stacked Bar
    • Scatter Part-1
    • Scatter Part-2
    • Pareto Part 1
    • Pareto Part 2
    • Box & Whisker
    • Tree Maps
    • Sunburst
    • Waterfall
    • Funnel Chart
    • Stock Chart
    • Radar Chart
    • Heat Map
  • Advanced Charts (Combo)
    • Charts and Graphs Part-1
    • Charts and Graphs Part-2
    • Charts and Graphs Part 3
    • Target Vs Actual Part 1
    • Target Vs Actual Part 2
    • Breakeven Part 1
    • Breakeven Part 2
    • Dropdown Part 1
    • Dropdown Part 2
  • Advanced Charts (Gauge Charts)
    • Gauge Chart Part 1
    • Gauge Chart Part 2
    • Gauge Chart Part 3
    • Gauge Chart Part 4
    • Gauge Chart Part 5
    • Highlight Ranges
    • Bullet Chart
  • Word
    • Microsoft Word Intro
    • Adding Table of Contents
    • Adding Table of Figures
    • Adding Captions to Figures and Tables
    • Applying Headings to the Document
    • Choosing Navigation Pane
    • Cross Referencing Documents
    • Editing the Heading Styles
    • Inserting Footnotes to the Documents
    • Numbering the Document Headings
  • Zoom Video Record
    • 20251115 Data Analytics with Excel GGI Nippon Life Insurance
    • 20251122 Data Analytics with Excel GGI Nippon Life Insurance
    • 20251127 Data Analysts With Excel GGI Nippon Life Insurance
      New