I've used Excel for years but always avoided writing my own formulas beyond basic SUM and AVERAGE. This course walks through text functions like MID and TEXTJOIN in a way that actually explains what each argument does instead of just showing a finished formula. The date section covering DATEDIF, EOMONTH, and WORKDAY was especially useful since I deal with deadline calculations constantly at work. Every lesson uses a realistic messy dataset, which forced me to actually think about edge cases instead of copying a clean example. By the end I'd rebuilt one of my recurring reports to update itself with formulas instead of manual copy-pasting, which alone saved me hours.
Practical Excel Formulas for Text and Dates
Automate your data cleaning and reporting tasks by mastering essential formulas for manipulating text and calculating with dates in Excel.
-
💬
AI instructor
Ask about any lesson and get a clear answer instantly, anytime. -
🕐
Start anytime
No schedules or deadlines — learn at your own pace, whenever suits you. -
🌐
In English
Lessons, tasks and certificate — all fully in your language.
About this course
Do you spend hours manually cleaning up messy text data or struggling with date calculations in your spreadsheets? This course will teach you how to use Excel's powerful functions to automate these tedious tasks and save valuable time.
You will gain the skills to confidently parse, clean, and reformat any text data, and perform accurate calculations with dates and times. Transform your static reports into dynamic, self-updating worksheets that work for you.
What you'll learn:
- Learn to extract, combine, and clean text using core functions like LEFT, MID, FIND, and TRIM.
- Apply modern text functions like TEXTSPLIT and TEXTJOIN to handle complex string manipulation tasks efficiently.
- Master date and time functions to calculate durations, find future dates, and handle workdays.
- Understand the fundamentals of how Excel stores and calculates with dates and times to avoid common errors.
- Practice combining multiple functions to solve real-world problems like generating custom report labels or calculating project timelines.
- Build dynamic formulas that automatically adjust as your data changes, leveraging modern array behaviors.
This course starts with the foundational concepts of writing formulas and then progresses through dedicated sections on text and date functions. Each topic is explained with clear, practical examples that you can apply directly to your own work.
This course is designed for beginners and anyone who wants to improve their efficiency in Excel. No prior experience with complex formulas is necessary.
Enroll now to start building powerful and time-saving formulas today.
What you'll get
-
📜
Certificate of completion
Add it to your LinkedIn profile -
💬
Personal AI tutor
Stuck on a lesson? Ask your built-in tutor anything, any time. -
🎧
Audio version included
Learn on the go — no screen needed -
♾️
Lifetime access
Come back anytime, no expiry -
📱
Phone or computer
Works anywhere, any device -
💸
14-day refund
No questions asked -
⚡
Short & focused
2h 42m of practical content
Reviews (16)
Khóa học dạy khá kỹ các hàm xử lý văn bản như LEFT, RIGHT, TRIM và cả hàm ngày tháng như DATEDIF, rất sát với công việc làm báo cáo hàng ngày. Ví dụ minh họa dùng dữ liệu lộn xộn giống hệt file thật nên dễ áp dụng ngay. Duy chỉ có phần công thức lồng nhau hơi khó theo nếu chưa quen Excel từ trước.
Der Kurs erklärt Textfunktionen wie LINKS, TEIL und GLÄTTEN sehr anschaulich anhand von echten, unordentlichen Tabellen statt sauberer Beispieldaten. Auch der Abschnitt zu Datumsformeln wie DATEDIF und EDATUM hat mir endlich geholfen, Fristen automatisch zu berechnen statt sie von Hand zu zählen. Etwas schade ist nur, dass verschachtelte Formeln gegen Ende recht schnell erklärt werden.
バラバラだった顧客名簿の表記をTEXT系の関数でサッと整えられるようになり、日付の差分計算も怖くなくなりました。毎月の報告書作りがかなり時短になって大満足です。
Bilang isang taong araw-araw gumagawa ng report sa trabaho, sobrang laking tulong ng kursong ito. Malinaw na paliwanag ang mga leksyon tungkol sa text functions gaya ng LEFT, RIGHT, at TRIM, at hindi lang teorya kundi may aktwal na messy data na ginagamit sa mga exercise. Yung bahagi tungkol sa date formulas gaya ng DATEDIF at EDATE ang pinaka-nakatulong sa akin dahil madalas akong kailangang mag-compute ng deadlines. Sunod-sunod ang pagtuturo kaya kahit hindi ako advanced sa Excel, kasabay kong nasusundan ang bawat hakbang. Ngayon, mas mabilis ko nang natatapos ang mga monthly report ko dahil marami na akong na-automate na formula.
Duidelijke uitleg, direct toepasbaar op werk.
I signed up mostly to stop manually cleaning date columns every month, and this course delivered on that. The lessons on text functions like LEFT, RIGHT, and TEXTSPLIT are explained with messy real-world spreadsheets rather than tidy sample data, which made the practice much more useful. The section on date formulas, especially DATEDIF and EDATE, finally made sense to me after years of just guessing. Pacing is good overall, though a couple of the formula-building exercises jump ahead without fully explaining every argument. Still, I went from dreading a monthly report to automating most of it in under an hour.
This course covers text functions like TRIM and CONCATENATE alongside date formulas such as EDATE and NETWORKDAYS, using genuinely messy spreadsheet examples instead of clean sample data. I liked that it explains the logic behind nested formulas step by step rather than just handing you the syntax. The only downside is that the video on text-to-date conversion moves a bit fast and I had to pause a lot.
TEXT関数やDATEDIF関数の使い方が具体例つきで説明されていて、面倒だったデータ整形の作業がかなり早く終わるようになりました。
O curso explica muito bem funções de texto e data como TEXTO e DATADIF, só senti falta de mais exemplos com fórmulas aninhadas.
Pasaba horas limpiando nombres y fechas mal escritos en mis reportes, así que este curso fue justo lo que necesitaba. Aprendí a combinar funciones de texto como IZQUIERDA y EXTRAE para separar datos en segundos, y a calcular antigüedades con las funciones de fecha sin liarme. Los ejemplos parten de planillas reales con el típico desorden de oficina, así que se aplica todo enseguida. Lo que antes me llevaba media mañana ahora lo resuelvo con una fórmula. Mis informes salen mucho más limpios y a tiempo. Totalmente recomendado.
Курс реально экономит время на рутинных задачах с отчётами. Хорошо разобраны текстовые формулы вроде ЛЕВСИМВ и ПСТР, а также работа с датами через РАЗНДАТ — всё на конкретных примерах, а не в теории. После курса я автоматизировала обработку данных, которую раньше делала руками каждую неделю.
Phần hàm ngày tháng như DATEDIF được giảng khá dễ hiểu, chỉ hơi tiếc là ví dụ về hàm văn bản còn ít.
Straightforward, practical lessons on text and date formulas that I started applying at work the same day.
The lesson on splitting and cleaning messy text with TEXTSPLIT and TRIM alone was worth going through the whole course.
Endlich verstehe ich, wie man Datumsformeln wie EDATUM wirklich im Arbeitsalltag einsetzt, statt sie nur auswendig zu lernen.
Learners also took
💼 Job-ready
🎓 With certificate
Excel Essentials: Formulas, Functions, and Data Analysis
Certificate
Hands-on
$14.99
→
💼 Job-ready
🎓 With certificate
Excel and Copilot Foundations for Modern Data Work
Certificate
Hands-on
$14.99
→
💼 Job-ready
🎓 With certificate
XML and XSLT: Beginner's Guide to Data Transformation
Certificate
Hands-on
$14.99
→
🔥 Hot
🎓 With certificate
Excel Payroll Management and Financial Modeling
Certificate
Hands-on
$14.99
→
Frequently asked
What do I need to take this course? +
Just a phone or computer with internet. No installs, no special hardware.
How do I pay? +
By card via Stripe. We don’t store card details — Stripe handles them securely.
Can I get a refund? +
Yes — full refund within 14 days, no questions asked.
How long will I have access? +
Forever. Once you purchase, the course is yours to revisit anytime.
Will I get a certificate? +
Yes. On completion you'll receive a certificate you can add to your LinkedIn profile.
Built for learners in
Tech
Design
Finance
Marketing
Healthcare
Education
Hospitality
Manufacturing