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
-