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

  Microsoft Excel was the first successful spreadsheet (an interactive computer application program for organization and analysis of data in tabular form) of its kind back in 1985, an improved version of Microsoft’s failed original spreadsheet Multiplan in 1982.     There are now a variety of spreadsheets available,... ...

  Our latest blog post is from guest blogger Al-Chen, Co-Founder at KeyCuts – a range of Excel keyboard covers. Learn the most common Mac Excel keyboard shortcuts used by financial analysts, consultants, and top 10 MBA school students.   As we all know, Microsoft... ...

Here are five tips borne of hard hours grafting through messy databases in search of some grains of gold. Sounds like an exaggeration? Think again… or at least have a read first!   1. Preserve your source data When you’re about to spend your weekend... ...

...

Some of the best functions in Excel are those that help to make sense of indigestible large data sets. One function, which is great at helping turn data into insight, is SUMIF(): a powerful function that adds up numbers across categories. Imagine you are in charge of three shops... ...

Today’s best marketers and growth hackers are data-driven. They are able to pull data about their marketing campaigns and use that data to get a clear picture of what’s working (and what’s not).   A key component of being data-driven is the ability to quickly... ...

One way of judging the importance of different Excel features is to look through the ‘Must Have’ section of relevant job descriptions. You’d probably be surprised at how often PivotTables appear.   One of the great benefits of PivotTables is that they are not just... ...

An Easter egg is an inside joke, hidden message or feature in a work such as a computer program, film or book.   In computer software, Easter eggs are secret responses to an undocumented set of commands. The results vary from a simple message or... ...

Making good use of Excel formulas can have a dramatic effect on your productivity. There are over 400 Microsoft Excel functions to choose from though, so this video tutorial will guide you through the top 10 formulas to improve your speed and effectiveness in managing... ...