HOW TO RECOVER AN EXCEL FILE
Learn how to recover an Excel file that crashed, was deleted or accidentally saved over. Retrieve deleted tabs, repair corrupted files and more.
spreadsheets
HOW TO FIND DUPLICATES IN EXCEL
Who has time to search for duplicates in spreadsheets? Luckily, Excel does this for you! Learn how to find duplicates in Excel, sort, highlight after the first instance, remove and more…
HOW TO CREATE EXCEL DROP-DOWN LIST, AUTOFILL & FLASH FILL
Save time with drop-down lists, AutoFill & Flash Fill. Excel can identify patterns, automatically fill cells, set up message alerts & more. These quick functions will eliminate manual data labour…
HOW TO ENABLE MACROS IN EXCEL
Learn how to Enable Macros in Excel so you don’t have to keep repeating the same actions. Record, run, edit, disable, and more – discover the magic of Macros!
QUICK TIP: SELECT MULTIPLE CELLS IN EXCEL
Speed up your progress; familiarise yourself with ways to select multiple cells in Excel, specific ranges, and more. Grab your free cheat sheet here…
HOW TO SORT TABS IN EXCEL – MOVE, COLOUR CODE & MORE
Save yourself from being swamped with workbooks you don’t need! Learn how to sort tabs in Excel; hide sensitive information, copy, move, rename, colour code and more…
USE BASIC EXCEL FORMULAS – FAST AND EASY
Stop slaving over monotonous spreadsheets! Learn how to use basic Excel formulas and save yourself hours of undue labour. You don’t need to be an Excel expert or a maths whizz…