Mastering Excel: The Ultimate Guide for Beginners to Advanced Users (Full 3-Hour Tutorial)
1:51:10 1:24:56 27:38 Chapters:
0:09 Introduction to Excel and Spreadsheets
2:14 Microsoft Excel Basics: Data Entry, Fonts, and Cell Alignment
4:08 Navigating and Customizing the Microsoft Excel Interface
6:05 Using the SUM and AVERAGE Formulas
7:25 Working with Functions: Find Percentage and Grade
8:22 Managing Rows and Columns & Writing Roman Numerals
10:19Creating Email Addresses in Microsoft Excel
11:03 Mastering AutoFill and Flash Fill in Microsoft Excel
11:58 Excel Mastery: Running Macros to Automate Tasks
11:24 Sorting and Filtering Data in Microsoft Excel
12:14 Applying Conditional Formatting in Microsoft Excel
13:30 Understanding and Using Cell References (Relative, Absolute, Mixed) in Excel
14:33 Formatting Charts in Microsoft Excel
15:49 Creating Basic Charts (Bar, Line, Pie) in Excel
18:13 Using Logical Functions in Excel: AND, OR
19:54 Using Text Functions (MID) in Microsoft Excel
20:50 Using Text Functions (LEFT, RIGHT) in Microsoft Excel
21:31 Using TODAY and NOW Functions in Excel
22:15 Advanced Excel Skills: Calculating Age Using DATEDIF and TODAY Functions
23:12 Data Validation and Its Practical Applications in Excel
24:27 Pivot Table Basics in Excel
27:38 Formatting Pivot Tables in Excel
29:36 Performing Pivot Table Calculations in Excel
27:38 Introduction to Macros in Excel
31:04 Formatting Macros in Excel
34:13 Mastering the VLOOKUP Function in Excel
36:10 Mastering the HLOOKUP Function in Excel
38:16 Mastering INDEX and MATCH Functions in Excel
40:42 Introduction to the Analysis Toolpak in Excel & How to Add Toolpak
43:01 Creating Histograms in Excel
43:56 Creating Pareto Charts in Excel
48:42 Regression Analysis in Microsoft Excel
52:48 Using Solver in Excel: Optimize and Solve Complex Problems
55:54 Forecasting with Excel: Predict Future Trends and Data
57:54 Introduction to What-If Analysis in Excel
58:38 Mastering Scenario Manager in Excel
1:02:29 Using Goal Seek in Excel
1:04:19 Using Data Tables in Excel
1:05:14 Mastering Keyboard Shortcuts for Formulas in Excel: Speed Up Your Calculations
1:07:39 Excel Power Tips: Must-Know Keyboard Shortcuts for Fast Navigation
1:07:56 Creating Custom Keyboard Shortcuts in Excel
1:09:19 Quick and Easy Number Formatting in Excel
1:09:33 Mastering the Quick Access Toolbar in Excel
1:13:32 Creating Custom Ribbon Tabs in Excel
1:14:15 Using Templates in Excel
1:16:05 Protecting Worksheets in Excel
Inspecting and Protecting Workbooks in Excel
1:18:17 Sharing and Collaborating on Workbooks in Excel
1:21:02 Data Visualization in Excel: Creating Combo Charts for Enhanced Insights
1:22:45 Creating Sparklines in Excel
1:24:56 Using Data Bars in Excel: Visualize Your Data Quickly
1:26:33 Using Color Scales in Excel
1:28:23 Creating Heat Maps in Excel
1:32:55 Using Icon Sets in Excel
1:35:13 Creating Gantt Charts in Excel
1:37:54 Creating Waterfall Charts in Excel
1:40:10 Creating Funnel Charts in Excel
1:42:43 Creating Sunburst Charts in Excel
1:44:44 Removing Duplicates in Excel
1:46:35 Counting Duplicates in Excel Using Formulas
1:48:38 Mastering Custom Formulas in Excel
1:49:42 Splitting Text to Columns in Excel
1:50:15 Using Flash Fill in Excel
1:51:10 How to Use the CONCATENATE Function in Excel
1:51:54 Using FIND and REPLACE in Excel
1:52:49 Converting Text to Numbers in Excel
1:53:22 Handling Errors with ISERROR and IFERROR in Excel
1:54:29 Data Formatting Best Practices in Excel
1:55:13 Mastering Array Formulas in Excel
1:56:30 Understanding and Using the OFFSET Function in Excel
1:57:25 How to Use the INDIRECT Function in Excel
1:58:09 How to Use the TRANSPOSE Function in Excel
1:58:53 Using CONCATENATE vs CONCAT Functions in Excel
1:59:59 Using the TEXT Function in Excel
Counting Hours in Excel
Using the LEN & LEFT Functions in Excel
2:01:05 Using the INT & TRUNC Formulas in Excel
2:01:38 Mastering the ROUND Function in Excel
2:02:34 Creating Invoices in Excel
2:11:40 Tracking Expenses in Excel
2:16:53 Creating Inventory Lists in Excel
2:16 Creating Sales Reports in Excel
2:18:45 Using Slicers in Excel
2:21:29 Creating Dashboards in Excel
2:22:35 Using Power Query in Excel
2:25:11 Mastering the UNIQUE Function in Excel
2:26:17 Mastering the Watch Window in Excel
2:27 Mastering Comments and Notes in Excel
2:28:42 Using Named Ranges in Excel
2:28:50 Using Hyperlinks in Excel
2:29:47 Creating Drop-Down Lists in Excel
2:30:18 Grouping and Ungrouping Data in Excel
2:31:02 Freezing Panes in Excel
2:31:46 Using Multiple Windows and Split View in Excel: Boost Your Productivity
Join this channel to get access to perks:
/ @kasturilal