How often when using Excel have you had to scroll down to find what you’re looking for in a huge spreadsheet only to find your top headings disappear off the screen? Well worry no more. The solution lies in using an incredibly handy tool called Freeze Panes. This tool ‘freezes’ the top row and left […]
For users with the Office Professional Plus package, the Inquire add-in comes pre-installed on Excel 2013. Helping you to analyse, audit and review workbooks, this great new feature also has the potential to highlight errors and security concerns. We recently discussed, how to take back control of your spreadsheets by reducing “fat finger mistakes” and […]
Have you ever wanted to automatically number rows of data in Excel? One way to do this is by using the Row function. For example, type a heading such as ID into A1 then in A2 type the formula =Row()-1 In this example suppose you want the numbers to be inserted automatically as you add […]
If you have an Excel Worksheet that contains Data relating to the hours of training for each Employee for Microsoft Excel Training London on Monday, Tuesday and Wednesday, you may want to return the hours trained for a particular employee on a particular day in another Excel Workbook or Excel Worksheet. The spreadsheet shown below is the […]