If you’re new to the whole concept of spreadsheet programs, check out my new course, published by Tuts+: Intro to Spreadsheets. It’s not Excel, only!
Of course, Excel is the 800 lb. gorilla in this category, and most of the course focuses on it, but the course will also help if you’re using other applications, like Google Sheets, Apple Numbers, LibreOffice Calc, and the web and mobile versions of Excel. You can finish the course in about a day. Exercise files are included.
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
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
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
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
