WebToolTip com Udemy Excel Work Essentials From Beginner to Intermediate Mastery

WebToolTip com Udemy Excel Work Essentials From Beginner to Intermediate Mastery

Name	[ WebToolTip.com ] Udemy - Excel Work Essentials - From Beginner to Intermediate Mastery	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.9 GB
Total Files	74
Last Seen
Hash	4C53D1A5E1EC4E2F4825F9231BEE2D3380AEB691

/
Get Bonus Downloads Here.url	0.2 KB
/1 - Introduction/
1 - Common Excel Formulas.xlsx	15.2 KB
1 - Excel Shortcuts.xlsx	12.5 KB
1 - Introduction.mp4	47.2 MB
/.../2 - Getting Started with Excel/
1 - COMPLETED TASK Project Plan for Course.xlsx	64.2 KB
1 - Excel Shortcuts.xlsx	12.5 KB
1 - Introduction to Module Getting started With Excel.html	1.3 KB
1 - Overview of the Excel Interface.mp4	52.1 MB
1 - Project Plan for Course.xlsx	16.0 KB
2 - Data Entry and Navigation Shortcuts.mp4	103.3 MB
3 - Data Types (Text, Currency, Numbers, Dates).mp4	148.2 MB
3 - Project Plan for Course.xlsx	61.6 KB
4 - Formatting Data.mp4	133.5 MB
5 - Basic Formulas (SUM, AVERAGE, MIN, MAX, COUNT).mp4	112.5 MB
6 - Cell Referencing (Relative, Absolute, Mixed).mp4	99.8 MB
7 - Data Validation (Drop down lists).mp4	29.3 MB
8 - Conditional Formatting.mp4	131.7 MB
9 - COMPLETED TASK Project Plan for Course.xlsx	64.2 KB
9 - Project Plan for Course.xlsx	16.0 KB
9 - TASK Create a Gantt Chart using Conditional Formatting.mp4	167.4 MB
/.../3 - Working with Data and Conditional Calculations/
1 - Common Excel Formulas.pdf	69.6 KB
1 - Common Excel Formulas.xlsx	15.2 KB
1 - Introduction to Module Working with data and conditional calculations.html	1.0 KB
1 - Sample Data for Cleaning.xlsx	15.3 KB
1 - Sorting data.mp4	60.9 MB
1 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx	16.4 KB
10 - Create a Simple Chart.mp4	111.5 MB
11 - COMPLETED TASK - Create a 2 Sheet Sales Summary with Charts.xlsx	43.2 KB
11 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx	16.4 KB
11 - TASK Create a Simple Sales Summary Dashboard.mp4	365.3 MB
2 - Filtering Data.mp4	95.0 MB
3 - Cleaning Data.mp4	148.6 MB
4 - Subtotals.mp4	121.4 MB
4 - Using Subtotals.mp4	64.7 MB
5 - Use SUMIFS for conditional summing.mp4	73.8 MB
6 - Use COUNTIFS and AVERAGEIFS.mp4	60.6 MB
7 - Introduction to IF statements.mp4	80.2 MB
8 - Using Flash Fill.mp4	44.2 MB
9 - Linking Worksheets.mp4	122.4 MB
/4 - Mastering Lookups/
1 - Introduction to Module Mastering Lookups.html	0.9 KB
1 - Region Codes for Lookup.xlsx	9.1 KB
1 - Sales for lookup.xlsx	25.0 KB
1 - Stock for Lookup.txt	24.2 KB
1 - Stock for Lookup.xlsx	25.7 KB
1 - Text to Columns for Data Preparation.mp4	72.5 MB
1 - XLOOKUP EXAMPLES.xlsx	13.5 KB
2 - Understanding VLOOKUP and HLOOKUP.mp4	107.3 MB
3 - Combining lookups with other functions (eg Iferror).mp4	48.5 MB
4 - Introduction to Xlookup.mp4	124.1 MB
4 - XLOOKUP EXAMPLES.xlsx	13.5 KB
5 - Region Codes for Lookup.xlsx	9.1 KB
5 - Sales for lookup.xlsx	25.0 KB
5 - Stock for Lookup.xlsx	25.7 KB
5 - TASK Combine Sales and Stock data into one sheet.mp4	66.4 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	111.9 MB
1 - Sales and Stock for Pivot Table.xlsx	32.4 KB
1 - TASK Create an Open to Buy using a Pivot Table.xlsx	32.4 KB
2 - Creating a Pivot Table.mp4	109.1 MB
3 - Pivot Table Calculations.mp4	122.6 MB
4 - Formatting a Pivot Table.mp4	106.2 MB
5 - COMPLETED EXAMPLE - TASK Create an Open to Buy using a Pivot Table.xlsx	57.5 KB
5 - TASK Build an Open-to-Buy tool using Pivot Tables.mp4	247.4 MB
5 - TASK Create an Open to Buy using a Pivot Table.xlsx	32.4 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	36.6 KB
1 - Using Pivot Charts for Visualisation.mp4	82.4 MB
2 - Applying Slicers and Timelines for interactivity.mp4	124.8 MB
3 - COMPLETED EXAMPLE - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx	92.1 KB
3 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx	36.6 KB
3 - TASK Build an Interactive Dashboard using Pivot Tables and Charts.mp4	191.3 MB
4 - Final Message from the Instructor.html	0.5 KB
/7 - Final Words/
1 - Final Words from the Instructor.html	0.6 KB
~Get Your Files Here !/
Bonus Resources.txt	0.1 KB
Total files 74