Test Menus 24 March 2021

Introducing EASY Excel

Spreadsheets that are Error-free, Accurate, Sustainable and Yours

Error-free: use controls and smart design to reduce the risk of errors

Accurate: use checks and balances to make sure it all adds up

Sustainable: ensure your spreadsheets can be handed over to other users

Yours: develop a distinctive and recognisable style

Based on 20+ years using Excel in senior accountancy and consulting roles, these posts will improve the spreadsheets you use for:

Volatile Functions

Avoid functions that can slow Excel down

Dynamic Ranges

Easy to maintain data ranges

Tolerance Charts

Show ranges of uncertainty in your line charts

Copy-Paste not Copy-Break

Make spreadsheets more robust with Formula Ranges

Camera Tool

Improve the impact of your reports using Excel's Camera tool

Helper Columns

Have simpler formulas by using Helper columns


Copyright: Enigmalytics 2020