3:51
1.1 Meet the Instructor and Introduction to 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
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
7:27
4.3 Quick Access Toolbar
10:17
4.1 Introduction To Microsoft Excel User Interface
8:11
4.2 Tittle Bar
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
3:35
7.7 Referencing a Range
6:56
7.6 Mixed Cell Referencing
7:03
7.8 Referencing Named Range
6:06
7.9 Worksheet Referencing
10:43
7.5 Absolute, Row & Column Absolute Referencing
8:51
7.10 Workbook Referencing And Workbook Links
14:58
8.1 Introduction To Excel Data Types Theory
5:30
8.3 Text Data Type Theory
4:23
8.2 Numeric Data Type Theory
6:14
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
34:43
9.4 Error Handling In Excel
9.5 Errors Handling in Excel Assignment
25:30
10.1 Mastering Excel Name Manager
29:36
10.2 Named Range In Microsoft Excel
18:44
10.3 Named Range and its applications
8:08
10.4 Named Range Assignment
6:33
11.1 Remove Duplicate Entries
26:11
11.2 Remove Duplicates Records
5:22
11.3 Remove Duplicates Assignment
13:30
12.1 Introduction to Sorting Data in Microsoft Excel
12.2 Sorting Data Practical Applications
2:03
12.3 Navigating the Extreme points of the selection
16:14
12.4 Advanced Sorting In Excel
12.5 Custom Sorting in Excel
12.6 Sorting Data Assignment
17:25
13.1 Paste Special In Microsoft Excel Theory
17:03
13.2 Paste Special In Excel Exercise File
23:19
14.1 Effective Data Validation
17:02
14.2 Effective Data Validation In Excel
23:48
14.3 Data Validation in Excel Exercise File
11:31
14.4 Data Validation in Excel Exercise File
26:19
15.1 Number Format Dialog Box in Excel
13:04
16.1 Introduction to Excel Formulas and Function
15:42
16.2 Introduction to Excel Formulas and Function
7:20
16.3 Introduction to Excel Formulas and Function
22:46
16.4 Starting With Basic Formulas
13:36
17.1 Mastering Rounding Functions ROUND
14:37
17.2 Understanding Various ROUNDUP & ROUNDDOWN Functions
21:27
18.1 COUNTIF Function
30:30
18.2 COUNTIFS Function
22:24
18.3 SUMIF Function
18.4 SUMIFS Function
11:30
18.5 Averageif Function
8:03
18.6 Averageifs Function
3:57
19.1 Basic Logical Function True-False
6:45
19.2 IS and Error Testing Functions
9:43
19.3 The AND function in Excel
7:07
19.4 The OR function in Excel
19.5 The NOT function in Excel
7:41
19.6 IF Function
12:15
19.7 Nested IF Function
6:47
19.8 IFS FUNCTION
19.9 Error Handling Functions IFNA
5:48
19.10 FINAL EXCERCISE
20:26
20.1 Text Functions in Excel
4:17
20.2 T Function
4:03
20.3 VALUE Function
3:52
20.4 LEN Function
4:04
20.5 TRIM Function
2:32
20.6 CLEAN Function
3:23
20.6 REPT Function
6:09
20.7 String Case Manipulation
8:00
20.8 Text Function in Excel
5:23
20.9 Exact Function
9:04
20.10 Replace Function
4:50
20.11 Function Substitute
11:36
20.12 Find Function in Excel
7:08
20.13 Search Function in Excel
5:58
20.14 Left Function in Excel
20.15 Right Function in Excel
6:58
20.16 Mid Function in Excel
3:16
21.1 Min Function
3:12
21.2 Max Function
4:44
21.3 Rank Function
21.4 Small Function
4:24
21.5 Large Function
3:29
22.1 Reference Functions Row
22.2 Reference Functions Column
5:06
22.3 Reference Functions Columns
10:30
22.4 Reference Functions INDIRECT
9:32
22.5 Reference Functions OFFSET
22.6 Reference Functions Choose
10:23
23.1 Mastering Date Time Functions PART 1
4:09
23.2 Mastering Date Time Functions PART 2
3:24
23.3 Advanced Date Functions Date
4:13
23.4 Advanced Date Functions EOMonth
1:54
23.5 Date Difference Functions Days
3:05
23.6 Date Difference Functions Days360
6:35
23.7 Date Difference Functions DatedIf
24.1 Excel at Efficiency With Lookup Functions Match
18:07
24.2 Excel at Efficiency With Lookup Functions Vlookup
4:51
24.3 Excel at Efficiency With Lookup Functions Hlookup
4:47
24.4 Excel at Efficiency With Lookup Functions Index
25.1 Excel Ninja Decoding SUMPRODUCT
2:04
25.2 Excel Ninja Decoding SUMPRODUCT Basic
2:58
25.3 Excel Ninja Conditional Counting Part 1
25.4 Excel Ninja Conditional Counting Part 2
25.5 Excel Ninja Multiple Conditional Counting
2:22
25.6 Excel Ninja Conditional SUMPRODUCT
26.1 Text Join Function
27.1 Master the Power of Array Formulas in Excel
9:10
28.1 Working with Tables
2:21
28.2 Calculated Columns in Tables
28.3 Slicer in tables
4:40
29.1 Text To Column
29.2 Text To Column DELIMETED MODE
2:08
29.3 Text To Column Fixed Width Mode
4:20
30.1 Wildcards in Excel
30.2 Countif and Wildcards
5:39
30.3 Wildcard with Find & Replace
2:47
30.4 Data Filter with Wild Cards
7:13
31.1 Uncharted Territories of Data Filters
31.2 Mastering Advanced Filtering Techniques for Data Wizards
32.1 Mastering Excel Chart
4:49
32.2 Types of chart
5:12
32.3 How to create charts
8:56
33.1 The Art of Conditional Formatting
3:47
34.1 Introduction to Pivot Tables in Excel
6:16
34.2 How to create pivot table
2:37
35.1 Introduction to Slicers in Excel
6:26
35.2 How To insert Slicers using Table
35.3 Slicers and Pivot Charts
1:13
35.4 Modify appearance of slicer
