Corporate Training For AYA Sompo B-2 : Excel For Professionals

Responsible	Administrator
Last Update	11/20/2022
Completion Time	1 day 4 hours 26 minutes
Members	30

INTRODUCTION
- Excel Essential Intro+ Excel interface, sheet, options setup
- Class Instruction
- Excel Notes
Assessment
- Pre Course Assessment
- Final Assignment
Support Materials
- Short Cut Key
- Function Formatting and Formula Work Book 1
- Sale Book Workbook 2
- Index Match Workbook 3
- Date Workbook 4
- Workbook 5
Theory Video Lesson Function Formatting
- Excel Shortcut Part-1
- Excel Shortcut Part-2
- Group and Shortcut Part-1
- Group and Shortcut Part-2
- Text to columns
- Excel Exercise
- Introduction + Formatting Part-1
- Formatting Part-2
- Remove Duplicate Function
- Data Validation
- Pivot Table Part-1
- Pivot Table Part-2
- Pivot Ribbon
- Pivot Chart
- Slicer Timeline
- Conditional Formatting
- Spark-line
- Introduction + Date
- Workday Part-1
- Workday Part-2
- Left & Right
- Index Match
- Vlookup
- Index+Vlookup+Format
- Sumif+Sumifs+Condition
- Large + small + index + condition
Theory Video Lesson Excel Visualization
- 1 Excel Story Introduction
- 2 Data Visualization
- 3 Dos and Don't of Charts
- 4 Excel Formatting Ribbons
- 5 Chart Types Part 1
- 6 Chart Types Part 2
- 7 Chart Types Part 3
- Line Charts
- Bar Chart
- Pie Chart & Stacked Bar
- Scatter Part-1
- Scatter Part-2
- Pareto Part 1
- Pareto Part 2
- Box & Whisker
- Tree Maps
- Sunburst
- Waterfall
- Funnel Chart
- Stock Chart
- Radar Chart
- Heat Map
- Charts and Graphs Part-1
- Charts and Graphs Part-2
- Charts and Graphs Part 3
- Target Vs Actual Part 1
- Target Vs Actual Part 2
- Breakeven Part 1
- Breakeven Part 2
- Dropdown Part 1
- Dropdown Part 2
- Gauge Chart Part 1
- Gauge Chart Part 2
- Gauge Chart Part 3
- Gauge Chart Part 4
- Gauge Chart Part 5
- Bullet Chart
- Highlight Ranges
- 1 How to Use Page Setup for Printing Purposes
- 2 How to Use Format as Table
Word
- Microsoft Word Intro
- Adding Captions to Figures and Tables
- Adding Table of Contents
- Adding Table of Figures
- 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
- 20221008 Excel For Professionals Training AYA Sompo Batch 2
- 20221009 Excel For Professionals Training AYA Sompo Batch 2
- 20221015 Excel For Professionals Training AYA Sompo Batch 2
- 20221016 Excel For Professionals Training AYA Sompo Batch 2
- 20221022 Excel For Professionals Training AYA Sompo Batch 2
- 20221023 Excel For Professionals Training AYA Sompo Batch 2
- 20221112 Excel For Professionals Training AYA Sompo Batch 2
- 20221113 Excel For Professionals Training AYA Sompo Batch 2