Browse all of our latest posts here.
Microsoft Excel – Set a minimum input value
In this post we will be setting a minimum input value for cells within an Excel spreadsheet. To achieve this we will use a data validation function to restrict the type of data or the values that users enter into a cell. In this example…
Microsoft Excel – Set a maximum input value
In this post we will be setting a maximum input value for cells within an Excel spreadsheet. To achieve this we will use a data validation function to restrict the type of data or the values that users enter into a cell. In this example…
Microsoft Excel – Create a map chart
In this post we will be creating a map chart within Excel, a map chart will allow us to display data on a map. These charts can be beneficial for displaying data that has a correlation with geographical locations, including sales figures by region, population…
Microsoft Excel – Find all dependant cells
In this post we will be highlighting any dependant cells within an Excel spreadsheet, to do this carry out the following steps below. Dependant cells are those that contain a formula that refer to other cells. This process can be especially useful for example prior…
Microsoft Excel – Highlight differences between two rows
In this post we will highlight any differences that may exist within two rows in our Excel spreadsheet, to do this carry out the following steps below. This process can be especially useful to find any outliers or anomalies within your spreadsheet in a matter…
Microsoft Excel – Remove Image background
In this tutorial we will be going through the process of removing the background of an image within an Excel spreadsheet. To do this we will be using Excels built-in picture formatting tools. To remove background of an image in an Excel spreadsheet carry out…
Microsoft Excel – Draw win/loss sparklines in cell
In this tutorial we will be drawing win/loss sparklines within an Excel spreadsheet, these are especially useful in showing trends in data. Sparklines are small charts that appear within a cell and are typically drawn without axes or coordinates. Note that for win/loss sparklines negative values…
Microsoft Excel – Remove all images from an Excel spreadsheet
In this tutorial we will be removing all images from an Excel spreadsheet without having to do the same action for an image each time. To do this carry out the following steps below. All images on the spreadsheet should now be removed.
Microsoft Excel – Get the percentage of Total (The EASY way)
In this tutorial we will be retrieving the percentage of total for the data within our Excel spreadsheet, this will enable us to a further breakdown of our data and help us understand what may account for our biggest winners and even losers. To do…
Microsoft Excel – Create a sequence of days
In today’s Excel tutorial we will be creating a sequence of days within an Excel spreadsheet without the need for any manual repetition. To do this type ‘=”Day “&SEQUENCE(100)’ in to a cell and then press ‘Enter’ The “Day ” is the text we want…
Microsoft Excel – Add new rows the easy way
In this tutorial we will be going through the adding of new rows to an Excel spreadsheet. This task often takes a lot longer than it should, find out how to carry this out efficiently in the steps below.
Microsoft Excel – Draw column sparklines in cell
In this tutorial we will be drawing column sparklines within an Excel spreadsheet, these are especially useful in showing trends in data. Sparklines are small charts that appear within a cell and are typically drawn without axes or coordinates. To add sparklines to you Excel spreadsheet…
Loading…
Something went wrong. Please refresh the page and/or try again.