Corporate Training For AYA Sompo B-1 : Excel For Professionals
Responsible | Administrator |
---|---|
Last Update | 10/31/2022 |
Completion Time | 1 day 6 hours 25 minutes |
Members | 30 |
-
INTRODUCTION
-
Excel Essential Intro+ Excel interface, sheet, options setup
-
Class Instruction
-
Excel Notes
-
-
Assignment
-
Pre Course Assesment
-
Final Assessment
-
-
Support Materials
-
Excel Shortcuts
-
Function Formatting Workbook
-
Sale Workbook
-
Workbook 3
-
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
-
-
Video Record
-
20220904 Excel For Professionals Training AYA Sompo Batch 1
-
20220910 Excel For Professionals Training AYA Sompo Batch 1
-
20220911 Excel For Professionals Training AYA Sompo Batch 1
-
20220917 Excel For Professionals Training AYA Sompo Batch 1
-
20220918 Excel For Professionals Training AYA Sompo Batch 1
-
20220924 Excel For Professionals Training AYA Sompo Batch 1
-
20220925 Excel For Professionals Training AYA Sompo Batch 1
-
20221001 Excel For Professionals Training AYA Sompo Batch 1
-
20221002 Excel For Professionals Training AYA Sompo Batch 1
-
-
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
-