Excel For Professionals Batch-2

Responsible	Administrator
Last Update	05/15/2024
Completion Time	22 hours 47 minutes
Members	25

Basic, Intermediate

Introduction
- Instruction and Disclaimer
Teaching Materials
- Short Cut Key Note
Productivity
- Excel Essential Intro+ Excel interface, sheet, options setup
- Excel Shortcut Part-1
- Excel Shortcut Part-2
- Group and Shortcut Part-1
- Group and Shortcut Part-2
- Text to columns
- Excel Exercise
Formatting
- Introduction + Formatting Part-1
- Formatting Part-2
- Remove Duplicate Function
- Data Validation
Pivot Table
- Pivot Table Part-1
- Pivot Table Part-2
- Pivot Ribbon
- Pivot Chart
- Slicer Timeline
Conditional Formatting
- Conditional Formatting
- Spark-line
Functions & Formulas
- Functions & Formulas Intro
- Absolute & Relation Reference
Date Functions
- Introduction + Date
- Workday Part-1
- Workday Part-2
- Left & Right
Index, Match
- Index Match
Vlook up
- Vlookup
- Index+Vlookup+Format
sumif + sumifs
- Sumif+Sumifs+Condition
- Large + small + index + condition
- Maximum + Minimum + Average
- Large + Small + Count + Index Part-1
- Large + Small + Count + Index Part-2
- Dynamic Range
Powerpoint
- Excel Essential Powerpoint Introduction
- Excel Essential Pitching Intro
- Excel Essential Powerpoint Layout Overview
- Excel Essential Guidelines, Slide Master, Section Divider
Data Visualization and Charts Best Practices Week 1
- Download Work Files
- Data Visualization
- Dos and Don't of Charts
- Excel Formatting Ribbons
Chart Types
- Chart Types Part 1
- Chart Types Part 2
- Chart Types Part 3
Basic Chart Making
- Line Charts
- Bar Chart
- Pie Chart & Stacked Bar
- Scatter Part-1
- Scatter Part-2
- Pareto Part 1
- Pareto Part 2
Advanced Charts Week 2
- Download Workbook Files
- Box & Whisker
- Tree Maps
- Sunburst
- Waterfall
- Funnel Chart
- Stock Chart
- Radar Chart
- Heat Map
Case Study 1: Finance Charts and Graphs
- Charts and Graphs Part-1
- Charts and Graphs Part-2
- Charts and Graphs Part 3
Case Study 2: Stacked Columns Targets
- Download Workbook Files
- Target Vs Actual Part 1
- Target Vs Actual Part 2
- Finance For Non Finance Valuation 4
- Finance for Non Finance valuation 5
- Finance for Non Finance valuation 6
- Finance for Non Finance valuation 7
- Finance for Non Finance valuation 8
- Finance for Non Finance valuation 9
Case Study 3: Breakeven (Line & Scatter)
- Breakeven Part 1
- Breakeven Part 2
Case Study 4: Dropdown Boxes and Charts
- Dropdown Part 1
- Dropdown Part 2
Case Study 5: Gauge Charts
- Gauge Chart Part 1
- Gauge Chart Part 2
- Gauge Chart Part 3
- Gauge Chart Part 4
- Gauge Chart Part 5
Bullet Charts
- Bullet Chart
- Highlight Ranges
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 records
- 20240123 Excel For Professionals Batch 2
- 20240130 Excel for Professionals Batch 2, Instructor U Min Han Tun
- 20240206 Excel for Professionals Batch-2, Instructor U Min Han Tun
- 20240213 Excel for Professional Batch-2, Instructor U Min Han Tun
- 20240305 Excel for Professional Batch-2, Instructor U Min Han Tun
- 20240312 Excel for Professional Batch-2, Instructor U Min Han Tun