February 22, 2018
Shortcut for Duplicating Formulae, Text and Objects in Excel
If you want to duplicate something you can copy (CTRL+C) and paste (CTRL+V). But there's a quicker way that only
Read More
February 14, 2018
Excel Infographics
Excel infographics, like the one below, are easy to build and there are loads of tools you can use to
Read More
February 5, 2018
Excel Forecast Sheet
The Excel Forecast Sheet and charts are a new feature available in Excel 2016. In just a few clicks you
Read More
January 31, 2018
Labelling Events in Excel Charts
Plotting data over time can reveal patterns and trends, but often blips in the data require further explanation. We can
Read MoreDecember 14, 2017
Excel Chart Formatting Tips
Format your dashboards and reports fast with these pro Excel chart formatting tips. Watch the Video Pro Tip 1 –
Read More
December 6, 2017
Excel Dot Plot Charts
Dumbbells and Lollipop Charts Excel Dot Plots, dumbbells and lollipop charts are good for comparing one, two or three points
Read More
November 30, 2017
Visualizing Parts to a Whole in Excel Charts
When you think of visualizing parts to a whole in Excel charts the first thing that’s likely to come to
Read More
November 24, 2017
Writing UDFs in Excel With Python
My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to
Read More
November 17, 2017
Plot an Equation in Excel Using Python
Something I've wanted to do easily in Excel is plot equations. If I have something like 2x2 + 3x +
Read More
November 6, 2017
Excel PivotTable Error Handling
Obviously, we don’t want our PivotTables littered with #DIV/0! and #NULL! errors if we’re presenting them in a report (like
Read More
November 2, 2017
Excel PivotTable Percentage Change
PivotTables can make quick work of summarising and analysing data and they have some handy built in percentage calculations available
Read More
October 26, 2017
Excel 4.0 Macro Functions
Before VBA there were XLM macros. VBA was introduced in Excel version 5, so these Excel macros are also known
Read More
October 25, 2017
Extract Date or Time from a Date and Time
We often need to extract the date or time portion from a date-time serial number for use in other functions.
Read More
October 25, 2017
Excel DATE Function
The Excel DATE function combines separate year, month and day values and converts them into a date serial number formatted
Read More
October 25, 2017
Convert Month Names to Numbers
Often, we'll have a list of month names that we want to convert to a date, or even just convert
Read More
October 24, 2017
Convert Dates to Text
If you want to use a date in a chart label, or you want to concatenate a date with some
Read More
October 23, 2017
Fix Excel Dates Formatted as Text
Dates incorrectly entered or imported as text are a showstopper. We need our dates entered as date serial numbers to
Read More
October 20, 2017
Excel Date and Time Formatting
Even though dates and time are actually stored as a regular number known as the date serial number, we can
Read MoreOctober 19, 2017
Excel NETWORKDAYS.INTL Function
The Excel NETWORKDAYS.INTL function (new in Excel 2010) returns the number of working days between two date serial numbers, excluding
Read More
October 12, 2017
Power Query Get Files from a Folder
If you receive your data in separate daily, weekly or monthly files then before you can even begin analyzing the
Read More
October 2, 2017
Label Excel Chart Min and Max
Highlighting the minimum and maximum in an Excel chart can help focus your readers’ attention. We can manually select points
Read More
September 26, 2017
Dynamically Label Excel Chart Series Lines
The default Excel chart legends can be awkward and time consuming to read when you have more than 2 series
Read More
September 19, 2017
Highlight Cells Referenced in Excel Formulas
In an ideal spreadsheet our formulas would always reference adjacent cells and columns and it would be obvious which cells
Read More
September 7, 2017
Excel Pivot Chart Drill Down Buttons
Excel Pivot Chart Drill down buttons are a new feature available in Excel 2016. You’ll find them in the bottom
Read More
August 22, 2017
Excel Extract a Unique List
As with most things in Excel, there are many ways to extract a list of unique or distinct values from
Read More
August 15, 2017
Excel Find and Remove Duplicates
Sometimes we want to find and remove duplicates in Excel, other times we just want to identify or highlight duplicates.
Read More
August 10, 2017
VBA SELECT CASE
VBA SELECT CASE allows you to test an expression against multiple conditions, and then carry out a series of commands
Read More
August 3, 2017
VBA IF THEN ELSE
The VBA IF THEN ELSE statement lets you test a condition, and then carry out other commands if the test
Read More
July 27, 2017
Excel Convert Dates to Fiscal Quarters and Years
If your company’s fiscal year runs in line with the calendar year then it’s easy to convert dates into quarters
Read More