BLOG

10 Most Useful Microsoft Excel Tips

Posted on Dec 01, 2017 by Marc Zao-Sanders


30 years since entering the market Microsoft Excel remains the most widely used software by businesses. Despite its wide use, the full capabilities of Excel are still poorly understood. Of 100,000 workers we tested over the past three years, less than half know what Conditional Formatting - an essential feature - even does.

So what are Excel's essentials? We reviewed articles written by Excel experts and combined this with aggregated data from thousands of our users to compile a list of the 100 most useful Excel functions and features including PivotTables, Absolute References, Conditional Formatting and more.

For all those in need of a quick dose of tips to improve their Excel proficiency check out the top 10 tips below. But do download the full 100 and make your way through it to get the most out of this wonderful guide.

So let's start!

Continue reading...

Topics: Microsoft Excel, Learning

Calculating data correlation

Posted on Dec 12, 2016 by Alan Gurney

Correlation.png

 

Are you often asked to study and find trends in data?

When two quantities are highly correlated the value of one tells you a lot about the value of the other. The opposite can be said when they're uncorrelated.

Being able to calculate the degree of correlation between a series of statistics allows you to identify trends and make predictions. You can achieve this by calculating the correlation coefficient, a figure between 0 and +/-1 that shows the degree to which variables are correlated.

Continue reading...

Topics: Microsoft Excel, Analysis

Protect your spreadsheet

Posted on Nov 21, 2016 by Alan Gurney

Protection.png

Do you create and collaborate on spreadsheets with your colleagues? Want to ensure your workbooks retain all of the correct data and formulae?

The most important consideration when working with Excel is that you get the right answers. However, it only takes one user who doesn’t understand how the spreadsheet works (e.g. overtyping a formula with a fixed number), and your data will be filled with uncertainty.

Continue reading...

Topics: Microsoft Excel, Productivity, Microsoft Office

Three special charts for analysing data

Posted on Oct 07, 2016 by Alan Gurney

 

Charts.png

Do you often have to present the findings of your analysis to colleagues or senior management? Choosing the most appropriate graph can be tough but is imperative for a successful meeting.

Continue reading...

Topics: Microsoft Excel, Business, Analysis

The principles of modelling

Posted on Jul 12, 2016 by Alan Gurney

noun_362507.png

Do you ever use Excel to run simulations of business situations?

Excel Models are representations of a real-world financial scenarios. This could be anything from a calculation to estimate the costs for an event you're attending to a spreadsheet with macros that forecasts financial performance.

Models can be pretty complex, but there are some simple principles to bear in mind when creating them:

Continue reading...

Topics: Microsoft Excel, Analysis, Productivity

Three great uses of Excel

Posted on Jul 05, 2016 by Paolo Lenotti

Microsoft Excel is still business critical. 30 years since its launch, it's more popular than ever: 1 billion people use it, with workers in finance spending a third of their day in the program.

However Excel can be overwhelming. Today we share three key features we think you should focus on. Give them your best shot!

Continue reading...

Topics: Microsoft Excel

Top 10 New Features of Excel 2016

Posted on Feb 26, 2016 by Alan Gurney

Excel 2016 was released a few months ago and considering how much we love Excel we thought it only right to give you the lowdown on our favourite new features in Microsoft's latest version of the popular spread sheeting programme. 

Continue reading...

Topics: Microsoft Excel

Is Excel still a spreadsheet?

Posted on Apr 09, 2015 by Simon Hurst

Things were delightfully simple in the early days of spreadsheets. The distance from multi-column analysis paper to its on-screen equivalent was relatively small – just involving a whole lot less Tipp-Ex and doing the calculations for you. Very quickly, as we moved from VisiCalc to SuperCalc to Lotus 1-2-3 and Excel, the capabilities of spreadsheets increased. As well as moving from single sheets to books of multiple pages, available calculations and functions became more extensive, macro and programming languages were included, and graphs and charts were introduced.

Continue reading...

Topics: Microsoft Excel

Five Reasons for Microsoft Excel Training

Posted on Mar 19, 2015 by Simon Hurst

To avoid career-threatening errors

Ok, so it doesn’t happen every day, but there are lots of horror stories about disastrous spreadsheet errors. An Excel catastrophe can strike anywhere and anyone: from Harvard professors whose internationally-renowned research on government austerity was found to contain a significant error in a spreadsheet formula to a UK government department that failed to understand the assumptions a spreadsheet was based on, costing their taxpayers £millions.

Continue reading...

Topics: Microsoft Excel

7 Benefits of Excel Online Training

Posted on Feb 19, 2015 by Chris Kyriacou

Online training still has its sceptics. However, there is no doubt that e-learning has been a growing industry worth $55.2 billion with the type of learning technologies available doubling in the last five years, demonstrating human behaviours shift towards how we choose to learn in recent times.

Continue reading...

Topics: Microsoft Excel, Online Learning