Learn Microsoft Excel from Scratch (2025)

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Excel Basics - Getting Started
• 1 -Introduction to Microsoft Excel.mp4 (21.5 MB)
• 2 -Understanding the Excel Interface.mp4 (27.6 MB)
• 3 -Enter & Format data - Practice File.xlsx (8.4 KB)
• 3 -How to Enter & Format Data in Excel.mp4 (20.9 MB)
• 3 -Quick Guide to Data Entry & Formatting in Excel.pdf (30.0 KB)
• 4 -Excel_Formatting_Practice file.xlsx (4.9 KB)
• 4 -Formatting Text, Numbers & Dates in Excel.mp4 (26.5 MB)
• 4 -Quick Guide to Excel_Formatting.pdf (31.4 KB)
• 5 -Creating Simple Tables in Excel.mp4 (27.1 MB)
• 5 -Quick Guide to Excel table.pdf (30.9 KB)
• 5 -Sales_Data_Table_Practice.xlsx (8.3 KB)
• 6 -Cell_References_Practice.xlsx (6.0 KB)
• 6 -Mastering Cell References in Excel.mp4 (30.7 MB)
• 6 -Quick Guide to Cell_References in Excel.pdf (30.0 KB)
2 - Essential Formulas & Functions
• 1 -Basic Excel Formulas – SUM, AVERAGE, MIN, MAX.mp4 (32.1 MB)
• 1 -Basic_Excel_Formulas_Practice file.xlsx (5.1 KB)
• 1 -Quick Guide to Basic_Excel_Formulas in Excel.pdf (27.4 KB)
• 2 -Automate in Excel – AutoFill & Flash Fill.mp4 (30.9 MB)
• 2 -Quick Guide to autofill & flashfill in Excel.pdf (67.8 KB)
• 2 -autofill_flashfill_practice.xlsx (11.9 KB)
• 3 -Fixing Formula Errors in Excel.mp4 (43.4 MB)
• 3 -Quick Guide to formula_errors in Excel.pdf (30.4 KB)
• 3 -formula_errors_practice file.xlsx (6.1 KB)
• 3 -iferror_practice.xlsx (5.6 KB)
• 4 -Conditional_formulas_practice.xlsx (8.6 KB)
• 4 -Excel Conditional Formulas – IF, COUNTIF & SUMIF Explained.mp4 (36.5 MB)
• 5 -Text Functions in Excel – Split, Count & Combine Like a Pro.mp4 (71.5 MB)
• 5 -text_functions_practice.xlsx (10.8 KB)
• 6 -Mastering DATE Functions in Excel – TODAY, NOW, DATEDIF, EOMONTH.mp4 (38.2 MB)
• 6 -date_functions_practice.xlsx (9.3 KB)
• 7 -Mastering VLOOKUP & HLOOKUP in Excel.mp4 (47.0 MB)
• 7 -vlookup_hlookup_practice.xlsx (9.5 KB)
• 8 -Dynamic Lookups with INDEX & MATCH in Excel.mp4 (50.3 MB)
• 8 -index_match_lookup_practice.xlsx (8.8 KB)
• 9 -Logical Formulas in Excel – AND, OR, NOT.mp4 (46.7 MB)
• 9 -logical_functions_practice.xlsx (8.6 KB)
3 - Data Tools & Excel Features
• 1 -Employee_Sorting_Filtering.xlsx (8.5 KB)
• 1 -Sorting & Filtering Data in Excel.mp4 (30.2 MB)
• 2 -Drop-down Lists & Data Validation in Excel.mp4 (52.6 MB)
• 2 -Student_DataValidation_Form.xlsx (9.1 KB)
• 3 -Data_Cleanup_Tools_Practice.xlsx (12.1 KB)
• 3 -Removing Duplicates & Splitting Data with Text to Columns.mp4 (37.7 MB)
• 4 -Named Ranges – Why and How to Use in Excel.mp4 (33.4 MB)
• 4 -Named_Ranges_Exercise.xlsx (5.6 KB)
• 5 -Paste Special & Transpose in Excel.mp4 (36.8 MB)
• 5 -Paste_Special_Transpose_Practice.xlsx (6.2 KB)
• 6 -Grouping & Outlining Data in Excel.mp4 (37.3 MB)
• 6 -Quarterly_Expense_Tracker_Grouped.xlsx (5.2 KB)
• 7 -Freeze Panes & Split View in Excel.mp4 (49.6 MB)
• 7 -Freeze_Split_Demo_Sheet.xlsx (11.3 KB)
4 - Charts & Visualizations
• 1 -Creating Your First Chart (Column, Line, Pie) in Excel.mp4 (49.9 MB)
• 1 -Product_Sales_Chart_Practice.xlsx (5.9 KB)
• 2 -Custom_Charts_Excel_Practice.xlsx (5.4 KB)
• 2 -Customizing Chart Elements & Styles in Excel.mp4 (52.6 MB)
• 3 -Combo Charts & Secondary Axis in Excel.mp4 (37.6 MB)
• 3 -ComboChart_Exercise.xlsx (7.3 KB)
• 4 -Conditional Formatting – Basics to Advanced.mp4 (36.9 MB)
• 4 -ConditionalFormatting_Examples.xlsx (6.3 KB)
• 5 -Sparklines & Data Bars – Visualize Trends Inside Cells.mp4 (36.9 MB)
• 5 -Sparklines_DataBars_Practice.xlsx (5.4 KB)
• 6 -Creating a KPI Dashboard in Excel – Mini Project.mp4 (82.6 MB)
5 - Pivot Tables & Data Analysis
• 1 -Introduction to Pivot Tables in Excel.mp4 (35.5 MB)
• 1 -Pivot Table_Practice file.xlsx (9.2 KB)
• 2 -Summarizing Data with Pivot Tables.mp4 (27.0 MB)
• 2 -Summarizing pivot data_practice.xlsx (9.1 KB)
• 3 -Grouping, Filtering & Sorting in Pivot Tables.mp4 (34.5 MB)
• 3 -Grouping, filtering, sorting_practice file.xlsx (9.1 KB)
• 4 -Pivot Charts – Dynamic Visuals from Pivot Tables.mp4 (35.0 MB)
• 4 -Pivot charts_practice file.xlsx (9.1 KB)
• 5 -Slicer_practice file.xlsx (9.1 KB)
• 5 -Using Slicers with Pivot Tables.mp4 (37.4 MB)
6 - Workbook Management & Final Touches
• 1 -Protect Sheets & Lock Cells in Excel.mp4 (30.0 MB)
• 2 -Hiding Sheets, Rows & Columns in Excel.mp4 (24.2 MB)
• 3 -Hyperlinks and Comments in Excel.mp4 (26.4 MB)
• 4 -Page Setup & Print Settings in Excel.mp4 (43.0 MB)
7 - Wrapping up
• 1 -Bonus Lesson.mp4 (30.3 MB)
• 1 -Bonus lesson.pdf (1.2 MB)
• Bonus Resources.txt (0.1 KB)