## The easiest ways to add a new data series to an existing Excel chart

There are lots of ways to add a new data series to an existing Excel chart.  Here are what we suggest are the two easiest ways: Method 1: Copy & Paste Great if your data series aren't in a table or aren't adjacent to each other. 1. Select your data (including the heading) and copy this [...]

2017-03-08T03:53:54+00:00 Charts|

## Infographic: How Digital Disruption is Changing the role of the CFO

Infographic: How Digital Disruption is Changing the role of the CFO Any CFO that still thinks their main role is to produce accounts and lodge tax returns will soon be out of a job. Digital disruption is changing the world’s economy, companies, and every job function they contain. We surveyed a number [...]

2017-03-08T03:53:54+00:00 CFOs|

## 58 Crazy Excel Stories (that are probably happening in your company right now)!

58 Crazy Excel Stories (that are probably happening in your company right now)! Crazy things happen when you mix untrained users with Excel. It’s not really rocket science.  Crazy things would happen with any complex system if you don’t train people properly. But many companies simply assume that everyone knows Excel, so they [...]

## See Celsius in your cells (try saying that quickly 3 times!)

I recently was asked if there's a way of adding the Celsius symbol to a value in Excel. The answer is yes, and the method can be applied to all sorts of useful symbols / notation.  e.g. bullet points, m2, km/hr, bbl, currency symbols etc. This is how.... Pick a blank cell then go to [...]

2017-03-08T03:53:54+00:00 Formatting, Functions|

## Power Query Trap: Formula Autofill

Power Query Trap:  Formula Autofill If you output the results of Power Query to a table in Excel then it’s often really useful to be able to add an extra calculated column or two onto the end of this output table.   I used to do this all the time when using Microsoft Query. However, now [...]

2017-03-08T03:53:54+00:00 Power BI|

## Combine multiple tables with Excel Power Query

How to combine multiple tables with Excel Power Query If you have multiple tables of data in a file and you want to view a single report based on these tables then it can be time consuming and risky to manually copy and paste them into a single table before creating pivot [...]

2017-03-08T03:53:54+00:00 Data Handling, Excel 2016, Power BI|

## Stop merging cells!

Stop merging cells! One Microsoft Excel Insider has been quoted as saying that 53% of Excel Users merge cells. There is a standard tool on the toolbar called “Merge and Center”, it “merges” two or more cells into one and then centers the text horizontally within the merged cell. This can cause a number of [...]

2017-03-08T03:53:55+00:00 Data Handling, Formatting, Productivity|

## The Great 48 Excel Toolbar

The Great 48 Excel Toolbar We love Excel and it can do some pretty amazing stuff. But sometimes there are a lot of unnecessary steps and clicks which are quite annoying, especially when you’re using Excel all day long! So we developed this Excel toolbar for ourselves and now we're sharing it with [...]

2017-03-08T03:53:55+00:00 Productivity, VBA – Macros|

## Last Used Cell In A Row

Last Cell used on a Row Find the reference of the last cell used in a row By Neale Blackwood One of the articles on our site allows you to find the cell reference of the last used cell in a column. You can see it below in the related articles. Someone asked if there [...]

2017-03-08T03:53:55+00:00 Arrays, Functions|

## 3 Easy Steps to Create Waterfall Chart in Excel 2016

Create a Waterfall Chart by Yury Tokarev A waterfall chart is a great way to represent financial inflows and outflows. Yet, it is a daunting task to create this in Excel versions up to 2013 (see links below for help!). The good news is that Excel 2016 has taken all the complexity away. [...]

2017-03-08T03:53:55+00:00 Excel 2016|

## What to do when they just fired your Excel Guru

"OMG! They Fired our Excel Guru!" Unfortunately, this is all too common these days. Companies, in their over-zealous quest to reduce costs, fire the one person who actually knew how to operate that really complicated Excel spreadsheet that's critical to the report you need to send out next week. What were they thinking!!! Now what? [...]

2017-03-08T03:53:55+00:00 Budgeting/Forecasting, CFOs, Financial Modelling|

## Hyperlink Formulas & how to use them

Hyperlink Me! The HYPERLINK Formula (who knew that formula existed?) can be really useful when navigating around large spreadsheets The simplest format is along the lines of =HYPERLINK("#A1","Any Helpful Message") This would jump you to cell A1 of the current sheet.  But that's no different to a normal old Hyperlink (via RIGHT-CLICK > Hyperlink or Insert [...]

2017-03-08T03:53:55+00:00 Functions|