Power Query Expert Reveals Fastest Way to Convert Birth Date to Age
Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/
👉 What You'll Learn:
In this video, I’ll show you how to use YEARFRAC at the sheet level and then how to use Excel Power Query to Convert and Calculate a Birth Date to an Age.
⬇️ Grab the workbook I use in the video here: https://bit.ly/3UHr9Ld
Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD
🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME
🔍 Key Moments in This Video:
00:00 2 WAYS To Convert A Birth Date To An Age | Power Query & YEARFRAC()
01:10 How to Calculate Age using YEARFRAC Excel Function
02:30 How to Calculate Age using Microsoft Excel Power Query
🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com
🎬 LINKS to other videos:
Make An INTERACTIVE MAP CHART In Excel 👉 • MIND-BLOWING Excel Secrets To Create ...
Make An Excel PANEL CHART 👉 • Create a POWERFUL Excel PANEL CHART i...
Add Text to Numbers AUTOMATICALLY 👉 • Add Text to Numbers in Seconds with T...
Sum Excel Tables in ONE STEP 👉 • Use this FUNCTION HACK to Sum Excel T...
Supercharge Your Spreadsheets with Excel's Goal Seek 👉 • Supercharge Your Spreadsheets with Ex...
Excel SUMPRODUCT Function 👉 • Why Excel SUMPRODUCT is About to Chan...
2 WAYS to create Excel Bar & Donut Charts 👉 • MASTER Excel Bar and Donut Charts in ...
Mastering Excel Pareto Charts 👉 • Mastering Excel Pareto Charts: A Step...
📊 Excel Your Skills: www.mellontraining.com
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
#excel #excelfunctions
Смотрите видео Power Query Expert Reveals Fastest Way to Convert Birth Date to Age онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mellon Training 20 Февраль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 116 раз и оно понравилось 2 людям.