Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
20
•
Activities:
0
•
Resources:
113
- 001-Get the Most Out of This Course Don t Skip
- 003-Pre assessment Quiz Check your current knowledge
- 004-What You Achieve by the End of Essentials
- 005-Sheets Basics for a Smooth Start
- 006-Cells Rows Columns
- 007-Productivity Tips File Sharing Pro Tip
- 008-Useful Menu Toolbar Options
- 009-Language Spreadsheet Settings Important
- 010-Version Recovery Edit History
- 013-Data Entry Data Types Autofill in Google Sheets
- 014-Common Formulas in Google Sheets
- 015-Important Functions in Google Sheets Sum Count Counta CountUnique
- 016-Relative Vs Absolute Referencing
- 017-Challenge Find the Mistake Data Doesn t Add Up
- 019-Useful Features for Report Design
- 020-Useful Shortcuts Pro Tips
- 021-Conditional Formatting Steer Attention to What Matters
- 022-Challenge Conditional Formatting with Checkboxes and Emails
- 023-Data Validation Drop down Lists
- 024-Working with Excel CSV Files Importing Data
- 025-Getting Data from Other Google Sheets ImportRange
- 026-Best Practice in Designing Functional Spreadsheets Pro Tips
- 029-Sort Feature What You Shouldn t Do
- 030-Filter Filter View in Sheets
- 031-Calculations on Filtered Results SubTotal Pro Tip
- 032-Challenge Delete Empty Rows in Data
- 033-Split Text Remove Duplicates and Trim Spaces
- 034-Find Replace Values Pro Tip
- 035-Challenge Which Items Does Each Customer Order
- 037-Important How to Properly Read Understand Functions
- 038-Unique Sort Functions
- 039-SUM IFS by Criteria also COUNT AVERAGE MAX MIN
- 040-Challenge Summarize by Criteria COUNTUNIQUE IFS
- 041-Rounding Values the Right Way
- 042-Logical Information Functions TRUE FALSE
- 043-IF Function IF Then
- 044-Nested IF IFS Functions Pro Tip
- 045-Error Types How to Handle Errors
- 046-Named Ranges Pro Tip
- 047-Challenge Average Sales between Selected Dates
- 049-Overview of Helpful Lookup Function
- 050-VLOOKUP and HLOOKU
- 051-Approximate Match Lookup Replacement for IFS Pro Tip
- 052-FILTER Function to Return Multiple Match Results
- 053-Lookup Pictures Images Pro Tip
- 054-SortN for Ranking account for ties
- 055-Challenge Find the Mistakes in the Formulas Correct Them
- 057-Useful Easy Text Functions
- 058-Search Substitute Text Pro Tip
- 059-Split Join Values to from Multiple Columns
- 060-Challenge Sort Multiple Words Inside a Cell
- 061-Essential Date Functions
- 062-Time Calculations Calculating Hours Worked
- 065-Detect Language and Translate Your Spreadsheets
- 066-Image Function Pro Tip Create QR Codes
- 067-Import Tables From the Web IMPORTHTML
- 068-Import Any Data from the Web IMPORTXML
- 069-Stock Currency Data with GOOGLEFINANCE
- 070-Challenge Did You Invest in the Right Stock
- 072-Sharing Files Collaboration Tools
- 073-Publishing Sheet or Chart Embedding in a Web Page
- 074-Protection Sheet Cell Level
- 075-Prepare for Print PDF Page Breaks
- 077-Use Google Forms to Collect Data Pro Tip
- 079-Chart Basics Column Line Charts
- 080-Aggregating Data in Charts Bar Pie Charts
- 081-Combo Combination Charts
- 082-Scrolling Tables Scorecards Visualization Tools for Dashboards
- 083-Gauge Chart Visualization Tools for Dashboards
- 084-Add Slicers to Charts
- 085-Challenge Better Dashboards auto sorted charts
- 086-Sparklines to Impress
- 087-Sparklines for Stock Currency Trends Pro Tip
- 089-Explore Feature in Google Sheets Pro Tip
- 090-Pivot Table Basics in Google Sheets
- 091-Filters Slicers for Dynamic Pivot Tables
- 092-Pro Tip Grouping Items Dates by month year
- 093-Custom Formulas in Pivot Tables
- 094-Challenge Master Pivot Tables in Google Sheets
- 096-Congratulations Get Ready for More Practice
- 100-Introduction to Advanced Data Analysis
- 101-INDEX MATCH for Complex Lookups
- 102-Challenge Find the Mistake INDEX MATCH Problem
- 103-INDEX MATCH with Multiple Headers Pro Tip
- 104-Array Formulas ARRAYFORMULA Function
- 105-Create Own Arrays Append Totals
- 106-INDIRECT Function Lookup from Different Sheets
- 107-Generate Random Data Text RANDBETWEEN
- 108-The Power of SEQUENCE Function Dynamic Yearly Calendar
- 110-QUERY Function Syntax Important Guidelines
- 111-QUERY Function Example Select Where Order by
- 12-QUERY Function Aggregation Calculated Columns
- 113-Group by Multiple Columns Pivot Columns Query Function
- 114-QUERY Function with Drop down List Dynamic Cell References
- 115-QUERY Function with Dynamic Totals Pro Tip
- 116-Working with Dates Months in QUERY Function
- 117-Combine Data from Multiple Sheets with QUERY Function
- 118-QUERY Function IMPORTRANGE to Combine Data from an External File
- 121-Custom Number Formatting Explained
- 122-Custom Formatting for Impressive Reports with Symbols Pro Tip
- 123-Conditional Formatting with Formulas The secret to getting it right
- 124-Challenge Find the Difference Between Two Lists
- 125-Dependent Drop down Lists in Google Sheets
- 126-Dependent Drop down for Every Row in Sheets Pro Tip
- 121-Custom Number Formatting Explained
- 129-Google Sheets Macros Record your First Macro
- 130-Relative Vs Absolute Macro Recording Practical Example
- 131-Combining Macros in Sheets Mix Absolute Relative Reference
- 132-Challenge Automate Chart Creation with Your Macro
- 133-Reset Data Validation List with Apps Script in Sheets
- 134-Find Install Add Ons Goal Seek example
- 136-Extras The Mechanics of the Quiz
- 137-Final Words