News
-
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.
-
How to Forecast Using Average Percentage Growth
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 look at the simplest: an annual level of growth that would take you from the first year’s level to the last. -
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.
-
Say 'Hello, World' in 53 Different Programming Languages
Computers are dumb. They only do what they’re told. How do you tell a computer what to do? You use a programming language. The very first thing you’ll do when learning a new programming language is how to make the computer display “Hello, World”.
-
How to Use VLOOKUP, HLOOKUP, and INDEX MATCH in Excel
Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve this including VLOOKUP() and HLOOKUP() and the more flexible - but slightly more complicated -combination of INDEX() and MATCH(). -
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. -
The Definitive 100 Most Useful Excel Tips
Excel is still the world’s favourite business software. 750 million knowledge workers use it for at least half an hour every single working day, and Microsoft CEO Sadya Nadella believes it’s still the most important Microsoft software. So it made sense for someone to make a list of the 100 Definitive Most Useful Excel Tips.
- Previous page
- Page 2 of 2
Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.