Google Sheets For Teams II - Advanced Features & Formulas For Teams

What you'll learn
Protecting your worksheets from accidental edits or deletions
How the QUERY function helps you sort through big datasets better
Building a user-friendly dashboard that the C-Suite can interact with
Finding optimal inputs for your models with Goal Seek and Solver
Syncing your Google Sheet with another Google Sheet at your company
and more!
Why you should take this class
Google Sheets is an integral part of your team, and you want to figure out ways to make your Google Sheet easier to use for everyone at your company. You'll walk away with skills to improve the user experience of your Google Sheet. The advanced formulas will also help you summarize and analyze data better so that your team can see the data that matters to them.
Google Sheet class file
You'll be using a Google Sheet file I've created for this class. Make a copy of the file here.
Who is this class for?
Advanced users of Google Sheets
You typically are the "project manager" of our team's Google Sheets file
Prerequisites: Understand how to work with common formulas like VLOOKUP and features like conditional formatting
Questions?
Please post your questions in the Discussions page of this class
Other advanced spreadsheet classes you might like
Homepage