It’s time to sharpen those spreadsheets with this nifty guide – and the best part? It’s totally FREE! Ensure those spreadsheets are up to scratch by considering these twenty principles. Put together by the Institute of Chartered Accountants in England and Wales (the ICAEW) and written......
[/vc_column][/vc_row]...
One of the most useful but 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......
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......
Tip of the month – also useful in forecasting. 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......
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......
We often have an ordered list of items each with an assigned value such as revenue or cost which we need to analyse and understand. It is sometimes important to know how these numbers are adding up in order that we can be......
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 have all of your data. Built......
in How To
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, which will help you learn the most common Mac Excel keyboard shortcuts used by financial analysts, consultants, and top 10 MBA school students. As......
in Excel Technology
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 crunching......
Some of the most pleasing functions in Excel are those that help to make sense of indigestible large data sets. One such function, which is great at helping turn data into insight, is SUMIF(): a powerful function that adds up numbers across categories. Imagine we......
in How To
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 actually 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 picture......
in Excel Technology
‘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 looking for redemption online. We found some useful Excel spreadsheets which could help you (and us!)......
in Excel
About this Class Excel is one of the most powerful tools in business, yet too many people have 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 formulas......
TOP 10 EXCEL FORMULAS YOU NEED TO KNOW About this Class Excel is one of the most powerful tools in business, yet too many people have a basic understanding of how to get the most out of it. Knowing which formulas to use......
