Excel – How to calculate Australian financial year from date
Learn how to easily calculate Australian financial years from dates in Excel with our step-by-step guide and formula examples.
Office 365
Excel 2016 – How to select smallest of multiple dates
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…
Excel wont allow insert new rows
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…
Excel 2016 – How to force a value in a formula
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…
How to calculate percent of total using Microsoft Excel
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…
Word 2016 – How to update a cross-reference
Learn how to easily update cross-references in Microsoft Word 2016 when new footnotes are added with these two simple methods.
Excel – How to calculate days until, between or after dates
This Excel article explains how to use formulas such as DAYS(), TODAY(), and A2 to calculate the number of days until, between, or after specified dates. Learn how to find…
Word 2016 – Fix random list items indented
Learn how to fix randomly indented list items in Microsoft Word 2016. This article provides step-by-step instructions on how to adjust list indents for bullet and numbered lists, so that…
Office 365 – How to disable inbox ‘Other’ folder
Learn how to easily disable the 'Other' folder in Office 365's Outlook web app, ensuring all your emails are seen in the main 'Inbox'. Simply follow these steps to toggle…