6:14
1.1 Meet The Instructor And A Brief Introduction of Microsoft Excel
Excel Analytics (EPH Lab)
3:07
1.2 Explore Training Resource Part 1
7:26
1.2 Explore Training Resource Part 2
1:51
1.2 Explore Training Resource Part 3
6:17
1.3 What is Excel and its Features
3:37
1.4 How Excel Aid in Data Processing and its Relevance in Modern Workplace
2:41
1.5 Features of Excel
1:47
1.6 Excel UI Brief Overview
2:01
1.7 Microsoft Excel Formulas And Functions
2:24
1.8 Pros & Cons of using Excel
1:35
1.9 Conclusion & Learning Resource
6:04
1.10 Different ways of Opening Excel
3:51
1.11 Microsoft Excel Data Entry
3:59
1.12 Microsoft Excel Data Analyst's Tool
3:00
1.13 Microsoft Excel Data Visualization
1:58
1.14 Conclusion
14:04
1.15 Methods Of Saving Excel File
4:48
1.16 Creating New Workbook In Excel
7:14
2.1 Data Organization & Structuring
2.2 Data Analysis & Insights
2:35
2.3 Reporting & Collaboration
0:53
3.1 Excel Hierarchy Unleashed Part 1
3.2 Excel Hierarchy Unleashed Part 2
4:32
3.3 Excel Hierarchy Unleashed Part 3
4:57
3.4 Excel Hierarchy Unleashed Part 4
6:02
3.5 Excel Hierarchy Unleashed Part 5
7:04
3.6 Add, Rename, Move, Copy, Delete Worksheets
4:00
3.7 Group-Ungroup Sheets In Excel
3:43
3.8 Hide/Unhide Worksheets in Excel
3:25
3.9 Change Sheet Tab Color In Excel
1:44
3.10 Conclusion
10:17
4.1 Introduction To Microsoft Excel User Interface
8:11
4.2 Tittle Bar
7:27
4.3 Quick Access Toolbar
13:11
4.4 Introduction to Ribbon Bar In Excel
10:32
4.5 Introduction To Excel User interface File Tab
6:30
4.6 Introduction to Excel Formula Bar
7:25
Introduction to Excel Column-Row Headers Interface
11:52
4.10 Introduction to Excel Sheets Tab
10:40
4.11 How to Move or Copy Worksheets in Excel
11:24
4.1 Workbook & Worksheet Protection Part 1
8:52
4.2 Workbook & Worksheet Protection Part 1
6:41
4.3 Workbook & Worksheet Protection Part 2
12:18
4.4 Workbook & Worksheet Protection Part 3
6:36
4.5 Workbook & Worksheet Unprotection Part 4
7:18
6.1 Introduction to Excel Operators
7:44
6.2 Types of Operator in Excel Part 1
13:57
6.3 Types of Operator in Excel Part 2
12:26
6.4 Operators in Excel Practical Applications Part 1
24:41
6.5 Operators in Excel Practical Application Part 2
18:39
6.6 Operators in Excel Practical Application Part 3
16:07
6.7 Operator Precedence
20:53
6.8 Operators Assignment Solution
7.1 Excel Referencing Techniques
8:18
7.2 Importance of Excel Referencing Techniques in Excel
6:31
7.3 Introduction to Chapter Contents & Objectives
10:44
7.4 Relative cell referencing
10:43
7.5 Absolute, Row & Column Absolute Referencing
6:56
7.6 Mixed Cell Referencing
3:35
7.7 Referencing a Range
7:03
7.8 Referencing Named Range
6:06
7.9 Worksheet Referencing
8:51
7.10 Workbook Referencing And Workbook Links
14:58
8.1 Introduction To Excel Data Types Theory
4:23
8.2 Numeric Data Type Theory
5:30
8.3 Text Data Type Theory
8.4 Logical Data Type Theory
3:06
8.5 Error Data Type Theory
3:48
8.6 Date Data Type Theory
5:18
8.7 Data Type Conversion Theory
16:11
8.8 Learn About Data Type in Excel Part 1
12:09
8.9 Learn About Data Type in Excel Part 2
6:12
8.10 How To Convert Data Type
7:06
8.11 Assignment on Data Types in Excel
29:53
9.1 Errors and Types in Excel Part 1 Theory
16:50
9.2 Introduction To Error Handling In Excel
3:44
9.3 Circular Reference
