Spreadsheets for Beginners: Master your Data Game

سرفصل های دوره

Learn how to work with Spreadsheet software (Google Sheets and Excel) completely from scratch

1. Introduction

1.1 Course Resources.html

1.2 DareData Website.html

1.3 Ivos LinkedIn.html

1.4 Ivos Youtube Channel.html

1. Welcome to the Course!

2. Using the Udemy Platform Playback Speed

3. Course Materials.html

2. Spreadsheet Basics

1.1 Google Drive Link.html

1.2 How to Create a Google Account from Scratch.html

1. Starting a New Google Sheets File

2. Introduction to the Spreadsheet - Rows and Columns

3. Introduction to the Tabular Format - Our First Data Input

4. Creating and Formatting Tables with Microsoft Excel

5. Working with Multiple Worksheets and Opening Files

6. Saving Google Sheets and Microsoft Excel Files

7. Google Sheets and Microsoft Excel Basics.html

3. Introduction to Worksheet Formulas

1. Introduction to Formulas and Simple Calculations

2. Taking Advantage of Relative References

3. Absolute References

4. Introduction to Spreadsheet Functions SUM Example

5. Minimum and Maximum Functions

6. Obtaining data from other Worksheets and SUMIF Function

7. COUNT and COUNTIF

8. [Extra] - Selecting cells from other Worksheets in Microsoft Excel

9. Introduction to Worksheet Formulas.html

4. Ebay Analyst Exercise

1. Ebay Analyst Exercise

2. Ebay Analyst Exercise Quiz.html

3. Ebay Analyst Exercise Tasks.html

5. Formatting and Styling Worksheets

1. Introduction to Number Formatting, Rounding and Percentage

2. Formatting Dates

3. Formatting Text (Font Size, Bold, Italic, etc.)

4. Formatting and Styling Cells

5. More on Cell and Text Formatting

6. Merging Cells

7. Conditional Formatting

8. Formatting Menus in Excel

9. Quiz - Formatting and Styling Worksheets.html

6. United States Census Exercise

1. United States Census Exercise

2. United States Census Exercise Tasks.html

7. Data Management

1. Sorting Data

2. Introduction to Filters

3. Introduction to Plotting

4. Data Validation

5. IF and IFERROR

6. Understanding Pivot Tables

7. Quiz - Data Management.html

8. Airbnb Analyst - Exercise

1. Airbnb Analyst Exercise

2. Airbnb Analyst Exercise Tasks.html

9. More on Functions!

1. UNIQUE Function

2. VLOOKUP

3. INDEX + MATCH

4. AND + OR

5. Quiz - More on Functions!.html

10. Course Ending

1. Thank you!

2. BONUS LECTURE and Other Resources.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy