Udemy - Spreadsheets for Beginners - Master your Data Game

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Introduction
• 1. Welcome to the Course!.mp4 (123.7 MB)
• 1.1 Course Resources.html (0.1 KB)
• 1.2 DareData Website.html (0.1 KB)
• 1.3 Ivo's LinkedIn.html (0.1 KB)
• 1.4 Ivo's Youtube Channel.html (0.1 KB)
• 2. Using the Udemy Platform Playback Speed.mp4 (22.8 MB)
• 3. Course Materials.html (0.6 KB)
10. Course Ending
• 1. Thank you!.mp4 (10.1 MB)
• 2. BONUS LECTURE and Other Resources.html (2.6 KB)
2. Spreadsheet Basics
• 1. Starting a New Google Sheets File.mp4 (49.9 MB)
• 1.1 Google Drive Link.html (0.1 KB)
• 1.2 How to Create a Google Account from Scratch.html (0.1 KB)
• 2. Introduction to the Spreadsheet - Rows and Columns.mp4 (44.1 MB)
• 3. Introduction to the Tabular Format - Our First Data Input.mp4 (80.3 MB)
• 4. Creating and Formatting Tables with Microsoft Excel.mp4 (87.6 MB)
• 5. Working with Multiple Worksheets and Opening Files.mp4 (114.8 MB)
• 6. Saving Google Sheets and Microsoft Excel Files.mp4 (50.0 MB)
• 7. Google Sheets and Microsoft Excel Basics.html (0.1 KB)
3. Introduction to Worksheet Formulas
• 1. Introduction to Formulas and Simple Calculations.mp4 (168.5 MB)
• 2. Taking Advantage of Relative References.mp4 (79.1 MB)
• 3. Absolute References.mp4 (141.6 MB)
• 4. Introduction to Spreadsheet Functions SUM Example.mp4 (179.3 MB)
• 5. Minimum and Maximum Functions.mp4 (56.2 MB)
• 6. Obtaining data from other Worksheets and SUMIF Function.mp4 (135.6 MB)
• 7. COUNT and COUNTIF.mp4 (83.6 MB)
• 8. [Extra] - Selecting cells from other Worksheets in Microsoft Excel.mp4 (65.3 MB)
• 9. Introduction to Worksheet Formulas.html (0.1 KB)
4. Ebay Analyst Exercise
• 1. Ebay Analyst Exercise.mp4 (49.8 MB)
• 2. Ebay Analyst Exercise Quiz.html (0.1 KB)
• 3. Ebay Analyst Exercise Tasks.html (3.8 KB)
5. Formatting and Styling Worksheets
• 1. Introduction to Number Formatting, Rounding and Percentage.mp4 (160.6 MB)
• 2. Formatting Dates.mp4 (151.2 MB)
• 3. Formatting Text (Font Size, Bold, Italic, etc.).mp4 (102.7 MB)
• 4. Formatting and Styling Cells.mp4 (107.3 MB)
• 5. More on Cell and Text Formatting.mp4 (77.7 MB)
• 6. Merging Cells.mp4 (118.5 MB)
• 7. Conditional Formatting.mp4 (88.6 MB)
• 8. Formatting Menus in Excel.mp4 (26.9 MB)
• 9. Quiz - Formatting and Styling Worksheets.html (0.1 KB)
6. United States Census Exercise
• 1. United States Census Exercise.mp4 (29.1 MB)
• 2. United States Census Exercise Tasks.html (3.2 KB)
7. Data Management
• 1. Sorting Data.mp4 (135.5 MB)
• 2. Introduction to Filters.mp4 (147.8 MB)
• 3. Introduction to Plotting.mp4 (158.7 MB)
• 4. Data Validation.mp4 (83.0 MB)
• 5. IF and IFERROR.mp4 (158.3 MB)
• 6. Understanding Pivot Tables.mp4 (184.2 MB)
• 7. Quiz - Data Management.html (0.1 KB)
8. Airbnb Analyst - Exercise
• 1. Airbnb Analyst Exercise.mp4 (18.3 MB)
• 2. Airbnb Analyst Exercise Tasks.html (2.0 KB)
9. More on Functions!
• 1. UNIQUE Function.mp4 (154.5 MB)
• 2. VLOOKUP.mp4 (136.8 MB)
• 3. INDEX + MATCH.mp4 (157.8 MB)
• 4. AND + OR.mp4 (64.0 MB)
• 5. Quiz - More on Functions!.html (0.1 KB)
• Bonus Resources.txt (0.4 KB)