Microsoft Training Resources

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 […]

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 […]