Cleaning data in Excel
Use three Microsoft Excel functions to identify and then correct a common mistake that occurs when first name and surname…
Copy-paste and moving Excel worksheets
The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered…
Mastering Excel’s VLOOKUP() function
Possibly the most advanced function in the ICT and CAT curricula, Excel's VLOOKUP is something that can easily be mastered…