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.
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
Introduce yourself to Google Sheets with a guide of what this course covers
Become comfortable with the basic functions and layout of Google Sheets
Understand how to sort data, manipulate views, find and replace data, and access a spreadsheet’s revision history
Identify the difference between math functions, logical functions, text functions, and explore the many formulas Google Sheets offers
Create and explore charts and Scatterplots
Understand the difference between VLOOKUP and HLOOKUP and how they can improve your spreadsheet manipulation
Understand how to access XML files in Google Sheets and how the data is imported
Understand how to access HTML files in Google Sheets and how the data is imported
Write macros that increase productivity
Discover spreadsheet boosters that help you get the most from Google Sheets
Access official Google templates and discover other expenses templates, timecards, and more
Conclude what you have learned about Google Sheets
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.