Section 1 : Welcome to Your Google Sheets Course

Lecture 1 Get the Most Out of This Course (Don't Skip) 3:45
Lecture 2 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 3 Pre-assessment Quiz (Check your current knowledge) 3:34

Section 2 : GOOGLE SHEETS ESSENTIALS

Lecture 4 What You Achieve by the End of Essentials 3:21

Section 3 : Getting Started Right with Google Sheets

Lecture 5 Sheets Basics for a Smooth Start 7:15
Lecture 6 Cells, Rows & Columns 8:34
Lecture 7 Productivity Tips & File Sharing (Pro Tip)
Lecture 8 Useful Menu & Toolbar Options 9:47
Lecture 9 Language & Spreadsheet Settings (Important) 4:58
Lecture 10 Version Recovery & Edit History 3:35
Lecture 11 Activity 5 Minute Timer Text

Section 4 : Data Entry & Basic Formulas

Lecture 12 Data Entry, Data Types & Autofill in Google Sheets 9:28
Lecture 13 Common Formulas in Google Sheets 9:45
Lecture 14 Important Functions in Google Sheets (Sum, Count, Counta, CountUnique) 9:47
Lecture 15 Relative Vs 6:45
Lecture 16 Challenge Find the Mistake! Data Doesn't Add Up! 3:9
Lecture 17 Key Takeaways The Basics Text

Section 5 : Best Practice & Useful Features

Lecture 18 Useful Features for Report Design
Lecture 19 Useful Shortcuts (Pro Tips) 11:48
Lecture 20 Conditional Formatting (Steer Attention to What Matters) 9:43
Lecture 21 Challenge Conditional Formatting with Checkboxes and Emails 4:4
Lecture 22 Data Validation & Drop-down Lists 11:47
Lecture 23 Working with Excel & CSV Files (& Importing Data) 9:11
Lecture 24 Getting Data from Other Google Sheets (ImportRange) 8:22
Lecture 25 Best Practice in Designing Functional Spreadsheets (Pro Tips) 6:56
Lecture 26 Key Takeaways Best Practice & Useful Features Text

Section 6 : Sorting, Filtering and Cleaning Data

Lecture 27 Sort Feature & What You Shouldn't Do 8:30
Lecture 28 Filter & Filter View in Sheets 8:45
Lecture 29 Calculations on Filered Results - SubTotal (Pro Tip) 4:45
Lecture 30 Challenge Delete Empty Rows in Data 5:13
Lecture 31 Split Text, Remove Duplicates and Trim Spaces 5:22
Lecture 32 Find & Replace Values (Pro Tip) 9:46
Lecture 33 Challenge Which Items Does Each Customer Order 4:30
Lecture 34 Key Takeaways Data Cleaning & Management Tools Text

Section 7 : Essential Sheets Functions to Analyze & Summarize

Lecture 35 Important How to Properly Read & Understand Functions 8:55
Lecture 36 Unique & Sort Functions 8:59
Lecture 37 SUM(IFS) by Criteria (also COUNT, AVERAGE, MAX, MIN) 12:23
Lecture 38 Challenge Summarize by Criteria & COUNTUNIQUE(IFS) 10:6
Lecture 39 Rounding Values (the Right Way) 6:22
Lecture 40 Logical & Information Functions (TRUE & FALSE) 8:40
Lecture 41 IF Function (IF, Then) 10:27
Lecture 42 Nested IF & IFS Functions (Pro Tip) 9:5
Lecture 43 Error Types & How to Handle Errors 7:27
Lecture 44 Named Ranges (Pro Tip) 6:29
Lecture 45 Challenge Average Sales between Selected Dates 7:50
Lecture 46 Key Takeaways Essential Functions to Summarize Text

Section 8 : Lookup & Filter Functions

Lecture 47 About Proctor Testing Pdf
Lecture 48 VLOOKUP and HLOOKUP 9:3
Lecture 49 Approximate Match Lookup (Replacement for IFS - Pro Tip) 5:41
Lecture 50 FILTER Function to Return Multiple Match Results 10:17
Lecture 51 Lookup Pictures & Images (Pro Tip) 9:28
Lecture 52 SortN for Ranking (account for ties) 8:7
Lecture 53 Challenge Find the Mistakes in the Formulas & Correct Them 6:24
Lecture 54 Key Takeaways Lookup & Filter Functions Text

Section 9 : Text, Date & Time Functions

Lecture 55 Useful & Easy Text Functions 8:17
Lecture 56 Search & Substitute Text (Pro Tip) 10:8
Lecture 57 Split & Join Values to from Multiple Columns 5:46
Lecture 58 Challenge Sort Multiple Words Inside a Cell 3:49
Lecture 59 Essential Date Functions 10:27
Lecture 60 Time Calculations (Calculating Hours Worked) 6:56
Lecture 61 Key Takeaways Useful Text Functions Text

Section 10 : Helpful Google Sheet Functions

Lecture 62 Detect Language and Translate Your Spreadsheets 5:43
Lecture 63 Image Function (Pro Tip Create QR Codes) 6:40
Lecture 64 Import Tables From the Web (IMPORTHTML) 5:24
Lecture 65 Import Any Data from the Web (IMPORTXML) 11:38
Lecture 66 Stock & Currency Data with GOOGLEFINANCE 9:9
Lecture 67 Challenge Did You Invest in the Right Stock
Lecture 68 Key Takeaways Google Functions & More Resources Text

Section 11 : Collaborate, Publish & Protect

Lecture 69 Sharing Files & Collaboration Tools
Lecture 70 Publishing Sheet or Chart (& Embedding in a Web Page) 9:36
Lecture 71 Protection Sheet & Cell Level 8:48
Lecture 72 Prepare for Print PDF (& Page Breaks) 9:21
Lecture 73 Challenge Prepare Proper PDF Layout Text
Lecture 74 Use Google Forms to Collect Data (Pro Tip) 10:39
Lecture 75 Key Takeaways Collaborate, Protect & Collect Data Text

Section 12 : Charts to Impress

Lecture 76 Chart Basics (Column & Line Charts) 12:26
Lecture 77 Aggregating Data in Charts (Bar & Pie Charts) 7:57
Lecture 78 Combo (Combination) Charts 4:15
Lecture 79 Scrolling Tables & Scorecards (Visualization Tools for Dashboards) 6:36
Lecture 80 Gauge Chart (Visualization Tools for Dashboards) 4:11
Lecture 81 Add Slicers to Charts 7:44
Lecture 82 Challenge Better Dashboards (auto-sorted charts) 11:50
Lecture 83 Sparklines to Impress 11:30
Lecture 84 Sparklines for Stock & Currency Trends (Pro Tip) 9:39
Lecture 85 Key Takeaways Chart Tips Text

Section 13 : Explore your Data with Pivot Tables in Google Sheets

Lecture 86 Explore Feature in Google Sheets (Pro Tip) 11:41
Lecture 87 Pivot Table Basics in Google Sheets 10:50
Lecture 88 Filters & Slicers for Dynamic Pivot Tables 8:20
Lecture 89 Pro Tip Grouping Items & Dates (by month, year) 7:16
Lecture 90 Custom Formulas in Pivot Tables 8:39
Lecture 91 Challenge Master Pivot Tables in Google Sheets 6:10
Lecture 92 Key Takeaways Pivot Tables Text

Section 14 : Test Your Sheets Essential Knowledge!

Lecture 93 Congratulations! Get Ready for More Practice 1:23
Lecture 94 More Challenges & Practice Activities (You need this to pass the quiz) Text
Lecture 95 Challenge Answers & Course Roadmap Text

Section 15 : ADVANCED DATA ANALYSIS WITH GOOGLE SHEETS

Lecture 96 Introduction to Advanced Data Analysis 2:10

Section 16 : Advanced Functions & Formula Combinations

Lecture 97 INDEX MATCH for Complex Lookups 12:19
Lecture 98 Challenge Find the Mistake! INDEX MATCH Problem 6:58
Lecture 99 INDEX MATCH with Multiple Headers (Pro Tip) 7:23
Lecture 100 Array Formulas ARRAYFORMULA Function 6:29
Lecture 101 Create Own Arrays & Append Totals 7:22
Lecture 102 INDIRECT Function Lookup from Different Sheets 7:55
Lecture 103 Generate Random Data & Text (RANDBETWEEN) 10:39
Lecture 104 The Power of SEQUENCE Function (Dynamic Yearly Calendar) 11:28
Lecture 105 Key Takeaways Advanced Functions Text

Section 17 : The QUERY Function

Lecture 106 QUERY Function Syntax & Important Guidelines 4:27
Lecture 107 QUERY Function Example (Select, Where, Order by) 6:55
Lecture 108 QUERY Function Aggregation & Calculated Columns
Lecture 109 Group by Multiple Columns & Pivot Columns (Query Function) 7:13
Lecture 110 QUERY Function with Drop-down List (Dynamic Cell References) 6:30
Lecture 111 QUERY Function with Dynamic Totals (Pro Tip) 7:6
Lecture 112 Working with Dates & Months in QUERY Function 8:51
Lecture 113 Combine Data from Multiple Sheets with QUERY Function 6:31
Lecture 114 QUERY Function & IMPORTRANGE to Combine Data from an External File 4:22
Lecture 115 Key Takeaways Query Function Text

Section 18 : Advanced & Hidden Features

Lecture 116 Custom Number Formatting Explained 12:50
Lecture 117 Custom Formatting for Impressive Reports with Symbols (Pro Tip) 8:26
Lecture 118 Conditional Formatting with Formulas (The secret to getting it right) 7:46
Lecture 119 Challenge Find the Difference Between Two Lists 5:56
Lecture 120 Dependent Drop-down Lists in Google Sheets 5:29
Lecture 121 Dependent Drop-down for Every Row in Sheets (Pro Tip) 4:42
Lecture 122 Challenge Dependent drop-down Lists in Google Sheets 5:40
Lecture 123 Key Takeaways Advanced Features Text

Section 19 : Introduction to Google Sheets Apps Script, Macros & Add-Ons

Lecture 124 Google Sheets Macros Record your First Macro 7:59
Lecture 125 Relative Vs 6:22
Lecture 126 Combining Macros in Sheets (Mix Absolute & Relative Reference) 4:52
Lecture 127 Challenge Automate Chart Creation with Your Macro 3:52
Lecture 128 Reset Data Validation List with Apps Script in Sheets 6:54
Lecture 129 Find & Install Add-Ons (Goal Seek example) 9:12