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...
Filled Maps in Excel

Filled Maps in Excel

Do you work with geographical data?  By showing this information on a map the data can be understood more easily.  It can be used with countries, counties or post codes. Setting up the data for filled maps The first step involves creating a simple summary table...

MEMBERSHIPS

FOLLOW LARA