Excel 2016 – How to select smallest of multiple dates
The following examples show how to use an Excel formula to select the smallest date from a table. This may be useful where you have a table with duplicate information,…
Format
Excel wont allow insert new rows
Problem In an Excel document, you're unable to insert a new row. The 'Insert' option is greyed out. Solution This issue generally happens for two reasons - the document is…
Word 2016 – How to keep whole table together on one page
The following steps show how to format a table in a Word document so that the table does not split across multiple-pages (when it can fit in one page). For…
Excel 2016 – How to force a value in a formula
Problem One of the more frustrating features in Excel is its ability to automatically change a cells format - based on it's content. For example - a cell a currency…
How to calculate percent of total using Microsoft Excel
In these examples we're going to show how to calculate the percent of a total using Microsoft Excel. The basic formula to do this is Part / Whole = Percent…
How to install 7-Zip silently
The following process shows how to setup a 7-Zip silent installer that will work with 32-bit and 64-bit versions of Windows. It can be used to distribute 7-Zip to computers…
What does the @ symbol do in PHP?
If you've noticed an @ symbol in some PHP code - you're likely wondering exactly what it does. The @ symbol in PHP is an "error control operator" - which…
Excel 2016 – How to edit worksheet header/footer
The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on 'View' in the ribbon In the 'Workbook Views' group click…
Word 2016 – How to restrict/un-restrict formatting changes
Microsoft Word has the ability to restrict a document so only existing styles can be applied to content - with no specific formatting like "bold". The steps below show how…