In this tutorial we are going to see how we can locate a value within a data range and then return the header information for the location of that value.
In this tutorial we are going to look at the Auto Complete option in Excel, and a very useful and time-saving feature that Excel offers.
In this tutorial we are going to look at the Logarithmic Scale option for formatting charts. This option allows you to more easily see the variances between significantly different sets of data, without using a secondary axis.
In this tutorial we are going to review how you can transpose a range of data and keep the original and the transposed range linked, so that if you change anything in the original, the transposed range will also change.
In this tutorial we are going to look at how easy it is to hide errors in cells when you are printing your documents.
In this tutorial we will review how different time formats will change the view of the results when you are adding a list of cells with time, and could give you what appears to be incorrect answers.