SCAN Function Tutorial in Excel for running totals, running max, and more. 🚀 Find all our courses here: 🆓 DOWNLOAD Free Excel file for this video: SCAN is one of the hardest functions to learn in excel, but once you understand how it works, it can completely change the way you build formulas, giving you a level of control that feels almost like programming inside Excel. In this tutorial, we go over four realistic examples of using the Scan function. First, we'll use the SCAN function to calculate the year-to-date profit (YTD), so the running total profit. Then we'll calculate the year-to-date maximum profit in a single month. During this step, we'll introduce combining SCAN with the LAMBDA function. We'll also cover an alternative method to calculating the running totals with the dollar ($) signs. Next, we look at how to use the SCAN function for text values by combining it with an IF statement, LAMBDA, and an ampersand. Finally, we'll cover the =REDUCE function in Excel, and one more scenario for calculating cash flows using SCAN. LEARN: 👉 Excel for Business & Finance Course: 📈 The Complete Finance & Valuation Course: 🔥 Power BI for Business Analytics: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ SCAN Simplified Scenario 1:16​ - SCAN Scenario 1 3:05​ - SCAN Scenario 2 3:49​ - Alternative to SCAN Function 5:17​ - SCAN Scenario 3 (Advanced) 9:15​ - REDUCE Function 9:58​ - SCAN Scenario 4