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.
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!
Learn how to convert Excel spreadsheet to PDF. Save entire workbooks or specified sections, or create separate PDF documents for each of your worksheets. Read on to find out how easy it is…
