Fresh Excel Tips

To determine the smallest value in a list, we can use the MIN function. However, the easiest way to find multiple small values of a range is by using the SMALL function. This function returns the nth smallest value in a set of data. Here is the syntax that is used for the SMALL Function: SMALL(array, [...]

In this tutorial we will teach you how to convert from Fahrenheit to Celsius in Excel as well as how to convert from Celsius to Fahrenheit. For our first example, we will use the first formula, =(Fahrenheit–32)*5/9. Here is how we will make the conversion. How to convert from Fahrenheit to Celsius: Open Microsoft Excel. This formula [...]

For this example, we are given a list of products, their sales prices and cost prices and are asked to design a formula that would determine the profitability of eash item, thus giving us a quick and easy insight into which products are the most and least profitable. To achieve this goal, we will need [...]

For this example, we will create a worksheet given the start and end dates of a certain production line. In order to determine the average output of this production line, we will need to use the production line’s output over the start and end dates. With that said, here is how we would go about [...]