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

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 - Common Excel Formulas.xlsx

15 kB

~Get Your Files Here !/1 - Introduction/1 - Excel Shortcuts.xlsx

12 kB

~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4

45 MB

~Get Your Files Here !/2 - Getting Started with Excel/1 - COMPLETED TASK Project Plan for Course.xlsx

63 kB

~Get Your Files Here !/2 - Getting Started with Excel/1 - Excel Shortcuts.xlsx

12 kB

~Get Your Files Here !/2 - Getting Started with Excel/1 - Introduction to Module Getting started With Excel.html

1.2 kB

~Get Your Files Here !/2 - Getting Started with Excel/1 - Overview of the Excel Interface.mp4

50 MB

~Get Your Files Here !/2 - Getting Started with Excel/1 - Project Plan for Course.xlsx

16 kB

~Get Your Files Here !/2 - Getting Started with Excel/2 - Data Entry and Navigation Shortcuts.mp4

98 MB

~Get Your Files Here !/2 - Getting Started with Excel/3 - Data Types (Text, Currency, Numbers, Dates).mp4

141 MB

~Get Your Files Here !/2 - Getting Started with Excel/3 - Project Plan for Course.xlsx

60 kB

~Get Your Files Here !/2 - Getting Started with Excel/4 - Formatting Data.mp4

127 MB

~Get Your Files Here !/2 - Getting Started with Excel/5 - Basic Formulas (SUM, AVERAGE, MIN, MAX, COUNT).mp4

107 MB

~Get Your Files Here !/2 - Getting Started with Excel/6 - Cell Referencing (Relative, Absolute, Mixed).mp4

95 MB

~Get Your Files Here !/2 - Getting Started with Excel/7 - Data Validation (Drop down lists).mp4

28 MB

~Get Your Files Here !/2 - Getting Started with Excel/8 - Conditional Formatting.mp4

126 MB

~Get Your Files Here !/2 - Getting Started with Excel/9 - COMPLETED TASK Project Plan for Course.xlsx

63 kB

~Get Your Files Here !/2 - Getting Started with Excel/9 - Project Plan for Course.xlsx

16 kB

~Get Your Files Here !/2 - Getting Started with Excel/9 - TASK Create a Gantt Chart using Conditional Formatting.mp4

160 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Common Excel Formulas.pdf

68 kB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Common Excel Formulas.xlsx

15 kB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Introduction to Module Working with data and conditional calculations.html

957 B

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Sample Data for Cleaning.xlsx

15 kB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - Sorting data.mp4

58 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/1 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx

16 kB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/10 - Create a Simple Chart.mp4

106 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/11 - COMPLETED TASK - Create a 2 Sheet Sales Summary with Charts.xlsx

42 kB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/11 - TASK - Create a 2 Sheet Sales Summary with Charts - Instructions.xlsx

16 kB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/11 - TASK Create a Simple Sales Summary Dashboard.mp4

348 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/2 - Filtering Data.mp4

91 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/3 - Cleaning Data.mp4

142 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/4 - Subtotals.mp4

116 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/4 - Using Subtotals.mp4

62 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/5 - Use SUMIFS for conditional summing.mp4

70 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/6 - Use COUNTIFS and AVERAGEIFS.mp4

58 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/7 - Introduction to IF statements.mp4

76 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/8 - Using Flash Fill.mp4

42 MB

~Get Your Files Here !/3 - Working with Data and Conditional Calculations/9 - Linking Worksheets.mp4

117 MB

~Get Your Files Here !/4 - Mastering Lookups/1 - Introduction to Module Mastering Lookups.html

858 B

~Get Your Files Here !/4 - Mastering Lookups/1 - Region Codes for Lookup.xlsx

8.9 kB

~Get Your Files Here !/4 - Mastering Lookups/1 - Sales for lookup.xlsx

24 kB

~Get Your Files Here !/4 - Mastering Lookups/1 - Stock for Lookup.txt

24 kB

~Get Your Files Here !/4 - Mastering Lookups/1 - Stock for Lookup.xlsx

25 kB

~Get Your Files Here !/4 - Mastering Lookups/1 - Text to Columns for Data Preparation.mp4

69 MB

~Get Your Files Here !/4 - Mastering Lookups/1 - XLOOKUP EXAMPLES.xlsx

13 kB

~Get Your Files Here !/4 - Mastering Lookups/2 - Understanding VLOOKUP and HLOOKUP.mp4

102 MB

~Get Your Files Here !/4 - Mastering Lookups/3 - Combining lookups with other functions (eg Iferror).mp4

46 MB

~Get Your Files Here !/4 - Mastering Lookups/4 - Introduction to Xlookup.mp4

118 MB

~Get Your Files Here !/4 - Mastering Lookups/4 - XLOOKUP EXAMPLES.xlsx

13 kB

~Get Your Files Here !/4 - Mastering Lookups/5 - Region Codes for Lookup.xlsx

8.9 kB

~Get Your Files Here !/4 - Mastering Lookups/5 - Sales for lookup.xlsx

24 kB

~Get Your Files Here !/4 - Mastering Lookups/5 - Stock for Lookup.xlsx

25 kB

~Get Your Files Here !/4 - Mastering Lookups/5 - TASK Combine Sales and Stock data into one sheet.mp4

63 MB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - Introduction to Module Analysing Data with Pivot Tables.html

709 B

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - Introduction to Tables.mp4

107 MB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - Sales and Stock for Pivot Table.xlsx

32 kB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/1 - TASK Create an Open to Buy using a Pivot Table.xlsx

32 kB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/2 - Creating a Pivot Table.mp4

104 MB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/3 - Pivot Table Calculations.mp4

117 MB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/4 - Formatting a Pivot Table.mp4

101 MB

~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 kB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/5 - TASK Build an Open-to-Buy tool using Pivot Tables.mp4

236 MB

~Get Your Files Here !/5 - Analyzing Data with Pivot Tables/5 - TASK Create an Open to Buy using a Pivot Table.xlsx

32 kB

~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/1 - Introduction to Module Build Simple Dashboards using Pivot Tables and Charts.html

832 B

~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/1 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx

36 kB

~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/1 - Using Pivot Charts for Visualisation.mp4

79 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 !/6 - Build Simple Dashboards using Pivot Tables and Charts/3 - COMPLETED EXAMPLE - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx

90 kB

~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/3 - SALES AND STOCK FOR INTERACTIVE DASHBOARD.xlsx

36 kB

~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 MB

~Get Your Files Here !/6 - Build Simple Dashboards using Pivot Tables and Charts/4 - Final Message from the Instructor.html

506 B

~Get Your Files Here !/7 - Final Words/1 - Final Words from the Instructor.html

569 B

~Get Your Files Here !/Bonus Resources.txt

70 B