| 1 - COMPLETED TASK Project Plan for Course.xlsx | 62.7 KB | ||
| 1 - Common Excel Formulas.pdf | 68 KB | ||
| 1 - Common Excel Formulas.xlsx | 14.9 KB | ||
| 1 - Excel Shortcuts.xlsx | 12.2 KB | ||
| 1 - Final Words from the Instructor.html | 614.4 B | ||
| 1 - Introduction to Module Analysing Data with Pivot Tables.html | 716.8 B | ||
| 1 - Introduction to Module Build Simple Dashboards using Pivot Tables and Charts.html | 819.2 B | ||
| 1 - Introduction to Module Getting started With Excel.html | 1.2 KB | ||
| 1 - Introduction to Module Mastering Lookups.html | 819.2 B | ||
| 1 - Introduction to Module Working with data and conditional calculations.html | 921.6 B | ||
| 1 - Introduction to Tables.mp4 | 106.8 MB | ||
| 1 - Introduction.mp4 | 45 MB | ||
| 1 - Overview of the Excel Interface.mp4 | 49.7 MB | ||
| 1 - Project Plan for Course.xlsx | 15.6 KB | ||
| 1 - Region Codes for Lookup.xlsx | 8.9 KB | ||
| 1 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx | 35.7 KB | ||
| 1 - Sales and Stock for Pivot Table.xlsx | 31.6 KB | ||
| 1 - Sales for lookup.xlsx | 24.4 KB | ||
| 1 - Sample Data for Cleaning.xlsx | 14.9 KB | ||
| 1 - Sorting data.mp4 | 58.1 MB | ||
| 1 - Stock for Lookup.txt | 23.7 KB | ||
| 1 - Stock for Lookup.xlsx | 25.1 KB | ||
| 1 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx | 16 KB | ||
| 1 - TASK Create an Open to Buy using a Pivot Table.xlsx | 31.6 KB | ||
| 1 - Text to Columns for Data Preparation.mp4 | 69.2 MB | ||
| 1 - Using Pivot Charts for Visualisation.mp4 | 78.6 MB | ||
| 1 - XLOOKUP EXAMPLES.xlsx | 13.2 KB | ||
| 10 - Create a Simple Chart.mp4 | 106.3 MB | ||
| 11 - COMPLETED TASK - Create a 2 Sheet Sales Summary with Charts.xlsx | 42.2 KB | ||
| 11 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx | 16 KB | ||
| 11 - TASK Create a Simple Sales Summary Dashboard.mp4 | 348.4 MB | ||
| 2 - Applying Slicers and Timelines for interactivity.mp4 | 119 MB | ||
| 2 - Creating a Pivot Table.mp4 | 104.1 MB | ||
| 2 - Data Entry and Navigation Shortcuts.mp4 | 98.5 MB | ||
| 2 - Filtering Data.mp4 | 90.6 MB | ||
| 2 - Understanding VLOOKUP and HLOOKUP.mp4 | 102.3 MB | ||
| 3 - COMPLETED EXAMPLE - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx | 89.9 KB | ||
| 3 - Cleaning Data.mp4 | 141.8 MB | ||
| 3 - Combining lookups with other functions (eg Iferror).mp4 | 46.2 MB | ||
| 3 - Data Types (Text, Currency, Numbers, Dates).mp4 | 141.4 MB | ||
| 3 - Pivot Table Calculations.mp4 | 116.9 MB | ||
| 3 - Project Plan for Course.xlsx | 60.2 KB | ||
| 3 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx | 35.7 KB | ||
| 3 - TASK Build an Interactive Dashboard using Pivot Tables and Charts.mp4 | 182.4 MB | ||
| 4 - Final Message from the Instructor.html | 512 B | ||
| 4 - Formatting Data.mp4 | 127.3 MB | ||
| 4 - Formatting a Pivot Table.mp4 | 101.3 MB | ||
| 4 - Introduction to Xlookup.mp4 | 118.4 MB | ||
| 4 - Subtotals.mp4 | 115.8 MB | ||
| 4 - Using Subtotals.mp4 | 61.7 MB | ||
| 4 - XLOOKUP EXAMPLES.xlsx | 13.2 KB | ||
| 5 - Basic Formulas (SUM, AVERAGE, MIN, MAX, COUNT).mp4 | 107.2 MB | ||
| 5 - COMPLETED EXAMPLE - TASK Create an Open to Buy using a Pivot Table.xlsx | 56.1 KB | ||
| 5 - Region Codes for Lookup.xlsx | 8.9 KB | ||
| 5 - Sales for lookup.xlsx | 24.4 KB | ||
| 5 - Stock for Lookup.xlsx | 25.1 KB | ||
| 5 - TASK Build an Open-to-Buy tool using Pivot Tables.mp4 | 236 MB | ||
| 5 - TASK Combine Sales and Stock data into one sheet.mp4 | 63.3 MB | ||
| 5 - TASK Create an Open to Buy using a Pivot Table.xlsx | 31.6 KB | ||
| 5 - Use SUMIFS for conditional summing.mp4 | 70.4 MB | ||
| 6 - Cell Referencing (Relative, Absolute, Mixed).mp4 | 95.2 MB | ||
| 6 - Use COUNTIFS and AVERAGEIFS.mp4 | 57.8 MB | ||
| 7 - Data Validation (Drop down lists).mp4 | 28 MB | ||
| 7 - Introduction to IF statements.mp4 | 76.5 MB | ||
| 8 - Conditional Formatting.mp4 | 125.6 MB | ||
| 8 - Using Flash Fill.mp4 | 42.1 MB | ||
| 9 - COMPLETED TASK Project Plan for Course.xlsx | 62.7 KB | ||
| 9 - Linking Worksheets.mp4 | 116.8 MB | ||
| 9 - Project Plan for Course.xlsx | 15.6 KB | ||
| 9 - TASK Create a Gantt Chart using Conditional Formatting.mp4 | 159.7 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 74 total files | |||
Excel Work Essentials: From Beginner to Intermediate Mastery
https://WebToolTip.com
Published 9/2025
Created by Nathan Rogers
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 41 Lectures ( 5h 34m ) | Size: 3.62 GB
Learn Excel Formulas, Charts And Pivot Tables With Hands-On Projects For Work Success!
What you'll learn
Create Useful Excel Workplace Tools: A Gantt Chart Project Planner and an Open-to-buy Calculator
Create Professional Reports with Excel Formulas
Lookup and Analyse Workplace Data with Confidence
Understand Tables, Pivot Tables, and Pivot table Calculations
Understand Charts, Pivot Charts, and use Slicers
Build Dynamic Dashboards with Pivot Charts for Data Visualization
Requirements
No previous excel experience is needed. You will need access to a computer and internet and a willingness to upskill
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 4 weeks | 12 | 1 | |
| 2.7 GB | freecoursewb | 4 weeks | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
| 3.8 GB | freecoursewb | 1 month | 19 | 5 |
All Comments