Udemy - Excel Work Essentials - From Beginner to Intermediate Mastery

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Common Excel Formulas.xlsx (14.9 KB)
• 1 - Excel Shortcuts.xlsx (12.2 KB)
• 1 - Introduction.mp4 (45.0 MB)
2 - Getting Started with Excel
• 1 - COMPLETED TASK Project Plan for Course.xlsx (62.7 KB)
• 1 - Excel Shortcuts.xlsx (12.2 KB)
• 1 - Introduction to Module Getting started With Excel.html (1.2 KB)
• 1 - Overview of the Excel Interface.mp4 (49.7 MB)
• 1 - Project Plan for Course.xlsx (15.6 KB)
• 2 - Data Entry and Navigation Shortcuts.mp4 (98.5 MB)
• 3 - Data Types (Text, Currency, Numbers, Dates).mp4 (141.4 MB)
• 3 - Project Plan for Course.xlsx (60.2 KB)
• 4 - Formatting Data.mp4 (127.3 MB)
• 5 - Basic Formulas (SUM, AVERAGE, MIN, MAX, COUNT).mp4 (107.2 MB)
• 6 - Cell Referencing (Relative, Absolute, Mixed).mp4 (95.2 MB)
• 7 - Data Validation (Drop down lists).mp4 (28.0 MB)
• 8 - Conditional Formatting.mp4 (125.6 MB)
• 9 - COMPLETED TASK Project Plan for Course.xlsx (62.7 KB)
• 9 - Project Plan for Course.xlsx (15.6 KB)
• 9 - TASK Create a Gantt Chart using Conditional Formatting.mp4 (159.7 MB)
3 - Working with Data and Conditional Calculations
• 1 - Common Excel Formulas.pdf (68.0 KB)
• 1 - Common Excel Formulas.xlsx (14.9 KB)
• 1 - Introduction to Module Working with data and conditional calculations.html (0.9 KB)
• 1 - Sample Data for Cleaning.xlsx (14.9 KB)
• 1 - Sorting data.mp4 (58.1 MB)
• 1 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx (16.0 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.0 KB)
• 11 - TASK Create a Simple Sales Summary Dashboard.mp4 (348.4 MB)
• 2 - Filtering Data.mp4 (90.6 MB)
• 3 - Cleaning Data.mp4 (141.8 MB)
• 4 - Subtotals.mp4 (115.8 MB)
• 4 - Using Subtotals.mp4 (61.7 MB)
• 5 - Use SUMIFS for conditional summing.mp4 (70.4 MB)
• 6 - Use COUNTIFS and AVERAGEIFS.mp4 (57.8 MB)
• 7 - Introduction to IF statements.mp4 (76.5 MB)
• 8 - Using Flash Fill.mp4 (42.1 MB)
• 9 - Linking Worksheets.mp4 (116.8 MB)
4 - Mastering Lookups
• 1 - Introduction to Module Mastering Lookups.html (0.8 KB)
• 1 - Region Codes for Lookup.xlsx (8.9 KB)
• 1 - Sales for lookup.xlsx (24.4 KB)
• 1 - Stock for Lookup.txt (23.7 KB)
• 1 - Stock for Lookup.xlsx (25.1 KB)
• 1 - Text to Columns for Data Preparation.mp4 (69.2 MB)
• 1 - XLOOKUP EXAMPLES.xlsx (13.2 KB)
• 2 - Understanding VLOOKUP and HLOOKUP.mp4 (102.3 MB)
• 3 - Combining lookups with other functions (eg Iferror).mp4 (46.2 MB)
• 4 - Introduction to Xlookup.mp4 (118.4 MB)
• 4 - XLOOKUP EXAMPLES.xlsx (13.2 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 Combine Sales and Stock data into one sheet.mp4 (63.3 MB)
5 - Analyzing Data with Pivot Tables
• 1 - Introduction to Module Analysing Data with Pivot Tables.html (0.7 KB)
• 1 - Introduction to Tables.mp4 (106.8 MB)
• 1 - Sales and Stock for Pivot Table.xlsx (31.6 KB)
• 1 - TASK Create an Open to Buy using a Pivot Table.xlsx (31.6 KB)
• 2 - Creating a Pivot Table.mp4 (104.1 MB)
• 3 - Pivot Table Calculations.mp4 (116.9 MB)
• 4 - Formatting a Pivot Table.mp4 (101.3 MB)
• 5 - COMPLETED EXAMPLE - TASK Create an Open to Buy using a Pivot Table.xlsx (56.1 KB)
• 5 - TASK Build an Open-to-Buy tool using Pivot Tables.mp4 (236.0 MB)
• 5 - TASK Create an Open to Buy using a Pivot Table.xlsx (31.6 KB)
6 - Build Simple Dashboards using Pivot Tables and Charts
• 1 - Introduction to Module Build Simple Dashboards using Pivot Tables and Charts.html (0.8 KB)
• 1 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx (35.7 KB)
• 1 - Using Pivot Charts for Visualisation.mp4 (78.6 MB)
• 2 - Applying Slicers and Timelines for interactivity.mp4 (119.0 MB)
• 3 - COMPLETED EXAMPLE - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx (89.9 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 (0.5 KB)
7 - Final Words
• 1 - Final Words from the Instructor.html (0.6 KB)
• Bonus Resources.txt (0.1 KB)