Data Analytics With Excel Batch-1

Introduction
- Instruction and Disclaimer
Assignment
- Pre Assessment
Suport Materials
- Day 1 : Materials
- Shortcut Key
- Excel Data Analytics Syllabus Batch 1
Visualization
- Target Vs Actual Part 1
- Target Vs Actual Part 2
- Breakeven Part 1
- Breakeven Part 2
- Dropdown Part 1
- Dropdown Part 2
- Pareto Part 1
- Pareto Part 2
- Workbook4_Combined Charts Visualization
Formatting Practices
- Introduction + Formatting Part-1
- Formatting Part-2
- Remove Duplicate Function
- Data Validation
- Pivot Table Part-1
- Pivot Table Part-2
- Pivot Ribbon
- Pivot Chart
- Slicer Timeline
- Conditional Formatting
- Spark-line
- Index Match
- Vlookup
- Index+Vlookup+Format
- Workbook1_Sales
Introduction to Variables
- Advanced Excel and Analytics Introduction to Variables
- Workbook For Advanced Excel
- Advanced Excel P1 1
- Advanced Excel P1 2
- Advanced Excel P1 3
- Advanced Excel P1 4
- Advanced Excel P1 5
- Advanced Excel P1 6
- Advanced Excel P1 7
- Advanced Excel P1 8
- Advanced Excel P1 9
- Data Table Case with Conditional Formatting
- Data Table Case
- Goal Seek Function
- One Variable Data Table
- Two Variable Data Table
Introduction to PowerBi
- PowerBi Case
- Dashboard_Check2023219
Zoom Video Record
- 20230129 Data Analyst with Excel Min Han Tun
- 20230205 Data Analyst With Excel Min Han Tun
- 20230212 Data Analytics with Excel Day 2
- 20230219 Data Analyst With Excel Min Han Tun