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 we will be setting the minimum input value for aContinue reading “Microsoft Excel – Set a minimum input value”

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 we will be setting the maximum input value for aContinue reading “Microsoft Excel – Set a maximum input value”

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 counts by country, and weather information by city. To createContinue reading “Microsoft Excel – Create a map chart”

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 to removing any data from a spreadsheet you may wantContinue reading “Microsoft Excel – Find all dependant cells”

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 of seconds. This will highlight and select any row differencesContinue reading “Microsoft Excel – Highlight differences between two rows”

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 the steps below. Excel should then return your image withContinue reading “Microsoft Excel – Remove Image background”

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 are required for loss representation. To add sparklines to youContinue reading “Microsoft Excel – Draw win/loss sparklines in cell”

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 this carry out the following steps. A new set ofContinue reading “Microsoft Excel – Get the percentage of Total (The EASY way)”

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 to appear before our number sequence and our sequence isContinue reading “Microsoft Excel – Create a sequence of days”