Excel SCAN Function

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.

Office App Convert Image to Table Excel

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.