Rock Paper Scissors
Here we look at how to use drop-down lists, lookups and conditional formulas to teach Excel to play "Rock Paper Scissors".
Here we look at how to use drop-down lists, lookups and conditional formulas to teach Excel to play "Rock Paper Scissors".
Here we look at the many uses of the INDEX(MATCH()) combo formula, and why it is a superior replacement for the commonly-used VLOOKUP() and HLOOKUP() functions.
Here we look at a formula that will calculate the duration of a project in working days, and learn how to express the % completion of a project against its target duration.
Here we look at a formula that will calculate the tax year for any given date. Ideal for Expenses forms and accounting functions.