Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Gantt charts are commonly used in project management and while Excel doesn’t have a native Gantt chart in its chart library we can easily create one. Don’t get too excited, it’s a very basic one. If your job involves complex project management then you probably need a more sophisticated tool like Microsoft Project. However, for …
I recently came back from a family skiing vacation in Whistler, Canada, which by the way was fantastic. Here we are at a lookout on a snowmobile trip we took. Anyway I digress…. one of the key pieces of information you want to know as a skier (or snowboarder) is how much snow is on …
As fun as this chart is, it actually makes a valid point and that is; pie charts are (typically) not very useful. Why? They’re slow to interpret because they usually have too many slices with teeny weeny labels on stalks. You know the ones….like this: Nine times out of ten there are better charts to …
There's a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some of us are still making these mistakes. Are you? The good news is they're easily fixed. Mistake 1. Create reports that take a long time to update. I’ve done it before. I’ve I imported the …
Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data first? If you use Access then this is a great productivity booster because once you connect to your Access query you simply refresh the data connection and your Pivot Table updates, as do any charts …
So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look at our options to make this better: Chart Axis Alignment We could use the alignment tools. Right-click axis > Format Axis > Alignment. But before you waste time doing this there is a better way. …
One of the Excel questions I get asked often is; how do I add a secondary axis to my chart? It’s actually quite easy but there is a trick to it. Excel Secondary Axis Trick Step 1 Let's take this data. Now, the first thing you want to do is simply insert your chart. Insert …
A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into groups. Since my 5 year old is big into his football (soccer) we’ll take goals scored as an example…even though in 5 year old's football matches you’re not supposed to count the goals scored! Below …
