access
lifetime
content
3 Hours
enrolled
217
Description
Google Spreadsheets is an amazing alternative to Microsoft Excel, and it’s time you joined legions of satisfied Google converts. You’ll find it a valuable tool for compiling, editing, and sharing spreadsheet data, whether you’re drafting charts and graphs, utilizing sorting and filtering tools, or performing any other task.- Use Google Spreadsheets like you do Microsoft Excel w/ 3 hours of content
- Visually represent your data w/ charts & graphs
- Quickly write formulas & create powerful calculations
- Use data tools like sorting, subtotaling & filtering
- Write your own scripts & use Google addons to get more done
- Create charts, tables, graphs & format data
- Automate tasks w/ time-saving scripts & add-ons
Instructor
Justin Mares formerly ran growth at developer-tools company Exceptional (acquired by Rackspace in March of 2013). At Exceptional, he was responsible for growth and revenue across three separate developer tool products. While there, he built and managed an inside sales team, cut churn by more than 60%, tripled organic traffic, improved conversion rates through a series of A/B tests, and doubled average revenue per customer. In this role selling to developers, he also taught himself how to program (poorly), use tools like SQL and R, and familiarized himself with the entire stack of web technologies. Justin is also the co-author of “Traction Book,” a book about how startups can get traction.Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
- Google account
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Introduction
- What we'll cover in this course
- Spreadsheet Basics
- Creating, Renaming and Sharing
- Formatting Basics
- Freezing Rows and Columns
- Conditional Formatting
- Formatting Quiz
- Manipulating Data like a BOSS
- Sorting Data
- Filters and Filter Views
- Find and Replace
- Revision History
- Data Manipulation Quiz!
- Functions and Formulas
- Building Formulas and Functions
- Overview of Formula Types
- List of All Formulas
- Math Functions
- Logical Functions
- Text Functions
- Left and Right
- Find, Replace, Search, Split and Substitute
- Assignment: Creating your own functions
- Functions and Formulas Quiz
- Questions?
- Charts and Graphs
- Introduction to Charts and Graphs
- Different Kinds of Charts
- Creating our First Chart!
- Creating a Scatterplot
- Assignment: Create your own chart!
- Charts and Graphs Quiz
- Advanced Google Spreadsheets
- Note from Justin
- Lookups
- Kinds of Lookups
- Fun with VLOOKUP
- Exercise: Using VLOOKUP
- Answer to VLOOKUP Exercise
- VLOOKUP Additional Resources
- Fun with HLOOKUP
- HLOOKUP Exercise
- Lookups Quiz
- Pulling Data a Spreadsheet with ImportXML and ImportHTML
- Introduction to ImportXML
- ImportXML Syntax
- Importing XML Data into Spreadsheets
- Importing Alexa Data with ImportXML
- ImportXML Resources
- ImportXML Quiz
- Using ImportHTML
- ImportXML and ImportHTML quiz
- Macros
- Introduction to Macros
- Writing our First Macro
- Example: Write Your Own Macro
- Macros Quiz!
- Tools to Use with Google Docs
- Spreadsheet Add-ons
- Using Spreadsheet Booster
- Advanced Spreadsheet Booster
- Resources
- Google Spreadsheet Templates
- Official Google Spreadsheet Resource
- Bonuses
- What did you think of the course? Plus, bonus inside!
access
lifetime
content
3 Hours
enrolled
217