SCAN function in Excel : Easy YTD and Running Totals!
In this video, we explain the SCAN function in Excel. The SCAN function is a new function exclusive to Excel 365 that allows us to to iterate over values and perform running total calculations such as Year to Date (YTD) calculations for example.
In this video, I explain the SCAN function in easy to understand and non-confusing way so that you can start using it in your daily work right away!
OFFSET function explanation:
• Excel OFFSET function basics + Dynami...
Download Example Files:
https://tinyurl.com/yhdd4zr8
⭐My Excel Courses:
✅Excel PowerPivot & DAX for beginners:
https://abdelrahman-s-site-cb54.think...
Use discount code : YOUTUBE15 to get 15% OFF on checkout (Limited time offer!)
00:00 Introduction
00:53 SCAN function basics
06:45 Using the SCAN function with a range that has multiple rows and columns
09:13 Using SCAN function to calculate YTD (Year to Date)
Follow us on Social Media:
Facebook: / excelbonanza
Twitter: / excelbonanza
Follow me on Linkedin: / abdelrahman-abdou-60240150
Instagram: / excelbonanza1
TikTok: / excelbonanza
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com
****My online Excel Courses****
https://www.excelbonanza.com/courses/
#excelformulasandfunctions #exceltutorial #exceltutorials #exceltips #exceltricks
