Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
1
•
Activities:
1
•
Resources:
112
- Announcements
- 001 Get the Most Out of This Course Don t Skip K2FE gitir
- 003 Pre assessment Quiz Check your current knowledge i8dO gitir
- 004 What You Achieve by the End of Essentials eLdB gitir
- 005 Sheets Basics for a Smooth Start E6bL gitir
- 006 Cells Rows Columns HvDm gitir
- 007 Productivity Tips File Sharing Pro Tip XWSy gitir
- 008 Useful Menu Toolbar Options djN6 gitir
- 009 Language Spreadsheet Settings Important ZZ92 gitir
- 010 Version Recovery Edit History gHyT gitir
- 013 Data Entry Data Types Autofill in Google Sheets rLbj gitir
- 014 Common Formulas in Google Sheets LNMy gitir
- 015 Important Functions in Google Sheets Sum Count Counta CountUnique Af1d gitir
- 016 Relative Vs Absolute Referencing kYRv gitir
- 017 Challenge Find the Mistake Data Doesn t Add Up mMzE gitir
- 019 Useful Features for Report Design 37fC gitir
- 020 Useful Shortcuts Pro Tips a9Hx gitir
- 021 Conditional Formatting Steer Attention to What Matters WHr4 gitir
- 022 Challenge Conditional Formatting with Checkboxes and Emails p0FT gitir
- 023 Data Validation Drop down Lists oWBk gitir
- 024 Working with Excel CSV Files Importing Data WOdD gitir
- 025 Getting Data from Other Google Sheets ImportRange U54o gitir
- 026 Best Practice in Designing Functional Spreadsheets Pro Tips 3xdB gitir
- 029 Sort Feature What You Shouldn t Do N6GV gitir
- 030 Filter Filter View in Sheets Fisy gitir
- 031 Calculations on Filtered Results SubTotal Pro Tip vCck gitir
- 032 Challenge Delete Empty Rows in Data X0dP gitir
- 033 Split Text Remove Duplicates and Trim Spaces rhyr gitir
- 034 Find Replace Values Pro Tip vq7S gitir
- 035 Challenge Which Items Does Each Customer Order RqoI gitir
- 037 Important How to Properly Read Understand Functions M0Cg gitir
- 038 Unique Sort Functions aXPV gitir
- 039 SUM IFS by Criteria also COUNT AVERAGE MAX MIN e2og gitir
- 040 Challenge Summarize by Criteria COUNTUNIQUE IFS gxxy gitir
- 041 Rounding Values the Right Way YMBK gitir
- 042 Logical Information Functions TRUE FALSE RyVo gitir
- 043 IF Function IF Then HbPR gitir
- 044 Nested IF IFS Functions Pro Tip wX89 gitir
- 045 Error Types How to Handle Errors qjqP gitir
- 046 Named Ranges Pro Tip UMuf gitir
- 047 Challenge Average Sales between Selected Dates OKGs gitir
- 049 Overview of Helpful Lookup Functions cbIS gitir
- 050 VLOOKUP and HLOOKUP rjbr gitir
- 051 Approximate Match Lookup Replacement for IFS Pro Tip WOUH gitir
- 052 FILTER Function to Return Multiple Match Results JuzX gitir
- 053 Lookup Pictures Images Pro Tip X3ig gitir
- 054 SortN for Ranking account for ties DMQC gitir
- 055 Challenge Find the Mistakes in the Formulas Correct Them KnWA gitir
- 058 Useful Easy Text Functions keb3 gitir
- 059 Search Substitute Text Pro Tip kYyh gitir
- 060 Split Join Values to from Multiple Columns vHN1 gitir
- 061 Challenge Sort Multiple Words Inside a Cell u55N gitir
- 062 Essential Date Functions pNri gitir
- 063 Time Calculations Calculating Hours Worked Tc31 gitir
- 066 Detect Language and Translate Your Spreadsheets fd4R gitir
- 067 Image Function Pro Tip Create QR Codes tM5J gitir
- 068 Import Tables From the Web IMPORTHTML j7lO gitir
- 069 Import Any Data from the Web IMPORTXML 1jyh gitir
- 070 Stock Currency Data with GOOGLEFINANCE rfii gitir
- 071 Challenge Did You Invest in the Right Stock LsK9 gitir
- 073 Sharing Files Collaboration Tools 1EtZ gitir
- 074 Publishing Sheet or Chart Embedding in a Web Page VjM2 gitir
- 075 Protection Sheet Cell Level o76n gitir
- 076 Prepare for Print PDF Page Breaks KpaD gitir
- 078 Use Google Forms to Collect Data Pro Tip jwCs gitir
- 080 Chart Basics Column Line Charts ugV5 gitir
- 081 Aggregating Data in Charts Bar Pie Charts MHXR gitir
- 082 Combo Combination Charts qMqg gitir
- 083 Scrolling Tables Scorecards Visualization Tools for Dashboards 67Qz gitir
- 084 Gauge Chart Visualization Tools for Dashboards Z9s2 gitir
- 085 Add Slicers to Charts pMSO gitir
- 086 Challenge Better Dashboards auto sorted charts Uxoq gitir
- 087 Sparklines to Impress rbHN gitir
- 088 Sparklines for Stock Currency Trends Pro Tip fPvP gitir
- 090 Pivot Table Basics in Google Sheets dr4u gitir
- 091 Filters Slicers for Dynamic Pivot Tables ahfk gitir
- 092 Pro Tip Grouping Items Dates by month year tec0 gitir
- 093 Custom Formulas in Pivot Tables oqdZ gitir
- 094 Challenge Master Pivot Tables in Google Sheets KhF2 gitir
- 096 Congratulations Get Ready for More Practice LIDD gitir
- 100 Introduction to Advanced Data Analysis HNTF gitir
- 101 INDEX MATCH for Complex Lookups bAS0 gitir
- 102 Challenge Find the Mistake INDEX MATCH Problem oDXR gitir
- 103 INDEX MATCH with Multiple Headers Pro Tip NTIP gitir
- 104 Array Formulas ARRAYFORMULA Function IeFn gitir
- 105 Create Own Arrays Append Totals XksG gitir
- 106 INDIRECT Function Lookup from Different Sheets oC48 gitir
- 107 Generate Random Data Text RANDBETWEEN WQhM gitir
- 108 The Power of SEQUENCE Function Dynamic Yearly Calendar AeGf gitir
- 111 QUERY Function Syntax Important Guidelines gnze gitir
- 112 QUERY Function Example Select Where Order by sG0z gitir
- 113 QUERY Function Aggregation Calculated Columns jPQT gitir
- 114 Group by Multiple Columns Pivot Columns Query Function cNEh gitir
- 115 QUERY Function with Drop down List Dynamic Cell References hPw4 gitir
- 116 QUERY Function with Dynamic Totals Pro Tip FZvP gitir
- 117 Working with Dates Months in QUERY Function C61M gitir
- 118 Combine Data from Multiple Sheets with QUERY Function cZMg gitir
- 119 QUERY Function IMPORTRANGE to Combine Data from an External File KXQy gitir
- 122 Custom Number Formatting Explained el1w gitir
- 123 Custom Formatting for Impressive Reports with Symbols Pro Tip DcSJ gitir
- 124 Conditional Formatting with Formulas The secret to getting it right aaUI gitir
- 125 Challenge Find the Difference Between Two Lists VQTU gitir
- 126 Dependent Drop down Lists in Google Sheets 71K0 gitir
- 127 Dependent Drop down for Every Row in Sheets Pro Tip 6U6f gitir
- 128 Challenge Dependent drop down Lists in Google Sheets dl3v gitir
- 130 Google Sheets Macros Record your First Macro nCSh gitir
- 131 Relative Vs Absolute Macro Recording Practical Example U9HG gitir
- 132 Combining Macros in Sheets Mix Absolute Relative Reference CrAI gitir
- 133 Challenge Automate Chart Creation with Your Macro hHvi gitir
- 134 Reset Data Validation List with Apps Script in Sheets 0i8p gitir
- 135 Find Install Add Ons Goal Seek example 9xo4 gitir
- 137 Extras The Mechanics of the Quiz 6Rwv gitir
- 138 Final Words yOY9 gitir