• 2017
  • How Learning Excel Can Increase Your Salary 4X Over Your Career

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

  • 3 Steps to Create Powerful Presentations with Excel

    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 Definitive 100 Most Useful Excel Tips

    Excel is still the world’s favourite business software. 250 million knowledge workers use it for at least half an hour every single working day.   As we’ve sold half a million Excel courses ourselves, we have a lot of data on what people know and... ...

  • Pivot tables in Excel
    Pivot Tables in Excel: How to Use the PivotTable Function

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

  • 20 principles all Excel users should follow. Do you?

    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 Fundamentals Live Course

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

  • How to use VLOOKUP in Microsoft Excel
    How to use VLOOKUP in Microsoft Excel

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

  • 80% of people answered these questions on Excel incorrectly

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

  • Style Your Spreadsheets to Present Data More Clearly

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

  • How to Represent Trends with Sparklines

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

  • How to Format Numbers in Excel

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

  • How to Forecast using Average Percentage Growth

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

  • Spotting Inconsistencies with “=…=…”

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

  • Done In 60 Seconds – Cumulative Sums

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

  • How To Excel – Use Filters to Get the Data You Want

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

  • How to Add your Excel IQ Certificate to your LinkedIn profile

      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 Versus Apple’s Numbers: Who prevails?

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

  • 5 Microsoft Excel Hardware/Software Add-Ons to Boost Your Productivity

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

  • 5 Microsoft Excel Powerhacks that will Make your Day

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

  • SUMIF Excel Function
    How to Summarise Data with SUMIF()

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

  • Why SQL is Useful for Marketers

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

  • PivotTables – A ‘Must Have’ Excel Skill

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

  • 10 Easter Eggs are (Much) Better than None

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

  • Workout Tracker, Calorie Counter…All in Excel

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

  • TOP 10 EXCEL FORMULAS: LIVE CLASS REPLAY

    About this Class   Excel is one of the most powerful tools in business, yet too many people have only a basic understanding of how to get the most out of it. Knowing which formulas to use and being able to combine or nest different... ...

    2016