Advanced Excel Course [FULL COURSE in 2 Hours]
Complete Advanced Excel Course
Zero to Hero
#excel #advancedexcel
++++++++++++++++++
Chapters in this Course
++++++++++++++++++
00:00 Introduction
00:58 Text to Columns
03:42 Concatenate Function
06:18 Right Function with Concatenation
10:28 Absolute Cell References
13:50 Data Validation
18:21 Time and Date Calculations
26:25 Value Error for DATEVALUE Function
30:11 3D Formulas
31:30 IF Function
37:44 Conditional Formatting
41:13 Conditional Formatting to hide cell
44:24 Pivot Tables
55:21 Slicers in Pivot Table
55:26 Updating a Pivot Table
01:01:47 Grouping items
01:06:58 XLOOKUP Function
01:16:06 Nested XLOOKUP with SUM Function
01:23:15 Charts
01:29:22 Chart Types
01:38:16 Pie Charts
01:42:16 Converting numbers to words
