Excel For Professionals Batch-1
Responsible | Administrator |
---|---|
Last Update | 12/26/2023 |
Completion Time | 1 day 1 hour 1 minute |
Members | 32 |
Basic, Intermediate
-
Instruction
-
Disclaimer and Ruel & Regulation
-
-
Exam Test
-
Pre-Assessment
-
Post Assessment
-
-
Support Materials
-
Short Cut Key Note
-
-
Week 1
-
Workbook3_Charts (exercise)EE
-
Workbook3_Charts (complete)EE
-
Workbook2_Sales (exercise)
-
Workbook1_DD (exercise)
-
Workbook1_DD (complete)
-
Workbook2_Functions&Formulas (exercise)
-
Workbook2_Functions&Formulas (complete)
-
-
Week 2
-
Workbook6_Personal Finance (exercise)
-
Workbook5_Functions
-
Workbook2_Sales (complete)EE
-
Workbook4_Dates (exercise)EE
-
Workbook4_Dates (complete)EE
-
-
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 and Formulas
-
Functions & Formulas Intro
-
Absolute & Relation Reference
-
-
Date Functions
-
Introduction + Date
-
Workday Part-1
-
Workday Part-2
-
Left & Right
-
-
Index, Match
-
Index Match
-
-
Vlookup
-
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
-
1 Excel Essential Powerpoint Introduction
-
2 Excel Essential Pitching Intro
-
3 Excel Essential Powerpoint Layout Overview
-
4 Excel Essential Guidelines, Slide Master, Section Divider
-
-
Data Visualization and Charts Best Practices Week 1
-
Download Workbook 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
-
-
Video Record
-
20230823 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20230830 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20230906 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20230913 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20230920 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20230927 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20231004 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-
20231011 Excel For Professionals Batch 1 Instructor Min Han Tun, CFA
-