Spreadsheets 101

What you'll learn
Learn what spreadsheets are and what they can do
See examples of spreadsheets in everyday life
Build a spreadsheet on your own with step-by-step instructions
Format then add two formulas to your spreadsheet
Requirements
This course is for beginners - NO PRIOR KNOWLEDGE REQUIRED
Description
Spreadsheets can be used in all aspects of life, NOT just in business or for work. Learn what spreadsheets are, what they do and how to build one for yourself using the step by step instructions and videos. This course will change how you view spreadsheet software.The simple spreadsheet is one of the most powerful data analysis tools that exists, and it's available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have the know-how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Spreadsheet software is one of the most popular and powerful tools in data analysis. Millions of people use tools like Google Sheets on a daily basis. Even the most experienced data scientists often started their careers with spreadsheets and still use it to test assumptions or to look at data for the first time. In this course, you will learn the basics of spreadsheets by working with rows, columns, addresses, and ranges. You will create your own formulas and learn how to use references.Through short, easy-to-follow demonstrations, you'll learn how to use Google Sheets. No experience with Google Sheets is required.
Overview
Section 1: Course Overview
Lecture 1 Course Expectations
Lecture 2 Spreadsheet Software
Section 2: Introduction to Spreadsheets
Lecture 3 Working Definition - "What is a Spreadsheet?"
Lecture 4 "Why do we use spreadsheets?"
Lecture 5 Spreadsheet Myths
Lecture 6 Examples of Spreadsheet use in everyday life
Section 3: Spreadsheet Navigation
Lecture 7 Opening Google Sheets - Lecture
Lecture 8 Opening Google Sheets - Video
Lecture 9 Ribbon (Menu) Options - Lecture
Lecture 10 Ribbon (Menu) Options - Video
Lecture 11 Spreadsheet Navigation - Lecture
Lecture 12 Spreadsheet Navigation - Video
Section 4: Hands-on Learning Scenario
Lecture 13 Review the Learning Scenario
Lecture 14 Provide a name for the spreadsheet - Lecture
Lecture 15 Provide a name for the spreadsheet - Video
Lecture 16 Provide a name for the spreadsheet tab - Instruction
Lecture 17 Provide a name for the spreadsheet tab - Video
Lecture 18 Create Headline & Build Spreadsheet Structure - Instruction
Lecture 19 Create Headline & Build Spreadsheet Structure - Video
Section 5: Formatting the Spreadsheet
Lecture 20 Add formatting elements to the spreadsheet - Instruction
Lecture 21 Add formatting elements to the spreadsheet - Video
Lecture 22 Additional Formatting Tasks - Instruction
Lecture 23 Additional Formatting Tasks - Video
Section 6: Working with Formulas
Lecture 24 Formula #1 - Calculate the Subtotal for each line item - Instruction
Lecture 25 Formula #1 - Calculate the Subtotal for each line item - Video
Lecture 26 Formula #2 - Calculate the total cost - Instruction
Lecture 27 Formula #2 - Calculate the total cost - Video
Section 7: Input sample data then finalize the spreadsheet
Lecture 28 Sample Data Input & Finalize - Lecture
Lecture 29 Sample Data Input & Finalize - Video
Lecture 30 CONGRATULATIONS!
Beginners or those who would like a refresher


Homepage