Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Top 5 Most Popular Excel Functions - DateDif, TextSplit, If, Substitute, and XLookup

Alex the Analyst via YouTube

Start learning Write review
Boot.dev Ad

Stuck in Tutorial Hell? Learn Backend Dev the Right Way

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn essential Microsoft Excel functions in this 17-minute tutorial video that covers five widely-used formulas for data analysis. Master the DateDif function for calculating time differences between dates, explore TextSplit for breaking down text into separate columns, understand If statements for conditional logic, implement Substitute for text replacement, and harness the power of XLookUp for advanced data retrieval. Download the provided practice dataset from GitHub to follow along with hands-on examples and strengthen your Excel skills through practical demonstrations of each function's real-world applications.

Syllabus

Intro
DateDif
TextSplit
If
Substitute
XLookUp
Outro

Taught by

Alex the Analyst

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Top 5 Most Popular Excel Functions - DateDif, TextSplit, If, Substitute, and XLookup

  • Profile image for Humaiyri Akanni (Gzilla1)
    Humaiyri Akanni (Gzilla1)
    1
    This Excel tutorial on XLOOKUP, Text Split, IF functions, and SUBSTITUTE was incredibly helpful and well-structured. Each concept was broken down clearly with step-by-step explanations, making it easy to follow along even for those who are still building confidence in Excel. I especially liked how the instructor used real examples to show when and why to use each function, not just how they work. The comparison between older functions like VLOOKUP and the more powerful XLOOKUP was a great touch. After completing the lesson, I feel much more capable of handling data cleaning and lookup tasks efficiently. Highly recommended!
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.