[ WebToolTip.com ] Udemy - Excel Work Essentials - From Beginner to Intermediate Mastery

• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/11 - TASK Create a Simple Sales Summary Dashboard.mp4-348.38 MB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/5 - TASK Build an Open-to-Buy tool using Pivot Tables.mp4-235.98 MB
• ~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/3 - TASK Build an Interactive Dashboard using Pivot Tables and Charts.mp4-182.42 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/9 - TASK Create a Gantt Chart using Conditional Formatting.mp4-159.67 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/3 - Cleaning Data.mp4-141.76 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/3 - Data Types (Text, Currency, Numbers, Dates).mp4-141.36 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/4 - Formatting Data.mp4-127.27 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/8 - Conditional Formatting.mp4-125.61 MB
• ~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/2 - Applying Slicers and Timelines for interactivity.mp4-119 MB
• ~Get Your Files Here !/4 - Mastering Lookups/4 - Introduction to Xlookup.mp4-118.35 MB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/3 - Pivot Table Calculations.mp4-116.9 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/9 - Linking Worksheets.mp4-116.76 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/4 - Subtotals.mp4-115.77 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/5 - Basic Formulas (SUM, AVERAGE, MIN, MAX, COUNT).mp4-107.25 MB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - Introduction to Tables.mp4-106.76 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/10 - Create a Simple Chart.mp4-106.31 MB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/2 - Creating a Pivot Table.mp4-104.07 MB
• ~Get Your Files Here !/4 - Mastering Lookups/2 - Understanding VLOOKUP and HLOOKUP.mp4-102.33 MB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/4 - Formatting a Pivot Table.mp4-101.26 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/2 - Data Entry and Navigation Shortcuts.mp4-98.49 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/6 - Cell Referencing (Relative, Absolute, Mixed).mp4-95.17 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/2 - Filtering Data.mp4-90.59 MB
• ~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/1 - Using Pivot Charts for Visualisation.mp4-78.6 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/7 - Introduction to IF statements.mp4-76.53 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/5 - Use SUMIFS for conditional summing.mp4-70.38 MB
• ~Get Your Files Here !/4 - Mastering Lookups/1 - Text to Columns for Data Preparation.mp4-69.17 MB
• ~Get Your Files Here !/4 - Mastering Lookups/5 - TASK Combine Sales and Stock data into one sheet.mp4-63.32 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/4 - Using Subtotals.mp4-61.67 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Sorting data.mp4-58.11 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/6 - Use COUNTIFS and AVERAGEIFS.mp4-57.8 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/1 - Overview of the Excel Interface.mp4-49.66 MB
• ~Get Your Files Here !/4 - Mastering Lookups/3 - Combining lookups with other functions (eg Iferror).mp4-46.23 MB
• ~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4-45.02 MB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/8 - Using Flash Fill.mp4-42.12 MB
• ~Get Your Files Here !/2 - Getting Started with Excel/7 - Data Validation (Drop down lists).mp4-27.96 MB
• ~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/3 - COMPLETED EXAMPLE - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx-89.93 KB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Common Excel Formulas.pdf-68.01 KB
• ~Get Your Files Here !/2 - Getting Started with Excel/1 - COMPLETED TASK Project Plan for Course.xlsx-62.71 KB
• ~Get Your Files Here !/2 - Getting Started with Excel/9 - COMPLETED TASK Project Plan for Course.xlsx-62.71 KB
• ~Get Your Files Here !/2 - Getting Started with Excel/3 - Project Plan for Course.xlsx-60.19 KB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/5 - COMPLETED EXAMPLE - TASK Create an Open to Buy using a Pivot Table.xlsx-56.11 KB
• ~Get Your Files Here !/3 - Working with Data and Conditional Calculations/11 - COMPLETED TASK - Create a 2 Sheet Sales Summary with Charts.xlsx-42.18 KB
• ~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/1 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx-35.7 KB
• ~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/3 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx-35.7 KB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - TASK Create an Open to Buy using a Pivot Table.xlsx-31.65 KB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/5 - TASK Create an Open to Buy using a Pivot Table.xlsx-31.65 KB
• ~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - Sales and Stock for Pivot Table.xlsx-31.63 KB
• ~Get Your Files Here !/4 - Mastering Lookups/1 - Stock for Lookup.xlsx-25.13 KB
• ~Get Your Files Here !/4 - Mastering Lookups/5 - Stock for Lookup.xlsx-25.13 KB
• ~Get Your Files Here !/4 - Mastering Lookups/1 - Sales for lookup.xlsx-24.4 KB