Digital Wizard Training

This video describes how to use the SumIf function. This function allows you to select which values you wish to add up from a column of values, e.g. all sales of a particular product.

This video takes a look at combining the IF fucntion with the AND function as well as the OR function

This video takes a look at incorporating the OR function into an IF function to test for multiple logical tests.

This example looks at incorporating the AND function into the IF function so that more than 1 logical test can be performed.

This week we are taking a look at a couple of examples of how to use the Excel IF function.

This video takes a look at a couple of alternatives to storing macro in only 1 workbook.

This week we will take a look at expanding the versatility of the Conditional Formatting tool by using a formula.

Add a secondary axis to your Excel Chart to better display your data