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
Watch video Power Query Expert Reveals Fastest Way to Convert Birth Date to Age online without registration, duration hours minute second in high quality. This video was added by user Mellon Training 20 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 116 once and liked it 2 people.