IFS Function

IFS Function

The IFS function enables you to perform multiple outcomes based on multiple conditions. This significantly simplifies how to perform this sort of task. Until recently you would have needed to combine IF functions inside of IF functions which was referred to as nested...
How do you SWITCH data in Excel?

How do you SWITCH data in Excel?

Until Excel 2019 the SWITCH function did not exist but since then it has provided a viable alternative to using nested IF functions, IFS or VLOOKUPs. It evaluates one value (called the expression) against a list of values and returns the result corresponding to the...
Cell Styles in Microsoft Excel

Cell Styles in Microsoft Excel

Consistent formatting helps to make documents look tidier and makes them easier to read and understand.  One feature that can help with this is cell styles.  There are over 40 pre-created styles for you to get started with or you can create your own bespoke designs to...

MEMBERSHIPS

FOLLOW LARA