Shuffling data with HLOOKUP

Here is a great and effective approach to shuffle columns of data. It will use the Excel HLOOKUP function, and not require any VBA macros or complicated re-engineering of this summary worksheet.

Excel Traffic Lights

There are many ways to verify or analyse financial outputs. Clearly all financial outputs must be correct, but the financial analyst must be able to deliver added value via summaries, dashboard and Excel charts. This article and video will focus primarily on Excel Traffic Lights, via Excel Conditional Formatting, in order to improve the analytical demonstration of high-level financial performance