Word and Excel documents hosted on SharePoint (including Teams and OneDrive) automatically open in the web browser - which provides a basic experience. Often it is more efficient to open…

Calculating the first Monday of a yearly quarter in Excel can streamline scheduling and reporting tasks. This guide will show you how to use a formula to find the first…

Excel can help manage team rosters, including automating two-weekly rotations. This guide shows how to use a formula in Microsoft Excel to automatically display the current roster week, alternating between…

The following instructions show how to use conditional formatting in Microsoft Excel to automatically highlight the current week, based on a column with a "Week Commencing" date (a Monday). This…

The following VBA script shows how to remove attachments from emails in Outlook and save them to your local machine. The script will also note in the email body that…

The following guide shows how to use checkboxes in your Excel documents. This guide uses the form control method to handle checkboxes - not the ActiveX method that is more…

The following guide shows four different ways to insert tick and cross symbols in Excel documents. Ticks and cross symbols are useful visual cues in a dataset, typically representing "yes/no"…

The following Excel formula demonstrates how to calculate the non-GST value from a GST-inclusive amount. For example – If you have a GST-inclusive amount of $120 with a GST rate…

Learn how to quickly remove HTML tags from text in Excel using the Find and Replace feature in this step-by-step guide.