Excel For Professionals Batch-3

Last Update	08/16/2024
Completion Time	17 hours 32 minutes
Members	27

Intermediate Beginner

Introduction
- Instruction and Disclaimer
Teaching Materials
- Short Cut Key Note
- Materials : Excel Exercise
- Materials : PowerPoint
- Materials: PowerPoint and Word
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
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 Word 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
- Embedding and Linking Excel Tables in Microsoft Word
Zoom Video Records
- 20240611 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240618 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240625 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240702 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240716 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240723 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240730 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA
- 20240806 Excel for Professional Batch - 3, Instructor Min Han Tun, CFA