-
Excel tips: Avoid mistakes with protect sheet
Have you ever been working on a spreadsheet and got distracted... and before you know it, you’ve overwritten all of your clever formulas? Or, someone else accesses your file and overwrites your formula’s with values?
-
10 principles for good spreadsheet practice – Part 1
-
10 principles for good spreadsheet practice – Part 2
-
Excel tips: Save time with named ranges
-
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
