Vouched

Command Palette

Search for a command to run...

Datacamp

Datacamp

DataCamp Courses & Certificates

25% off

Datacamp

DataCamp Courses & Certificates

25% off
MShared byMo Chen
From video: Top 10 Most Powerful Microsoft Excel Functions for Data Analysts
Published: March 3, 2026

Video Description

Portfolio, Projects, Resume, Courses & Certifications, Newsletter https://mochen.info Sponsorships: https://mo-chen.notion.site/partnerships Hi, I'm Mo! I'm a Data & Analytics Manager. I'm all about turning complex, big data into insights and actions. I am not interested in building yet another dashboard that nobody looks at - I'm interested in solving the most challenging business problems using data. ========================================================= 25% DISCOUNT ON COURSES & CERTIFICATES Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen INDUSTRY RECOGNIZED CERTIFICATIONS Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCertDataCamp PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAnalyst Data Scientist Certification Program: https://datacamp.pxf.io/DataScientistCert SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert TOP DATA ANALYST COURSES Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWithPython Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPowerBIMoChen Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateDataAnalystSQL Project File: https://mochen1-my.sharepoint.com/:x:/g/personal/mochen_mochen1_onmicrosoft_com/IQA_EWFbxmd1Rrfa2nz2v-_yAacXTjbxMHaCptH2tLpGX0I?e=FFTf3X TIMESTAMPS 00:00 Overview 01:05 FILTER 03:58 UNIQUE 05:00 SORT 06:45 Portfolio, Projects, Resume, Newsletter 07:24 XLOOKUP 09:29 SUMIFS COUNTIFS 11:58 IFS 13:16 Descriptive Statistics 15:35 PROPER 16:30 LET