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