Myanmar Positive Group : Excel For Professionals

Responsible	Chaw Hsu Htet
Last Update	08/31/2024
Completion Time	18 hours 40 minutes
Members	21

Advanced

Indroduction
- Instruction and Disclaimer
Teaching Materials
- Support Materials
- Pre Test
- Final Assignment
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 Chart
- Pivot Ribbon
- Slicer Timeline
- 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
- Charts and Graphs Part-1
- Charts and Graphs Part-2
- Day 4 (9) Charts and Graphs Part 3
Zoom video Record
- 20240703 Excel For Professionals Myanmar Positive Group
- 20240705 Excel For Professionals Myanmar Positive Group
- 20240717 Excel For Professionals Myanmar Positive Group
- 20240802 Excel For Professionals Myanmar Positive Group
- 20240809 Excel For Professionals Myanmar Positive Group
- 20240816Excel For Professionals Myanmar Positive group
- 20240830 Excel For Professionals Myanmar Positive group
Sumif + Sumifs
- Sumif+Sumifs+Condition
- Large + small + index + condition
- Maximum + Minimum + Average
- Large + Small + Count + Index Part-1
- Large + Small + Count + Index Part-2
- Day 4 part 4 Dynamic Range
Powerpoint
- Excel Essential Powerpoint Introduction
- Excel Essential Pitching Intro
- Excel Essential Powerpoint Layout Overview
- Excel Essential Guidelines, Slide Master, Section Divider
Chart Types
- Chart Types Part 1
- Chart Types Part 2
- Chart Types Part 3
Advanced Charts Week 2
- Box & Whisker
- Tree Maps
- Sunburst
- Waterfall
- Funnel Chart
- Stock Chart
- Radar Chart
- Heat Map
Data Visualization and Charts Best Practices Week 1
- Data Visualization
- Dos and Don't of Charts
- Excel Formatting Ribbons
Basic Chart Making
- Line Charts
- Bar Chart
- Pie Chart & Stacked Bar
- Scatter Part-1
- Scatter Part-2
- Pareto Part 1
- Pareto Part 2
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
- 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
- Numbering the Document Headings
- Embedding and Linking Excel Tables in Microsoft Word