Paste Special

Using Paste Special This quick video explains using Paste Special in Excel. The Paste Special button allows us to change the behavior of the standard Paste command – and includes special features allowing us to transpose cells, copy just the values (without the...

How to find the minimum value in Excel (while ignoring the 0 value)

How to find the minimum value in Excel (while ignoring the 0 value) How to find the Minimum Value in Excel. In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows...

The Choose Function, the Alternative to the IF or Vlookup

The Choose Function, the Alternative to the IF or Vlookup The Choose function is categorized in the latest versions of Excel as a Lookup and Reference formula, it returns a value from a set list of arguments based on a given position. The function looks as follows:...