![](/website_slides/static/src/img/channel-training-default.jpg)
Corporate Training For AYA Sompo B-3 : Excel For Professionals
Responsible | Administrator |
---|---|
Last Update | 11/20/2022 |
Completion Time | 1 day 4 hours 10 minutes |
Members | 31 |
-
INTRODUCTION
-
Excel Essential Intro+ Excel interface, sheet, options setup
-
Class Instruction
-
Excel Notes
-
-
Assignment
-
Pre Course Assessment
-
Final Assignment
-
-
Support Materials
-
Short Cut Key
-
Function and Formatting Formula Workbook 1
-
Sale Book Work Book 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 3
-
20221009 Excel For Professionals Training AYA Sompo Batch 3
-
20221015 Excel For Professionals Training AYA Sompo Batch 3
-
20221016 Excel For Professionals Training AYA Sompo Batch 3
-
20221023 Excel For Professionals Training AYA Sompo Batch 3
-
20221024 Excel For Professionals Training AYA Sompo Batch 3
-
20221112 Excel For Professionals Training AYA Sompo Batch 3
-
20221113 Excel For Professionals Training AYA Sompo Batch 3
-