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. [vc_empty_space height="20px" image_repeat="no-repeat"][vc_column_text] 1. Be consistent Make spreadsheets...
Read More
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 don't know,...
Read More
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...
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
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 foreign. However,...
Read More
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...
Read More
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...
Read More
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...
Read More
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 take a...
Read More
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 which can...
Read More