by Nico Mellett | Nov 7, 2023 | Article, post, Tutorial
Microsoft Excel is a powerful tool for data analysis and visualization. A useful feature is the ability to add comments to cells to provide additional information or context. However, sometimes comments can clutter your worksheet or overlap with important data. In...
by Nico Mellett | Nov 7, 2023 | Article, post, Tutorial
If you have first names in one column and last names in another column, you can easily combine the two names in a third column, using Microsoft Excel. In this tutorial, we will show you the steps to do exactly this. Step 1: Prepare Your Data The first step in...
by Nico Mellett | Oct 25, 2023 | Article, Excel Functions, post, Tutorial
You can use Microsoft Excel to determine the interquartile range (IQR) by following these steps: Step 1: Organize Your Data Before you calculate the IQR, ensure that your data is organized in a column within an Excel spreadsheet. Step 2: Find the Quartiles You can use...
by Nico Mellett | Oct 25, 2023 | Article, post, Tutorial
Introduction Excel is a powerful tool for performing a wide range of calculations, and one common task is calculating percentages. Whether you’re working on financial spreadsheets, data analysis, or any other project, knowing how to create a percentage...
by Nico Mellett | May 2, 2023 | Article, post
Financial modelling is an essential tool for businesses, investors and financial analysts. It is a process of creating a mathematical representation of a financial situation or system using various financial concepts and data. The aim is to create a model that can be...
by Linda | Mar 23, 2021 | Article, post, Tutorial
Microsoft’s own definition of a Pivot Table is “a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data”. Whenever you have information in a tabular set of data (or list) in Excel, you can create a...