Excel

Learn fast and easy techniques for Microsoft Excel.

How to Enable Macros in Excel

HOW TO ENABLE MACROS IN EXCEL

Discover the magic of Macros! Record your actions so you don’t have to keep repeating them. Here, you will learn how to enable, record, run, edit and disable Macros in Microsoft.

How to Protect Cells in Excel - Lock, Edit Ranges, Secure Workbook

QUICK TIP: HOW TO PROTECT CELLS IN EXCEL

After spending hours preparing a complex spreadsheet, the last thing you want is your formulas or layout tampered with. Stay confident by learning how to protect cells in Excel. Lock cells, set edit ranges, password protect and more…

How to find duplicates in Excel

HOW TO FIND DUPLICATES IN EXCEL

Who has time to manually search for duplicates in huge spreadsheets? Luckily, Excel can do this tedious task for you. Learn how to find duplicates in Excel, sort, highlight after the first instance, find unique values and remove duplicates…

How to freeze the top row in excel and split windowQUICK TIP: HOW TO FREEZE THE TOP ROW IN EXCEL & SPLIT WINDOW

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…

Convert Excel spreadsheet to PDF

CONVERT EXCEL SPREADSHEET TO PDF – SAVE SELECTIONS, SEPARATE WORKSHEETS AND MORE

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…

How to sort tabs in excel

HOW TO SORT TABS IN EXCEL – MOVE, COLOUR CODE AND MORE

Using Excel tabs, you can save space and keep your data sorted and protected. Hide sensitive information, colour code worksheets, add, copy and rename tabs and more…

use basic excel formulas fast and easy

USE BASIC EXCEL FORMULAS – FAST AND EASY

Stop slaving over monotonous spreadsheets! Using formulas can save you hours of undue labour. You don’t need to be an Excel expert or a maths whizz…

Select Multiple Cells in Excel

SELECT MULTIPLE CELLS IN EXCELS

We tend to stick with what we know but learning quick alternatives can speed up progress in the long run. Familiarise with ways to select multiple cells in Excel, specific ranges and more. Grab your free cheat sheet here…

Advertisements