How to create named cell references in Excel 2016
Learn how to create named cell references in Excel 2016 with our step-by-step guide. Discover how to use words instead of letters and numbers in your formulas, while adhering to…
Office 2016
Excel 2016 – Formula to calculate age group from age
Learn how to use the LOOKUP function in Excel 2016 to calculate age groups based on a given age. Find out how to create a formula that will categorize ages…
Excel 2016 – How to calculate age from date of birth
How to calculate age from date of birth using Excel 2016? Learn how to use INT and IF functions to find out your current age or the age of someone…
Excel 2016 – How to have pivot chart show only some columns
This article explains how to create a pivot chart in Excel 2016 that only displays certain columns, while hiding others. It provides step-by-step instructions for creating a pivot table with…
How to export Outlook auto-complete to Excel list
Learn how to export your Outlook auto-complete list to an Excel list using the third-party program NK2Edit. Simply download and run the program, select the desired emails, and save the…
Outlook 2013/2016 – Where is the auto-complete list stored?
The article provides information on where the auto-complete list in Microsoft Outlook 2013/2016 is stored, which can be found in the RoamCache folder located in the user's AppData directory.
Microsoft Office version numbers
The article provides information on the version numbers of the latest releases of Microsoft Office, including Office 2016, Office 2013, Office 2010, Office 2007, and Office 2003.
Word 2013 – How to enable the page ruler
Learn how to enable the page ruler in Word 2013 with this easy step-by-step guide. Simply follow our instructions and turn on the 'Ruler' option in the View menu to…
Excel 2013/2016 – How to change CSV delimiter character
Change the delimiter character in Excel 2013/2016 to use a pipe character instead of a comma for saved CSV files by modifying the system's regional settings in the Windows Control…