A quick and simple way of finding the number of days, months or years between two dates is Excel’s secret DATEDIF function. When you type it in a worksheet, there’s no popup syntax help to indicate the function exists.
In partnership with Experts Exchange. The GoogleFinance function uses Google’s engine to insert financial data in your worksheet, like stock prices, mutual funds, and currency exchange rates. It can be near real-time data or historical. This is one of the functions in Google Sheets that has no equivalent in Excel.
In partnership with Experts Exchange. You can take an Excel sheet and place it on a PowerPoint slide with a link to the source or without a link. It’s a little different in Windows and on the Mac, and in this episode we see how to do it on both
In partnership with Experts Exchange. Excel’s Offset function, available in the last couple of versions for Windows and Mac, lets you create ranges that change location and size dynamically. In this video, we look at a few examples, then use the function to change the size of a print area
In partnership with Experts Exchange. Among the new functions currently in beta and soon to be released in the 365 editions of Excel are TAKE and DROP, which dynamically duplicate a range of cells. The TAKE function specifies which rows and columns to get and the DROP function specifies which
