The context for Power Pivot… If you are a frequent Excel user, then you are probably familiar with pivot tables. They are used for figuring out quick insights from small amounts of data and can also be turned into easy to understand graphs. But even... ...

...

There is no excerpt because this is a protected post. ...

...

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

Microsoft has been making a not so subtle attempt to push its 1.2 billion Office users towards Office 365 for some time. This has been mostly successful. Over 120 million people have active Office 365 accounts and adoption is up 34% since 2016 and now... ...

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

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

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

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

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

‘New year, new me’… how many times have you heard that? Or even said it yourself? After eating too much over the festive season, we were feeling guilty and began looking for redemption online. We found some useful Excel spreadsheets which could help you (and... ...

You’ve been working for weeks, brushing up on your presentation skills and creating the perfect slideshow for a big meeting with some high profile clients. The day is here. The information is memorised. The slides are in order. You got to the room early to... ...

Excel punches above its weight in value-add, to both your salary and the performance of your organisation   In the crowded job market, you need to stand out to secure a decent role. Once in a role you equally need to stand out if you... ...

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,... ...

There are simple things you can do in Microsoft Excel that can hugely impact your presentation style and help you create powerful presentations. These 3 Excel tips are easy to implement regardless of whether you are a beginner, intermediate or advanced Microsoft Excel user. 3. Be relevant Make important... ...

...

The PivotTable function is one of the most widely used features of Microsoft Excel. It allows you to analyse and visualise data in various ways that can provide deep insights. If you have never used pivot tables in Excel or would like to build on... ...

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

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

One of the handiest but most daunting spreadsheet skills for business must be VLOOKUP in Microsoft Excel. By simplifying the search data in Excel, it has become a mainstay for many spreadsheet users.   For anyone new to the VLOOKUP feature, it may seem overly technical and... ...

Glorious Microsoft Excel. Guardian of business knowledge, unlocker of data secrets. Frustratingly inaccessible to many people. Excel can be painful, but learning to make sense of it can also be the best investment in your business skills that you ever make. We see people of... ...

Applying styles to your spreadsheets is not simply a matter of style over substance. Formatting allows you to emphasise and delineate your data, enhancing both its clarity and your presentations. Styles is a tool that allows you to more quickly and easily apply consistent formatting to your spreadsheet using... ...

Sparklines are very small charts that fit within a line of text or a single cell of a spreadsheet. They’re a great way to give your data some context without taking up half the page with various bulky charts. As they are so small, they are typically... ...

Excel is, at its heart, a programme that manipulates numbers: so getting your numbers to appear as you want is an important skill. The appearance of a number entered in an Excel cell can be changed in many different ways. This blog post shows you... ...

Average percentage growth tells us how fast something has grown, and eventually forecasts the future through extrapolation.   There are different ways of calculating average growth in Excel (e.g. LOGEST, LINEST, lines of best fit, etc.) and some of these will give different results. Let’s... ...

Inconsistencies can creep into spreadsheets for a range of causes: data-entry errors; accidental changes made to the data after entry; inconsistently applied rounding or changes to units; or differences in the way numbers are formatted in different systems.   The following is a simple technique... ...

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

Excel gives you many options when it comes to filtering your data. If you have a database with numerous entries, you can filter the data so that only the relevant information appears. Then, when you remove the filter, you can see all of your data... ...

  Congratulations on receiving your Excel with Business Microsoft Excel IQ certificate. You can now add this to your LinkedIn profile!       The Excel IQ™ is modelled on traditional and well-established means of IQ scoring (e.g. a score of 100 is ‘average’) and... ...