Section 1 : Welcome to Your Google Sheets Course
|
Lecture 1 | Get the Most Out of This Course (Don't Skip) | 00:03:45 Duration |
|
Lecture 2 | INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM | |
|
Lecture 3 | Pre-assessment Quiz (Check your current knowledge) | 00:03:34 Duration |
Section 2 : GOOGLE SHEETS ESSENTIALS
|
Lecture 1 | What You Achieve by the End of Essentials | 00:03:21 Duration |
Section 3 : Getting Started Right with Google Sheets
|
Lecture 1 | Sheets Basics for a Smooth Start | 00:07:15 Duration |
|
Lecture 2 | Cells, Rows & Columns | 00:08:34 Duration |
|
Lecture 3 | Productivity Tips & File Sharing (Pro Tip) | |
|
Lecture 4 | Useful Menu & Toolbar Options | 00:09:47 Duration |
|
Lecture 5 | Language & Spreadsheet Settings (Important) | 00:04:58 Duration |
|
Lecture 6 | Version Recovery & Edit History | 00:03:35 Duration |
|
Lecture 7 | Activity 5 Minute Timer |
Section 4 : Data Entry & Basic Formulas
|
Lecture 1 | Data Entry, Data Types & Autofill in Google Sheets | 00:09:28 Duration |
|
Lecture 2 | Common Formulas in Google Sheets | 00:09:45 Duration |
|
Lecture 3 | Important Functions in Google Sheets (Sum, Count, Counta, CountUnique) | 00:09:47 Duration |
|
Lecture 4 | Relative Vs | 00:06:45 Duration |
|
Lecture 5 | Challenge Find the Mistake! Data Doesn't Add Up! | 00:03:09 Duration |
|
Lecture 6 | Key Takeaways The Basics |
Section 5 : Best Practice & Useful Features
|
Lecture 1 | Useful Features for Report Design | |
|
Lecture 2 | Useful Shortcuts (Pro Tips) | 00:11:48 Duration |
|
Lecture 3 | Conditional Formatting (Steer Attention to What Matters) | 00:09:43 Duration |
|
Lecture 4 | Challenge Conditional Formatting with Checkboxes and Emails | 00:04:04 Duration |
|
Lecture 5 | Data Validation & Drop-down Lists | 00:11:47 Duration |
|
Lecture 6 | Working with Excel & CSV Files (& Importing Data) | 00:09:11 Duration |
|
Lecture 7 | Getting Data from Other Google Sheets (ImportRange) | 00:08:22 Duration |
|
Lecture 8 | Best Practice in Designing Functional Spreadsheets (Pro Tips) | 00:06:56 Duration |
|
Lecture 9 | Key Takeaways Best Practice & Useful Features |
Section 6 : Sorting, Filtering and Cleaning Data
|
Lecture 1 | Sort Feature & What You Shouldn't Do | 00:08:30 Duration |
|
Lecture 2 | Filter & Filter View in Sheets | 00:08:45 Duration |
|
Lecture 3 | Calculations on Filered Results - SubTotal (Pro Tip) | 00:04:45 Duration |
|
Lecture 4 | Challenge Delete Empty Rows in Data | 00:05:13 Duration |
|
Lecture 5 | Split Text, Remove Duplicates and Trim Spaces | 00:05:22 Duration |
|
Lecture 6 | Find & Replace Values (Pro Tip) | 00:09:46 Duration |
|
Lecture 7 | Challenge Which Items Does Each Customer Order | 00:04:30 Duration |
|
Lecture 8 | Key Takeaways Data Cleaning & Management Tools |
Section 7 : Essential Sheets Functions to Analyze & Summarize
|
Lecture 1 | Important How to Properly Read & Understand Functions | 00:08:55 Duration |
|
Lecture 2 | Unique & Sort Functions | 00:08:59 Duration |
|
Lecture 3 | SUM(IFS) by Criteria (also COUNT, AVERAGE, MAX, MIN) | 00:12:23 Duration |
|
Lecture 4 | Challenge Summarize by Criteria & COUNTUNIQUE(IFS) | 00:10:06 Duration |
|
Lecture 5 | Rounding Values (the Right Way) | 00:06:22 Duration |
|
Lecture 6 | Logical & Information Functions (TRUE & FALSE) | 00:08:40 Duration |
|
Lecture 7 | IF Function (IF, Then) | 00:10:27 Duration |
|
Lecture 8 | Nested IF & IFS Functions (Pro Tip) | 00:09:05 Duration |
|
Lecture 9 | Error Types & How to Handle Errors | 00:07:27 Duration |
|
Lecture 10 | Named Ranges (Pro Tip) | 00:06:29 Duration |
|
Lecture 11 | Challenge Average Sales between Selected Dates | 00:07:50 Duration |
|
Lecture 12 | Key Takeaways Essential Functions to Summarize |
Section 8 : Lookup & Filter Functions
|
Lecture 1 | About Proctor Testing | |
|
Lecture 2 | VLOOKUP and HLOOKUP | 00:09:03 Duration |
|
Lecture 3 | Approximate Match Lookup (Replacement for IFS - Pro Tip) | 00:05:41 Duration |
|
Lecture 4 | FILTER Function to Return Multiple Match Results | 00:10:17 Duration |
|
Lecture 5 | Lookup Pictures & Images (Pro Tip) | 00:09:28 Duration |
|
Lecture 6 | SortN for Ranking (account for ties) | 00:08:07 Duration |
|
Lecture 7 | Challenge Find the Mistakes in the Formulas & Correct Them | 00:06:24 Duration |
|
Lecture 8 | Key Takeaways Lookup & Filter Functions |
Section 9 : Text, Date & Time Functions
|
Lecture 1 | Useful & Easy Text Functions | 00:08:17 Duration |
|
Lecture 2 | Search & Substitute Text (Pro Tip) | 00:10:08 Duration |
|
Lecture 3 | Split & Join Values to from Multiple Columns | 00:05:46 Duration |
|
Lecture 4 | Challenge Sort Multiple Words Inside a Cell | 00:03:49 Duration |
|
Lecture 5 | Essential Date Functions | 00:10:27 Duration |
|
Lecture 6 | Time Calculations (Calculating Hours Worked) | 00:06:56 Duration |
|
Lecture 7 | Key Takeaways Useful Text Functions |
Section 10 : Helpful Google Sheet Functions
|
Lecture 1 | Detect Language and Translate Your Spreadsheets | 00:05:43 Duration |
|
Lecture 2 | Image Function (Pro Tip Create QR Codes) | 00:06:40 Duration |
|
Lecture 3 | Import Tables From the Web (IMPORTHTML) | 00:05:24 Duration |
|
Lecture 4 | Import Any Data from the Web (IMPORTXML) | 00:11:38 Duration |
|
Lecture 5 | Stock & Currency Data with GOOGLEFINANCE | 00:09:09 Duration |
|
Lecture 6 | Challenge Did You Invest in the Right Stock | |
|
Lecture 7 | Key Takeaways Google Functions & More Resources |
Section 11 : Collaborate, Publish & Protect
|
Lecture 1 | Sharing Files & Collaboration Tools | |
|
Lecture 2 | Publishing Sheet or Chart (& Embedding in a Web Page) | 00:09:36 Duration |
|
Lecture 3 | Protection Sheet & Cell Level | 00:08:48 Duration |
|
Lecture 4 | Prepare for Print PDF (& Page Breaks) | 00:09:21 Duration |
|
Lecture 5 | Challenge Prepare Proper PDF Layout | |
|
Lecture 6 | Use Google Forms to Collect Data (Pro Tip) | 00:10:39 Duration |
|
Lecture 7 | Key Takeaways Collaborate, Protect & Collect Data |
Section 12 : Charts to Impress
|
Lecture 1 | Chart Basics (Column & Line Charts) | 00:12:26 Duration |
|
Lecture 2 | Aggregating Data in Charts (Bar & Pie Charts) | 00:07:57 Duration |
|
Lecture 3 | Combo (Combination) Charts | 00:04:15 Duration |
|
Lecture 4 | Scrolling Tables & Scorecards (Visualization Tools for Dashboards) | 00:06:36 Duration |
|
Lecture 5 | Gauge Chart (Visualization Tools for Dashboards) | 00:04:11 Duration |
|
Lecture 6 | Add Slicers to Charts | 00:07:44 Duration |
|
Lecture 7 | Challenge Better Dashboards (auto-sorted charts) | 00:11:50 Duration |
|
Lecture 8 | Sparklines to Impress | 00:11:30 Duration |
|
Lecture 9 | Sparklines for Stock & Currency Trends (Pro Tip) | 00:09:39 Duration |
|
Lecture 10 | Key Takeaways Chart Tips |
Section 13 : Explore your Data with Pivot Tables in Google Sheets
|
Lecture 1 | Explore Feature in Google Sheets (Pro Tip) | 00:11:41 Duration |
|
Lecture 2 | Pivot Table Basics in Google Sheets | 00:10:50 Duration |
|
Lecture 3 | Filters & Slicers for Dynamic Pivot Tables | 00:08:20 Duration |
|
Lecture 4 | Pro Tip Grouping Items & Dates (by month, year) | 00:07:16 Duration |
|
Lecture 5 | Custom Formulas in Pivot Tables | 00:08:39 Duration |
|
Lecture 6 | Challenge Master Pivot Tables in Google Sheets | 00:06:10 Duration |
|
Lecture 7 | Key Takeaways Pivot Tables |
Section 14 : Test Your Sheets Essential Knowledge!
|
Lecture 1 | Congratulations! Get Ready for More Practice | 00:01:23 Duration |
|
Lecture 2 | More Challenges & Practice Activities (You need this to pass the quiz) | |
|
Lecture 3 | Challenge Answers & Course Roadmap |
Section 15 : ADVANCED DATA ANALYSIS WITH GOOGLE SHEETS
|
Lecture 1 | Introduction to Advanced Data Analysis | 00:02:10 Duration |
Section 16 : Advanced Functions & Formula Combinations
|
Lecture 1 | INDEX MATCH for Complex Lookups | 00:12:19 Duration |
|
Lecture 2 | Challenge Find the Mistake! INDEX MATCH Problem | 00:06:58 Duration |
|
Lecture 3 | INDEX MATCH with Multiple Headers (Pro Tip) | 00:07:23 Duration |
|
Lecture 4 | Array Formulas ARRAYFORMULA Function | 00:06:29 Duration |
|
Lecture 5 | Create Own Arrays & Append Totals | 00:07:22 Duration |
|
Lecture 6 | INDIRECT Function Lookup from Different Sheets | 00:07:55 Duration |
|
Lecture 7 | Generate Random Data & Text (RANDBETWEEN) | 00:10:39 Duration |
|
Lecture 8 | The Power of SEQUENCE Function (Dynamic Yearly Calendar) | 00:11:28 Duration |
|
Lecture 9 | Key Takeaways Advanced Functions |
Section 17 : The QUERY Function
|
Lecture 1 | QUERY Function Syntax & Important Guidelines | 00:04:27 Duration |
|
Lecture 2 | QUERY Function Example (Select, Where, Order by) | 00:06:55 Duration |
|
Lecture 3 | QUERY Function Aggregation & Calculated Columns | |
|
Lecture 4 | Group by Multiple Columns & Pivot Columns (Query Function) | 00:07:13 Duration |
|
Lecture 5 | QUERY Function with Drop-down List (Dynamic Cell References) | 00:06:30 Duration |
|
Lecture 6 | QUERY Function with Dynamic Totals (Pro Tip) | 00:07:06 Duration |
|
Lecture 7 | Working with Dates & Months in QUERY Function | 00:08:51 Duration |
|
Lecture 8 | Combine Data from Multiple Sheets with QUERY Function | 00:06:31 Duration |
|
Lecture 9 | QUERY Function & IMPORTRANGE to Combine Data from an External File | 00:04:22 Duration |
|
Lecture 10 | Key Takeaways Query Function |
Section 18 : Advanced & Hidden Features
|
Lecture 1 | Custom Number Formatting Explained | 00:12:50 Duration |
|
Lecture 2 | Custom Formatting for Impressive Reports with Symbols (Pro Tip) | 00:08:26 Duration |
|
Lecture 3 | Conditional Formatting with Formulas (The secret to getting it right) | 00:07:46 Duration |
|
Lecture 4 | Challenge Find the Difference Between Two Lists | 00:05:56 Duration |
|
Lecture 5 | Dependent Drop-down Lists in Google Sheets | 00:05:29 Duration |
|
Lecture 6 | Dependent Drop-down for Every Row in Sheets (Pro Tip) | 00:04:42 Duration |
|
Lecture 7 | Challenge Dependent drop-down Lists in Google Sheets | 00:05:40 Duration |
|
Lecture 8 | Key Takeaways Advanced Features |
Section 19 : Introduction to Google Sheets Apps Script, Macros & Add-Ons
|
Lecture 1 | Google Sheets Macros Record your First Macro | 00:07:59 Duration |
|
Lecture 2 | Relative Vs | 00:06:22 Duration |
|
Lecture 3 | Combining Macros in Sheets (Mix Absolute & Relative Reference) | 00:04:52 Duration |
|
Lecture 4 | Challenge Automate Chart Creation with Your Macro | 00:03:52 Duration |
|
Lecture 5 | Reset Data Validation List with Apps Script in Sheets | 00:06:54 Duration |
|
Lecture 6 | Find & Install Add-Ons (Goal Seek example) | 00:09:12 Duration |