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.

Learn how to easily calculate Australian financial years from dates in Excel with our step-by-step guide and formula examples.

​Learn how to use Excel formulas to select the smallest date from a table in Excel 2016. Discover three methods to find the first date by name or in the…

​In an Excel document, learn how to troubleshoot and solve the issue when Excel won't allow inserting new rows due to either protected documents or table formatting. Find step-by-step solutions…

​Learn how to prevent Excel from changing a cell's format, causing issues in your formulas. Discover the easy solution using the VALUE function to force a cell's value, no matter…

​Learn how to use Microsoft Excel to easily calculate the percentage of a total using simple formulas, whether you have the total in the same row or not. Discover step-by-step…