Скачать или смотреть 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!

Props to ‪@LeilaGharani‬ for the formula for calculating YTD across different years.

OFFSET function explanation:
   • Excel OFFSET function basics + Dynamic Ran...  

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 #SCANFUNCTION #runningtotal #YTD