Excel for Accountants Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-for-accountants/ Bestselling Excel and Power BI Courses Fri, 17 Mar 2023 01:01:30 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Excel for Accountants Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-for-accountants/ 32 32 How to Use SCAN Function in Microsoft Excel https://www.xelplus.com/scan-function-in-excel/ Fri, 05 Nov 2021 14:44:00 +0000 https://www.xelplus.com/?p=9746 Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

The post How to Use SCAN Function in Microsoft Excel appeared first on Xelplus - Leila Gharani.

]]> Best 10 Excel Functions for Accountants https://www.xelplus.com/excel-functions-for-accounting/ Thu, 25 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10260 Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

]]>