Month: April 2017

How To Make A Pizza Pie Chart

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 works for other charts like bar charts and you don’t have to fill them with a pizza picture, you can use something more relevant to your data, so if you’re an office supply company and you wanted to make a graph showing your top 5 products you could use pictures of...

Read More

About Pivot Tables

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 go through, we will look at sales data with 5,000 records. Each record or row of data pertains to one sale to one customer and contains the follow information. Sales Representative – This is the person who made the sale. Location – this is the location of the customer for this sale. Region –...

Read More

How To Change A Date Into A Serial Number Recognised By Excel

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 12/31/2016 (mm dd yyyy format is only used in the US) 31/12/2016 16-Dec-31   There are many more possible formats and you can even create your own with custom formats. In this example of Dec, 31 2016, the date is really stored in Excel as the value 42735 regardless of the format. This is because Excel stores dates as...

Read More

6 Keyboard Shortcuts For Moving Within A Range Selection

  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 cell in the range. Tab – Moves the active cell to the right in the range. Shift + Tab – Moves the active cell to the left in the range. Ctrl + Period – Moves the active cell to the next corner of the range in a clockwise fashion. This does...

Read More

How To Create A Gauge Chart For Measuring Progress Against A Goal

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, but we can use a pie chart to create something that looks like a gauge. In this example we’ll chart the current amount raised against a fundraising goal.     We’ll need to set up a few fields in our spreadsheet to start. Current – This will be the current amount that’s been raised so far...

Read More
  • 1
  • 2


Microsoft MVP



50_Tips_to_Master_Excel_hardbackcoverstanding_300x400 Home


Pin It on Pinterest