Data Analysis with Google Sheets

About the Course

Have you ever wondered about the relationship between Google and Microsoft’s stock price? Or how much will an extra square foot increase the value of your house?

Welcome to Data Analysis with Google Sheets! In this course, you will learn how to utilize Google Sheets to effectively manage and analyze data for business, research, and personal projects. In today's data-driven world, businesses require professionals with the necessary skills to handle, analyze and visualize data, and this course is an excellent starting point for anyone looking to build a career in data analysis.

Throughout the course, you will gain valuable skills in data organization, manipulation, and visualization using various features in Google Sheets. You will learn how to use formulas, functions (such as sorting, filtering, and pivot tables), and create charts to obtain insightful data presentations that can aid in decision-making processes. You will be introduced to key statistical concepts, such as correlation and linear regression.

The course contains practical exercises and case studies, allowing you to apply the knowledge gained to real-world scenarios. Analysis includes stock prices, tax models, home price prediction, Wordle strategy and more.

By the end of this course, you will have the skills and knowledge to analyze data sets and generate meaningful insights. Join us today and take your data analysis skills to the next level!

Who should take this course?

This course is ideal for those who seek to establish a career in data analysis (such as pre-MBA students), as well as for professionals who wish to enhance their skills in this field.

Course Duration:

The course is self-paced and it takes between 15-20 hours to complete including watching the videos, and working on the knowledge checks, exercises and case studies.

Course Support:

There is a community page where you can ask questions, share your ideas and knowledge, and connect with other students and the staff.

Prerequisites:

Gmail account
Basic math knowledge, such as percentages, exponentials, averages, and square roots
Thirst for knowledge

*Courses can be conducted live online or in person upon request. For more information send an email ([email protected])!

Course Curriculum

1. Welcome
2. Course Structure
3. ScholarU Community
4. Project Introduction
5. About You Survey
1. Introduction to Spreadsheets
2. Anatomy of a Spreadsheet
  FREE PREVIEW
3. Getting Started with a Blank Spreadsheet
  FREE PREVIEW
4. Check: Rename a Spreadsheet
  FREE PREVIEW
5. Navigating Around the Spreadsheet
  FREE PREVIEW
6. Check: Cell Name
7. Formatting Columns, Rows and Cells
8. Course Content
9. Copying Course Content
10. Opening Files
11. Exercise: Spreadsheet Basics
1. Introduction to Different Data Types
2. Format Dates, Currency and Decimals
3. Check: Percentage
4. Check: Left Justified
5. Undo, Redo and Keyboard Shortcuts
6. Google Sheets Keyboard Shortcuts
7. Check: Undo
8. Check: Shortcut Keys
9. Number Data Type
10. Check: Scientific Notation
11. Exercise: Data Type Basics
12. Exercise: Data Type Basics Part 2
1. Introduction to Equations
2. Check: Addition
3. Order of Operations
4. Check: Order of Operations
5. Renaming Cells
6. Check: Renaming Cells
7. Circular References
8. Check: Circular References
9. Decimals
10. Check: Decimals
11. Exercise: Equations
1. Introduction to Functions
2. Check: Ranges
3. Common Functions
4. Check: Common Functions
5. Nested Functions
6. Check: Nested Functions
7. Random Operations
8. Check: Random Operations
9. Customize Functions
10. Check: Customize Functions
11. Exercise: Functions
12. Exercise: Function Documentation
1. Sheet Basics
2. Exercise: Sheets
1. Saving and Versioning
2. Exercise: Saving and Versioning
1. Cut, Copy and Paste
2. Copying Patterns
3. Check: Patterns
4. Exercise: Simple Copying
1. Relative Reference
2. Check: Relative Reference
3. Absolute Reference
4. Check: Absolute Reference
5. Exercise: Cell Referencing
6. Exercise: Cell Referencing Part 2
1. Date Data Type
2. Date Functions
3. Check: DateDif
4. Boolean Data Type
5. Check: IsText
6. If Functions
7. Check: CountIf
8. Truth Table and Checkboxes
9. Check: And, Or, Not Part 1
10. Check: And, Or, Not Part 2
11. Exercise: Advanced Data Types - Dates and Booleans Part 1
12. Exercise: Advanced Data Types - Dates and Booleans Part 2
13. Exercise: Advanced Data Types - Dates and Booleans Part 3
1. Text Functions
2. Check: Text
3. Exact, Find, Search and Replace
4. Check: Replace
5. Concatenate and Split
6. Check: Split
7. Data Validation, Dropdown and Links
8. Check: Data Validation
9. Exercise: Text
1. VLOOKUP and HLOOKUP
2. Check: VLOOKUP
3. Index and Match
4. Check: Index and Match
5. XLOOKUP
6. Check: XLOOKUP
7. Check: XLOOKUP 2
8. Exercise: LOOKUP Functions
1. Text and Cells
2. Check: Text and Cells
3. Merging Cells, Gridlines and Formula Bar
4. Column and Row Views
5. Check: Column and Row Views
6. Insert Images and Drawings
7. Tables Alternating Colors
8. Exercise: Formatting
1. Conditional Formatting
2. Check: Conditional Formatting
3. Custom Conditional Format
4. Check: Custom Conditional Formatting
5. Heat Maps
6. Exercise: Conditional Formatting
1. Filter Function
2. Check: Filter Function
3. Sort Function
4. Check: Sort Function
5. Table Sort and Filter
6. Slicers
7. Exercise: Sort and Filter
8. Check In
1. Introduction to Charts
2. Check: Type of Charts
3. Chart Style
4. Chart and Axis Title
5. Series
6. Legend
7. Axis and Gridlines
8. Maps
9. Sparklines
10. Check: Sparklines
11. Exercise: Charts
1. Themes
2. Color Blind Friendly Color Palettes
3. Exercise: Themes
1. Motivation
2. Pivot Tables
3. Customizing Values
4. Check: Pivot Tables
5. Filters
6. Exercise: Pivot Tables
1. Notes and Comments
2. Share, Email and Download
3. Print
4. Paste Special
5. Protected Sheets and Cells
6. Check: Collaboration and Sharing
7. Exercise: Collaboration and Sharing
1. Duplicates Part 1
2. Duplicates Part 2
3. Check: Duplicates
4. Missing Data
5. Check: Missing Data
6. Text Cleanup
7. Incorrectly Formatted or Corrupted Data
8. Clear Column Names
9. Drop Unnecessary Columns
10. Sanity Checks
11. Descriptive Values
12. Exercise: Cleaning Data
1. Error Messages
2. Error Functions
3. Check: Debugging
4. Exercise: Debugging
1. Macros
2. Add-Ons
3. Forms
4. Check: Repetitive Tasks
5. Exercise: Advanced Tools
6. Exercise: Advanced Tools Part 2
1. Work with Copies or Versions
2. Features in Columns / Observations in Rows
3. Readable Equations
4. Avoid Overwriting
5. Sanity Checks
6. Format the Spreadsheet
7. Hiding Data
8. Highlight Editable and Protect Uneditable Cells
9. Accessibility Colors for Colorblind and Grayscale Printing
10. Functional Over Efficiency
1. Correlation Theory Part 1
2. Correlation Theory Part 2
3. Correlation Theory Part 3
4. Correlation Theory Part 4
5. Check: Correlation
6. Correlation Demo
7. Exercise: Correlation
8. Exercise: Correlation
1. Linear Regression Theory Part 1
2. Check: Linear Regression
3. Linear Regression Theory Part 2
4. Linear Regression Theory Part 3
5. Linear Regression Theory Part 4
6. Linear Regression Theory Part 5
7. Linear Regression Practice Part 1
8. Linear Regression Practice Part 2
9. Linear Regression Practice Part 3
10. Linear Regression Practice Part 4
11. Linear Regression Practice Part 5
12. Linear Regression Practice Part 6
13. Exercise: Linear Regression
14. Exercise: Linear Regression Part 1
15. Exercise: Linear Regression Part 2
16. Exercise: Linear Regression Part 3
17. Exercise: Linear Regression Part 4
1. Case Study: Predicting Home Prices
2. Predicting Home Prices Introduction
3. Predicting Home Prices Solution Part 1
4. Predicting Home Prices Solution Part 2
5. Observations
6. Predicting Home Prices Solution Part 3
7. Predicting Home Price Solution Part 4
8. Predicting Home Prices Solution Part 5
1. Case Study: Wordle
2. Wordle Introduction
3. Wordle Solution Part 1
4. Wordle Solution Part 2
5. Wordle Solution Part 3
6. Wordle Solution Part 4
7. Wordle Solution Part 5
8. Wordle Solution Part 6
1. Case Study: Tax Calculator
2. Tax Calculator Introduction
3. Tax Calculator Solution Part 1
4. Tax Calculator Solution Part 2
5. Tax Calculator Solution Part 3
6. Tax Calculator Solution Part 4
7. Tax Calculator Solution Part 5
8. Tax Calculator Solution Part 6
9. Tax Calculator Solution Part 7
1. Case Study: S&P500
2. S&P500 Introduction
3. S&P500 Solution Part 1
4. S&P500 Solution Part 2
5. S&P500 Solution Part 3
1. Assessment Explanation
2. Assessment
1. Final Note
2. End of Course Survey

About this course

$349.00
15-20 hrs

Testimonials

“…wanted to reach out to let you know how helpful I found this course. I have been using Excel/Google sheets for some time and this course helped me delve deeper and I very much enjoyed the format, very hands on…”

Ernesto G. - BU Questrom School of Business Student

Discover your potential, starting today

Buy now!