Excel

What is a Pivot Table

“With a pivot table, you can take 65,000 rows (it is a lot more than that now!) of transactional data and transform it into a summary report in seconds. In addition to quickly summarising and calculating data, pivot tables allow you to change your analysis on the fly by simply dragging fields from one area [...]

Read the full article →

MS Excel – secondary chart axes

Sometimes you will need to chart two sets of numbers that have a dramatically different scale but are still related to each other. An example might be Gross Profit and Gross Profit Percentage. If you try to chart these as normal you will end up with an invisible Gross Profit Percentage running along the x-axis [...]

Read the full article →