If you’ve ever used Excel, then you’ve probably experienced the agony of choosing an incorrect formula to analyze a data set. Maybe you worked on it for hours, finally giving up because the data output was wrong or, the function was too complicated, and it...
Read More
Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve...
Read More
The IF function is one of the most useful you will ever learn in Microsoft Excel. It's also incredibly simple and can unlock some seriously juicy functionality when you start nesting IF statements. In this post, we’ll show you how to do an IF and a...
Read More
PivotTable or pivot table. You may have heard of them… In our opinion, they are one of the MOST powerful things you can learn in Excel. The great news is, they are pretty easy to get the hang of. Before PivotTables were introduced into Excel, you had...
Read More
Did you know that you can restrict, give guidance on and create drop-down lists for what you can enter in a certain cell in Excel? It’s a pretty cool feature and it’s called Data Validation. However carefully you design your spreadsheets, even if you lock cells...
Read More
They say you never forget your first time. It’s true. My first experience of Microsoft Excel is burned forever into my mind. I was in my first graduate job, fresh from a humanities degree. I’d written plenty of essays, but few of these required any...
Read More
This article was originally published on Business Insider Every Excel user has their own favourite tip. So we decided to bring some method, data, and science to bear in this hotly debated topic. We consulted the research of 30 of the world’s leading Excel experts, our own...
Read More
It’s time to sharpen those spreadsheets with this nifty guide – and the best part? It’s totally FREE! Ensure your spreadsheets are up to scratch with these twenty principles. Put together by the Institute of Chartered Accountants in England and Wales (the ICAEW) and written by 17 Excel...
Read More
On 21 June, we launched our first Excel Fundamentals Live Course, held over 4 weeks. Each week we held an hour-long interactive lesson with course expert, Deborah Ashby. Aimed at beginner to intermediate level Excel users, the course covers a range of topics, starting with the...
Read More
Have an ordered list of items, each with an assigned value such as revenue or cost, which you need to analyse and understand? Perhaps you need to know how these numbers are adding up in order to be alerted to business limits (budgets, deadlines etc,) being approached...
Read More