# News

• ## The COUNTIFS Function in Excel

COUNTIFS is a powerful statistical function that forms part of the wider Excel Statistical functions category. If you've used the COUNTIF function ...
• ## 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.
• ## Workout Tracker, Calorie Counter… All in Excel

‘New year, new me’… how many times have you heard that? Or even said it yourself? After overeating 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 us!) stay fit this year.
• ## 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 once more. Built-in comparison operators such as “greater than”, “less than”, “between”, “top 10” or even custom filters can show the data you want and hide the rest.
• ## Microsoft Excel Versus Apple's Numbers: Who Prevails?

Excel provides an overwhelming amount of functions in comparison to Apple’s Numbers, but it can be argued that they both appeal to different spreadsheet users. Excel supports advanced charting and plotting features not available in Apple Numbers. However, Apple’s charts are more visually stimulating (as seen below). So which is right for you?
• ## PivotTables in Excel: How to Use the PivotTable Function

The PivotTable function allows you to analyse and visualise data in various ways that can provide amazing insights. If you have never used pivot tables in Excel or would like to build on your basic knowledge, you're in the right place.
• ## Analysing Large Datasets with Power Pivot in Microsoft Excel

Even Excel has its limitations. When combining tables, manipulating large datasets over one million rows, or selecting data from multiple sources, Excel will struggle. It can be frustrating to have Excel quit unexpectedly or run extremely slowly or time out and need a forced shutdown!

So, what happens if you have over one million rows (1,048,576 to be exact) of data? You use Power Pivots.

• ## The Top 10 Excel Features

We consulted the research of 30 of the world's leading Excel experts as well as our own internal Excel experts. We then grouped up and consolidated the emerging features, and applied a scoring methodology and index to produce a definitive ordered list of the 100 most useful Excel features, hacks, tips and tricks.

These are the top 10 Excel features as determined by our ranking.

• ## 10 Excel Formulas Every Beginner Should Know

By knowing a few key formulas, you can do a variety of actions in Excel that will increase your productivity and decrease the risk of making calculation mistakes. We’ve put together 10 Excel formulas you need to get started.
• ## 15 Excel Data Analysis Functions You Need to Know

If you’ve ever used Excel, then you’ve probably experienced the agony of choosing an incorrect formula to analyze a data set. Maybe you worked on it for hours, finally giving up because the data output was wrong or, the function was too complicated, and it seemed more straightforward to count the data yourself manually. If that sounds like you, then this Data Analysis in Excel top 15 is for you.