محتوى الدورة
Google Sheets QUERY - SUM, AVERAGE, COUNT, GROUP BY Aggregate Functions Tutorial - Part 5 TEXTJOIN Function, Like VLOOKUP with Multiple Matches - Google Sheets Tutorial, IF, TEXTJOIN, Arrays Google Sheets SPLIT Function Tutorial - Text to Columns Using a Delimiter, INDEX, COUNTA, IMPORTRSS Google Sheets IMPORTRANGE Function Tutorial - Learn How to Pull Data From Other SpreadSheets Google Sheets QUERY Function Tutorial - SELECT, WHERE, LIKE, AND, OR, LIMIT statements - Part 1 Google Sheets QUERY Function Tutorial - Advanced Contains with Matches & Regular Expression - Part 2 Google Sheets QUERY - Filter by Date Range using WHERE Statement Tutorial - Part 3 Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_CONSTRAIN, SORT Functions Tutorial Google Sheets QUERY Date Range using SQL Format Dates Tutorial - Part 4 IMPORTHTML, IMPORTXML Functions - Google Sheets Tutorial to Extract from Web Pages to Spreadsheets 2 Google Sheets Join Strings, Text in Cells - CONCATENATE, JOIN, &, JOINTEXT Functions Tutorial Google Sheets Pivot Tables - Calculated Fields, Custom Formulas, Percentage of Total - Advanced Google Sheets - Import Data from Another Sheet - Tutorial Part 1 Google Sheets - Import Data from Multiple Sheets - Tutorial Part 2 Google Sheets - SUMIFS, COUNTIFS, AVERAGEIFS - When Range is Between Dates or Cell Contains & More Google Sheets - Filter Function Tutorial, Introduction to Logical Arrays Indirect - Google Sheets & Excel - Basic Use and Using Function with Multiple Sheets SWITCH Function (Multiple IF conditions, IFS function) - Google Sheets - similar in Excel Google Sheets - Conditional Formatting Based on Another Cell Using Formulas Tutorial Google Sheets - Combine Data From Multiple Sheets (Tabs) Tutorial Google Sheets - Get Matching Values From Two Lists / Ranges Tutorial Google Sheets - RegEx REGEXEXTRACT, Functions Exctract, Replace, Match Tutorial - Part 1 Google Sheets - RegEx REGEXEXTRACT, Functions Exctract, Replace, Match Tutorial - Part 2 Google Sheets - RegEx REGEXREPLACE, Functions Exctract, Replace, Match Tutorial - Part 3 Google Sheets - RegEx REGEXMATCH Function & Email Data Validation Tutorial - Part 4 Google Sheets - Conditional Formatting Row Tutorial Google Sheets - Dynamic Drop Down Based on Another Cell & Multiple Selections Updated Automatically Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If Statements Google Sheets - Conditional Formatting Duplicate Values Tutorial - Highlight Duplicates Google Sheets VLOOKUP from another Spreadsheet with IMPORTRANGE Tutorial - Part 7 Google Sheets QUERY Function, VLOOKUP with Multiple Matches Tutorial - Part 6 Google Sheets INDEX & MATCH Functions, VLOOKUP Function Tutorial, Same in Excel - Part 5 Google Sheets VLOOKUP Function Tutorial - UNIQUE, IFERROR, Exact Match, Similar to Excel - Part 4 Google Sheets VLOOKUP Function Tutorial - Merge Data, IFERROR, Identical in Excel - Part 2 Google Sheets VLOOKUP Function Tutorial - Is Sorted, Approximate Match, Similar to Excel - Part 3

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك