Spreadsheets for Beginners: Master your Data Game

Focused View

Ivo Bernardo

4:14:09

496 View

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!.mp4

10:32

2. Using the Udemy Platform Playback Speed.mp4

01:36

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.mp4

03:53

2. Introduction to the Spreadsheet - Rows and Columns.mp4

03:21

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

06:00

4. Creating and Formatting Tables with Microsoft Excel.mp4

06:05

5. Working with Multiple Worksheets and Opening Files.mp4

08:21

6. Saving Google Sheets and Microsoft Excel Files.mp4

03:44

7. Google Sheets and Microsoft Excel Basics.html

3. Introduction to Worksheet Formulas

1. Introduction to Formulas and Simple Calculations.mp4

10:32

2. Taking Advantage of Relative References.mp4

04:56

3. Absolute References.mp4

09:01

4. Introduction to Spreadsheet Functions SUM Example.mp4

11:30

5. Minimum and Maximum Functions.mp4

03:41

6. Obtaining data from other Worksheets and SUMIF Function.mp4

09:36

7. COUNT and COUNTIF.mp4

05:36

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

03:54

9. Introduction to Worksheet Formulas.html

4. Ebay Analyst Exercise

1. Ebay Analyst Exercise.mp4

03:29

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.mp4

10:12

2. Formatting Dates.mp4

09:59

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

06:38

4. Formatting and Styling Cells.mp4

07:01

5. More on Cell and Text Formatting.mp4

04:48

6. Merging Cells.mp4

07:24

7. Conditional Formatting.mp4

05:32

8. Formatting Menus in Excel.mp4

01:45

9. Quiz - Formatting and Styling Worksheets.html

6. United States Census Exercise

1. United States Census Exercise.mp4

01:48

2. United States Census Exercise Tasks.html

7. Data Management

1. Sorting Data.mp4

08:58

2. Introduction to Filters.mp4

09:45

3. Introduction to Plotting.mp4

10:13

4. Data Validation.mp4

05:24

5. IF and IFERROR.mp4

10:15

6. Understanding Pivot Tables.mp4

12:16

7. Quiz - Data Management.html

8. Airbnb Analyst - Exercise

1. Airbnb Analyst Exercise.mp4

01:03

2. Airbnb Analyst Exercise Tasks.html

9. More on Functions!

1. UNIQUE Function.mp4

10:20

2. VLOOKUP.mp4

09:52

3. INDEX + MATCH.mp4

10:04

4. AND + OR.mp4

04:12

5. Quiz - More on Functions!.html

10. Course Ending

1. Thank you!.mp4

00:53

2. BONUS LECTURE and Other Resources.html

Description

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

What You'll Learn?

Learn how to manipulate spreadsheets using Google Sheets
Use Spreadsheet formulas
Analyze data with Spreadsheets
Do complex calculations using Spreadsheets (mathematical calculations) and aggregate formulas
Learn how VLOOKUPs, RANGE and INDEX Work
Do plots with Spreadsheets
Learn how to Analyze Real Data with Excel
Sorting and Filtering Data

Who is this for?

Aspiring Data Analysts

Financial Analysts

Marketing Analysts

Self Employed People

Basically, everyone that needs to work with spreadsheets and want to learn it from scratch

What You Need to Know?

No prior experience in Spreadsheets Needed

A gmail account to use Google Sheets

More details

Description
Do you feel lost when you pick up spreadsheet software like Microsoft Excel or GoogleÂ Sheets?Â Have you ever seen an advanced Excel user work and wish you could know how those complex formulas work?

Then this course is for you!

Unlock the full potential of spreadsheet tools like Google Sheets and Microsoft Excel with this comprehensive course designed for beginners and intermediate learners alike. From building a strong foundation in spreadsheet basics to diving into advanced data analysis techniques, this course gives you with the skills needed to excel in various professional and personal contexts.

What We'll Learn Together:

Foundations: Dive into spreadsheet essentials, from navigating the interface to creating and formatting tables effortlessly.
Formulas and Functions: Learn the power of formulas and functions to automate calculations and streamline data analysis tasks.
Real-world Applications: Apply your skills to real-world scenarios, such as analyzing eBay sales data and conducting United States Census exercises in the practical exercises.
Data Management: Learn techniques for sorting, filtering, and visualizing data to gain valuable insights and make informed decisions.
Advanced Techniques: Master advanced functions like VLOOKUP, INDEX + MATCH, and pivot tables to take your spreadsheet skills to the next level.
Why Choose Our Course:

Expert Instruction: Benefit from expert-led lectures, practical exercises, and quizzes designed to reinforce your learning.
Hands-on Experience: Gain hands-on experience with practical exercises and real-world case studies, ensuring you're prepared to tackle any spreadsheet challenge.
Flexible Learning: Study at your own pace with our flexible online platform, accessible anytime, anywhere, and on any device.
Career Enhancement: Enhance your resume and professional skill set with in-demand spreadsheet skills sought after by employers across industries.
Who Should Enroll:
Professionals seeking to enhance their data analysis skills.
Students preparing for careers in business, finance, or analytics.
Anyone looking to streamline workflow and improve productivity with spreadsheet tools.
Join Us Today and Master the Art of Spreadsheets!
Enroll now to embark on a journey towards spreadsheet mastery and unlock a world of opportunities in data analysis, decision-making, and beyond. And remember, you can benefit from Udemy 30-day risk free refund policy if the course does not match your expectations.

intro music credits:Â bedtime after a coffee by Barradeen | barradeen Creative Commons Attribution-ShareAlike 3.0
Who this course is for:
Aspiring Data Analysts
Financial Analysts
Marketing Analysts
Self Employed People
Basically, everyone that needs to work with spreadsheets and want to learn it from scratch

User Reviews

Rating

average 0

Total votes0

Focused display

Ivo Bernardo is a professional with a passion for Data Science and Analytics and is currently a Partner at DareData Engineering, a startup that implements machine learning systems all around world for companies of different sizes (from startups to large enterprises). He holds a master Degree in Statistics and Business Intelligence from New University of Lisbon and has been an instructor in several data science academies throughout the years. His main teaching passion is helping beginners or professionals from other industries taking their first leap into the Data Science and Analytics space. Technically he has worked with Python, R, SQL and main cloud providers infrastructure. Feel free to contact him on LinkedIn or via Udemy for potential business ventures or collaborations._________________________________________________________________________Ivo Bernardo é um profissional com grande interesse por Data Science e Analytics. De momento, é Partner da DareData Engineering, uma startup que implementa sistemas de machine learning em todo o mundo para empresas de diferentes tamanhos (desde startups a grandes organizações). É mestre em Estatística e Business Intelligence pela Universidade Nova de Lisboa e participou como instructor em algumas academias data science em Portugal. A sua principal paixão enquanto instrutor é ajudar iniciantes ou profissionais de outras áreas a dar o seu primeiro passo no mundo de Data Science e Analytics. Tecnicamente, trabalha maioritariamente com Python, R, SQL e com a infraestrutura das plataformas cloud mais relevantes do mundo. Pode contactá-lo directamente no LinkedIn ou via Udemy para potenciais colaborações ou outros assuntos relacionados com Data Science.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.