I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.
In the following example there is a column of stock codes. The numbers represent our Supplier and the letters after the hyphen (-) indicates our Item number. Suppose we need to extract the Supplier and Item codes and place in separate cells. If our Supplier codes were all equal length e.g. 3 numbers long, we […]
A new feature introduced in 2010 version of Excel is the Slicer tool. Used to visually and quickly filter data within a Pivot Table. Although the Pivot Table feature makes it extremely easy to manipulate the layout of data lists in Excel, we have found most attendees of our Excel 2010 training Courses are excited […]
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 […]
One of the great new features of Excel that users enjoy employing during our Microsoft Excel Courses here in London is the Sparklines. These can be thought of as mini-Charts that reside in a cell, and can show a trend visually of a group of values. In the example shown below there are sales figures from […]
If you have a lot of data in Excel and you want to find the highest or lowest number in a row, column or range of cells, Excel provides an easy way to produce this answer for you, without the need to sort your data. Lowest number: The Excel function to find the lowest number […]