Coming Soon!! Google Sheets: Three Formulas to Rule Them All
About Course
Go from a cluttered spreadsheet to a clean report with three powerful formulas.
Have you ever gotten a spreadsheet that’s just overwhelming? Maybe a student roster or some state testing data with dozens of columns you don’t even need? You spend precious time scrolling, copying, and pasting just to get the information you want.
You will learn how to use QUERY(), ARRAYFORMULA() and Array Literals to make your life a whole lot easier!!
Course Content
1 Introduction & The Query Function
-
1.1 The “Why” – Stopping the Copy/Paste Struggle
-
1.2 The “How” – Selecting Columns and Filtering Data
-
1.3 Pro-Tip: Creating Clean Reports on New Tabs
2 Automation with ArrayFormula
3 Robust Sheets with Array Literals
4 Final Challenge & Next Steps
Student Ratings & Reviews
No Review Yet