Spreadsheets for Beginners using Google Sheets
This 2-hour project-based course will teach you how to use spreadsheets. In this project, they will be utilizing Google Sheets, which is a free spreadsheet tool from Google. That being said, the majority of the ideas you'll learn in this project will transfer to other spreadsheet applications like Microsoft Excel.
The following principles will be covered in a hands-on manner:
- Data input, formatting, and computations on a basic level
- Absolute and relative cell references
- Concatenate, divide, sum, average, median, min, max, count, counta are all basic operations.
- Advanced functions: vlookup, if, and, or, iferror, countif, countifs, averageif, averageifs, sumif, sumifs, totalif, totalifs, totalifs, totalifs, totalifs, totalifs, totalifs, totalifs, totalifs, totalifs, totalifs, totalifs,
- Handling error messages
- Formatting that is conditional
- Basic charts to show data - Filtering and sorting
They will finish the assignment by putting these ideas into practice and creating a rudimentary spreadsheet model to assist us in analyzing home spending.
Note: If you don't already have a Google account, you'll have to establish one in order to finish the material.
THE SKILLS YOU WILL DEVELOP
- Spreadsheet
- Business essentials
- Google Sheets
- Data Analysis
- Data Visualization (DataViz)
LEARN STEP BY STEP:
- The Basics - Basic data entry, formatting and calculations
- Cell References - Relative and absolute cell references
- 9 Basic functions
- Dealing with error messages
- 11 Advanced functions
- Formatting, conditional formatting, sorting and filtering
- Building expense model
- Basic charts to visualize data
Rating: 4.7/5
Enroll here: coursera.org/projects/spreadsheets-beginner-google-sheets
