Excel has some great functions for “What if…” scenarios. One tool that can be used is the Excel Goal Seek. This allows you to choose any current formula and set the answer value to your own goal. e.g. If you have a formula that works out how much profit you make from selling items, such […]
Excel 2007 introduced the function COUNTIFS to count cells based on multiple criteria. For example suppose you wish to count how many times the client Fowler buys more than 250 shares. The answer for tha data below turns out to be 2 using the Countifs function entered in B13. Similarly for Owen the result turns out to be 1. […]
One of the most asked questions during our Excel 2010 Training Courses in London has to be the subject of calculating times. One important issue is how time values are typed in Excel. This should always be as 9:00 AM or 10:30 PM. There must be a colon separating the hours:minutes and if you are […]
Ever closed an Excel workbook and clicked the “Don’t Save” option, then realised you should have saved it! Microsoft Excel 2010 now has a file recovery option for just such an occassion. This has proved invaluable in our Microsoft Excel Training Courses in London. Always check the AutoRecover time in the Excel options. To do […]