SIMPLE SOFTWARE & PRODUCTIVITY SOLUTIONS
Master Excel like a pro! Discover lesser-known functions of Excel such as text, logical, statistical and financial tools. These hidden gems will help you save time and work smarter…
Want to master Excel VLOOKUP? Find easy-to-follow steps in this excel VLOOKUP tutorial. Boost your skills and save time on your data tasks!
Using hyperlinks is a great tool to save time and space. Learn how to create a hyperlink in Excel and Word, how to link both files together, link to external sources, edit appearance, and more. Here, we have all sorts of troubleshooting tips.
Learn how to recover an Excel file that crashed, was deleted or accidentally saved over. Retrieve deleted tabs, repair corrupted files and more.
Save yourself the hassle of constantly scrolling through your data! Start using the freeze pane feature for large spreadsheets. Learn to fix your top row, column or section for quick reference and easier navigation…
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…
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…
After spending hours on a complex spreadsheet, you don’t want anyone tampering with the formulas. learn how to protect cells in Excel; lock cells, set edit ranges, password protect & more…
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!
Speed up your progress; familiarise yourself with ways to select multiple cells in Excel, specific ranges, and more. Grab your free cheat sheet here…