محتوى الدورة
Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course Microsoft Excel 365 Tutorial: 3+ Hours of Advanced Excel Training How to Count Unique Entries in Excel 365 How to Use Spills and Arrays in Excel 365 Unique vs Distinct in Excel 365 How to Extract Multiple Unique Columns in Excel 365 How to Extract Unique Values by Column in Excel 365 How to Use the SEQUENCE Function in Excel 365 How to use RANDARRAY and RANDBETWEEN in Excel 365 How to use XLOOKUP for Complex Lookups in Excel 365 How to use XMATCH in Excel 365 How to do Lookups with Multiple Criteria in Excel 365 How to do Lookups with Duplicates in Excel 365 How to use the LET Function in Excel 365 How to Create Excel Functions with LAMBDA How to Create a Data Model in Power Pivot How to Create Relationships Between Tables in Excel 365 How to Add Calculated Columns in Excel 365 How to Build a PivotTable from Multiple Sources How to Clean Data with Power Query in Excel 365 How to Combine Files from a Folder with Power Query in Excel 365 Ultimate Guide to the FILTER Function in Excel 365 How to Use Calculated Fields and Items in PivotTables How to Use the SORT Function in Excel 365 How to Use the SORTBY Function in Excel 365 Ultimate Guide to Create Your Own Functions in Excel 365 How Create Custom Pivot Table Styles How to Apply Custom Number Formatting in Excel 365 PivotTables How to Use Form Checkboxes in Excel 365 How to Use Macros for Automation in Excel 365 How to Lock Workbooks but not Slicers in PivotTables: Filterable and Adjustable Locked Spreadsheets How to Record Macros with Relative References in Excel 365 How to Use the VBA Editor in Excel 365 How to use Copilot to Generate VBA Code How to use AI to Generate Sample Datasets How to Build and Design Charts and Dashboards in Excel Quickstart Guide to Cleaning Data and Building Reporting Dashboards How to Boost Efficiency in Microsoft Office: Top Tips and Expert Hacks Data Models, PivotTables, and Power Query in Excel Conditional Formatting in Excel How to Create Professional Charts for Business in Excel Interactive Excel Charts and Dashboards - Data Visualization Course Top Excel Functions for Data Analysts Create Formulas and Fix Common Errors in Excel Excel 365 Beginner to Advanced - 12 Hours Top 15 Excel Tips and Tricks to Save Time and Speed Up Your Work Top 15 Excel Functions Everyone Needs to Know Accountant Excel Toolkit: Trial Balance and General Ledger in Excel Master Data Cleaning Essentials with Power Query And Excel Top Excel Essential Tips Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course

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

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