Excel For Professionals Batch-4

Responsible	Chaw Hsu Htet
Last Update	11/13/2024
Completion Time	14 hours 21 minutes
Members	6

Basic Intermediate

Introduction
- Instruction and Disclaimer
Teaching Materials
- Support Materials
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
Formatting
- 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
- Conditional Formatting
- Spark-line
Functions and 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
Power Point
- 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
- 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
- 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
- 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