If you work in Excel with data imported from other databases you’ll often find it doesn’t import it in the format you want. For example, I imported some Google Analytics data about our website traffic and the dates are formatted like this: Tuesday, February 1, 2011 While this looks like a date format, in my [...]
February 2011
In my last tutorial I showed you how to insert a Subtotal using the Subtotal tool. If you’ve read that tutorial you will have seen how Excel also conveniently inserts Groups and Outlines to your data so you can easily group and ungroup the rows to see varying levels of detail. Thankfully you can insert [...]
The dashboard in your car is one of the key tools you use to monitor how it’s running, so it’s appropriate that the business world has borrowed the term and applied it to a series of graphs and key information that fits onto one page. A dashboard view of your business’s performance, if done well, [...]
The Subtotal tool in the Outline group on the Data tab of the ribbon automatically inserts subtotal formulas and grand totals for a column or columns. The subtotals can be SUM’s, AVERAGE’s, COUNT’s, MIN, MAX and more. The Subtotal tool can give you valuable information in a few clicks, transforming your data like this: How [...]
A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH functions. In this Excel tutorial I’m going to show you how you can do a lookup to the left with a VLOOKUP formula together with the CHOOSE function as an alternative. First of all let’s [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
