Dynamic Data Validation with Tables in Excel

Dynamic Data Validation with Tables in Excel Why is Excel returning an error message? Why doesn’t my formula work? What did I do wrong? The answer to these common questions may surprise you. Many spreadsheets I’ve come across have a common problem – inconsistent data entry. If someone enters “United States of America” in a [...]

Get & Transform to the rescue!

Get & Transform to the rescue! Is it a bird? Is it a plane? No it's way better than that, it's Excel! Get & Transform, also known as Power Query, gives Excel users super powers. Here's the latest scenario where it has helped out and also is an opportunity for me to demonstrate a method [...]

Excel Dependent Drop Downs

  Dependent Drop Down Box   How to do one of those trickier tasks in Excel: set up a drop down box that is dependent on the result of another drop down box. The scenario If coffee is selected from drop down A then I want a list of coffee types to appear in drop down [...]

Easy Cumulative totals in Tables

Easy Cumulative totals in Tables The single greatest advancement in Excel in the last 10 years was the introduction of Tables.  Yet although Tables were introduced in Excel 2007 there is still a huge number (I'd even say the majority) of Excel users that don't know how to create tables or understand what they do. This [...]

Master INDEX MATCH in 60 seconds

INDEX MATCH is great but GETMATCH would be better I've written a number of articles in the past around how INDEX MATCH is a technically better option compared to VLOOKUP. However, it is a trickier formula and therefore not as widely used, so I've added a new formula suggestion to the Excel [...]

7 Mischievous Adventures in Excel

This eBook has some great ideas on how to have more fun in Excel than you can poke a kitten at (usually at your colleague’s expense!) *evil laugh* If you’d like some ideas for some mischievous adventures that will mess with your friend’s head (and their models), download this now! You'll learn things [...]

2017-03-08T03:53:54+00:00 Keyboard, Productivity|

Excel Shortcuts: 22 of the very best and most handy!

A collection of our favourite keyboard shortcuts in Excel. Pin it up on your wall & share it with your friends. Shortcuts to save time and maximise productivity including: Creating charts faster Faster formatting Navigating a large spreadsheet and 19 more!          

2017-03-08T03:53:54+00:00 Keyboard, Productivity|

When one Excel session just isn’t enough!

By Wyn Hopkins This simple tip may save you a lot of time and effort, but it must be used carefully. With the arrival of Excel 2013 we were finally able to easily split Excel between two screens and happily copy and paste between the two with full paste capability and without the worry of worksheet [...]

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 [...]

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 [...]

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 [...]

Could your KPIs do more?

In the current environment, reducing costs and increasing productivity are the keys to success. This was emphasised strongly by a recent PriceWaterhouseCoopers (PwC) report which found that profits at the world's top 40 mining companies, including BHP Billiton and Rio Tinto, slumped by half between 2011 and 2013 as the mining boom came off its [...]