Master spreadsheets basics by learning about functions, data visualizations, collaboration and Apps Script.
This is an introductory Google Sheets course for students, professionals, business owners and operators looking to work faster and more efficiently by using spreadsheets and automations.
What you’ll learn
- Navigate Google Sheets Web Interface.
- Basic and Advanced Function Writing.
- Conditional Formatting.
- Charts and Visualization.
- An Introduction to Apps Script Basics.
Course Content
- Introduction –> 4 lectures • 12min.
- Basic Functions and Formulas –> 6 lectures • 16min.
- Formatting –> 3 lectures • 8min.
- Data validation –> 3 lectures • 7min.
- Advanced Functions –> 5 lectures • 17min.
- Data Visualization –> 5 lectures • 20min.
- Google Apps Script –> 3 lectures • 14min.
Requirements
This is an introductory Google Sheets course for students, professionals, business owners and operators looking to work faster and more efficiently by using spreadsheets and automations.
Whether you’re just getting started using spreadsheets for the first time or are coming over from Excel into the Google Sheets’ ecosystem, this is a great intro course to give you a lay of the land.
We’ll cover several topics, including:
- Navigation: how to get where you need to and know where you are
- Toolbar: where things are and the fastest way to get the job done
- Collaboration: how to save and collaborate in real time with co-workers
- Importing Data
- Using basic functions and writing our own custom formulas
- Formatting our data
- Using built-in tables
- Using conditional formatting based on different criteria
- Using dropdown lists and data validation
- Changing column types in tables
- Filtering data with functions
- Using slicers to filter and sort data
- Creating search bars using built-in functions and tools
- Creating data visualizations by using charts: pie, bar and line charts
- An introduction to Google Apps Script
This course will give you a great overview to get started with Google Sheets. I’ve used Sheets professionally for 15+ years and it is extremely capable. Particularly for those who need to collaborate with others quickly and share spreadsheets, Sheets is one of my favorite pieces of software.