-
Excel tips: Named ranges
Named ranges are one of the MOST under utilised functions in Excel, and that’s a huge shame as it can save time, reduce the risk of error and make formula’s easier to enter, read and understand. Part of the reason.
-
Excel tips: How to amend a CSV file without a direct bank feed
-
Excel tips: Subtotals based on a petty cash scenario
-
Excel tips: Vlookup vs Index/Match
-
Excel study tips: Creating lists with validation
-
Excel tips: Creating financial statements series part 3 – Using basic functionality
-
Excel tips: Creating financial statements series part 2 – How to avoid errors w...
-
Excel tips: Creating financial statements part 1 – Creating an extended trial b...
-
Excel tips: how to use the VLOOKUP function
-
Excel tips: how to write an IF statement
-
The ultimate crash course in Excel – part 7
-
The ultimate crash course in Excel – part 6
