I’m new to the charting side of things…I’m used to staring at numbers on worksheets and trying to figure out what it all means…and admiring those around me who use charts…so mysterious…so professional looking…so much nicer than my rows of figures. Charts make it so much easier to spot trends and analyse data – and […]
Above is an example of a standard pivot table in Microsoft Excel 2010. It is set up with financial quaters as column headers and products as Row labels. I’m interested in seeing the results for the combined sales for the first half and the second half of the year. As you can see I have […]
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 […]