Coming Soon!! Advanced Google Sheets Mastery: From Data to Dashboards
About Course
Stop being a spreadsheet user and start being a power user with inter-sheet connectivity and custom reporting.
Ready to take your skills to the next level? This course picks up right where ‘Three Formulas to Rule Them All’ left off. We move beyond simple calculations into the world of IMPORTRANGE(), allowing you to pull data from entirely different files and gradebooks automatically. You will learn to build professional dashboards that summarize class performance and master the ‘where’ and ‘label’ clauses of the QUERY function to create reports that look exactly how you want them. It’s time to let Google Sheets do the heavy lifting for your entire school year
Course Content
1 Deep Dive into QUERY()
-
1.1 The WHERE Clause: Filtering by Multiple Criteria.
-
1.2 ORDER BY: Instantly Organizing Massive Datasets
-
1.3 LABEL: Creating Professional, Non-Technical Reports
-
1.4 Aggregate Functions: Instant Class Averages and Metrics
2 Inter-Sheet Connectivity
3 High-Level Automation
4 Capstone Project: The Student Data Dashboard
Student Ratings & Reviews
No Review Yet