Google Sheets

Google Spreadsheets is rapidly overtaking Microsoft Excel in the workplace.

Engage with this exciting new product and become a Google Sheets expert with this course. Google Sheets replicates many of Excel’s functions but has gone one step further. In this course we cover charts, graphs, pivot tables, functions and formulas as well as discovering what makes Google Sheets unique such as file sharing, revision history, web based scripts, and macros.

If you think Google Sheets is just Excel online then think again.

Highlights

On completing this course, you will have: 

 

  • Learned to adjust the way data and information is displayed 

  • Used advanced tools like Macros, Importing HTML and Scripts to replicate Excel’s functions 

  • Learned how to write powerful formulas quickly and easily with the point-and-click method 

  • Used data tools like sorting, subtotling, and filtering 

  • Learned how to automate tasks with time-saving scripts and add-ons 

  • Discovered Spreadsheets secrets and shortcuts

Preview

Course Content

Course Content

Course Content

User Dashboard

Syllabus Explorer

Course Certificate

Syllabus

Section 1: The Basics

directright

Unit 1.1 - Introduction

Introduce yourself to Google Sheets with a guide of what this course covers

directright

Unit 1.2 - Spreadsheet Basics

Become comfortable with the basic functions and layout of Google Sheets

Section 2: Manipulating Data, Functions, and Formulas

directright

Unit 2.1 - Manipulating Data

Understand how to sort data, manipulate views, find and replace data, and access a spreadsheet’s revision history  

directright

Unit 2.2 - Functions and Formulas

Identify the difference between math functions, logical functions, text functions, and explore the many formulas Google Sheets offers

Section 3: Charts and Graphs

directright

Unit 3.1 - Charts and Graphs

Create and explore charts and Scatterplots

Section 4: Lookups

directright

Unit 4.1 - Lookups

Understand the difference between VLOOKUP and HLOOKUP and how they can improve your spreadsheet manipulation

Section 5: Pulling Data from a Spreadsheet

directright

Unit 5.1 - Using ImportXML

Understand how to access XML files in Google Sheets and how the data is imported

directright

Unit 5.2 - Using ImportHTML

Understand how to access HTML files in Google Sheets and how the data is imported

Section 6: Using Macros and Other Tools

directright

Unit 6.1 - Macros

Write macros that increase productivity

directright

Unit 6.2 - Tools to Use with Google Docs

Discover spreadsheet boosters that help you get the most from Google Sheets

Section 7: Course Ending

directright

Unit 7.1 - Templates and Resources

Access official Google templates and discover other expenses templates, timecards, and more

directright

Unit 7.2 - Conclusion

Conclude what you have learned about Google Sheets

Pricing

Pricing is for 12 months access.

*The AUD price shown above is an estimate. Actual charges are based on the current exchange rate from GBP

Requirements

Software:

  • Required: a Google account

Completion Time: 6 hours (average)

About the Author

Justin Mares

Justin 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 developers tools products - Exceptional, Airbrake and RedisToGo.

While there, he built and managed an inside sales team in Vegas, 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 familiarised himself with the entire stack of web technologies.

He has also founded two other companies, one of which was acquired.

Justin is also the co-author of Traction Book, a book about how startups can get traction. For the book, he interviewed Jimmy Wales (founder of Wikipedia), Paul English (founder of Kayak), Dharmesh Shah (HubSpot founder) and pulled together an actionable framework for how startups should think about getting traction and distribution.