SCAN Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/scan/ Bestselling Excel and Power BI Courses Thu, 23 Feb 2023 09:16:58 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png SCAN Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/scan/ 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.

]]> How to Convert Image to Word or Excel Values with the Office App https://www.xelplus.com/convert-image-to-table-excel/ Thu, 05 Nov 2020 10:00:00 +0000 https://www.xelplus.com/?p=10549 With the Office mobile app you can easily convert an image or a photo (jpeg, png or gif) into an editable Word document. You can also use this technique to convert an image into an Excel spreadsheet.

The post How to Convert Image to Word or Excel Values with the Office App appeared first on Xelplus - Leila Gharani.

]]>