Resources

Purchase spend
Gallery
Purchase spend

Purchase spend

Nodewise2023-06-18T16:18:26+02:00Tags: MATCH, Naming, Number Formats, Structure, Style, SUMIFS, VLOOKUP|

Management requires an overview report of purchase spend.

Conditional Formatting
Gallery
Conditional Formatting

Conditional Formatting

Nodewise2023-06-18T16:09:40+02:00Tags: Conditional Formatting, Data Validation, Naming, Number Formats, Tables|

Conditional Formatting changes how a cell is displayed based on the cell value.

Data Validation
Gallery
Data Validation

Data Validation

Nodewise2023-06-18T16:08:44+02:00Tags: Data Validation, Naming, Pivot Tables, Tables|

Data Validation is used to force certain predetermined alternatives or value formats when inputting values.

Naming
Gallery
Naming

Naming

Nodewise2023-06-18T16:07:40+02:00Tags: Naming, Pivot Tables, Structured References, Tables|

When using Naming properly your workbooks become more dynamic, with fewer errors, improved readability and traceability.