by John MacDougall | Apr 29, 2017 | Charts
Get The Completed Workbook In this post we’re going to make a pizza pie… chart. Not as delicious as real pizza, but this is a cool trick to jazz up your charts and involves changing the fill option to a picture for your various data points. This trick...
by John MacDougall | Apr 27, 2017 | Pivot Tables, Tutorials
What Are Pivot Tables? Pivot tables are one of Excel’s most powerful tools. They allow you to quickly turn thousands of rows of data into meaningful summaries with an easy to use drag and drop interface. In the example we’re going to...
by John MacDougall | Apr 23, 2017 | Tips
Get The Completed Workbook Excel allows a variety of date formats and depending where you’re from the default formats will be different. A date like 31st December 2016 might appear formatted in Excel in any of these ways: Dec, 31 2016 2016-12-31 31-12-2016...
by John MacDougall | Apr 21, 2017 | Tips
These are keyboard shortcuts for moving the active cell around a selected range of cells. Enter – Move the active cell one cell in a direction based on your settings. This is down by default. Shift + Enter – Moves the active cell up to the previous...
by John MacDougall | Apr 20, 2017 | Charts
Get The Completed Workbook In a previous post I showed you How To View Actual Versus Target With A Thermometer Style Chart and in this post we’re going to look at how to display similar information in a gauge chart. Excel doesn’t have a gauge chart option,...