Windows 7 – Can’t save images in ZIP folders
Problem By default, Windows 7 uses the "Windows Picture and Fax Viewer" application for opening images and "File Explorer" for opening ZIP files. Neither are particularly good at what they…
HTML
How to install Adobe Reader XI silently using SCCM
The following process shows how to create a silent install of Adobe Reader DC for distributing with a software distribution tool like SCCM. It was last tested with Adobe Reader…
SQL – How to search with accented characters
The following T-SQL for Microsoft SQL Server shows how to search for accented text without having to use the accented characters in the search term. For example, if we had a table…
Excel 2016 – How to filter pivot table data
The steps below will show how to hide data from a pivot table based on the value. In this example we'll be hiding data where the value is 0. In…
Excel 2016 – Formula to calculate age group from age
The following formulas show how to calculate an age group from an age. This may be useful if you need to report by grouped ages instead of individual ages. The…
How to install NotePad++ silently
The following process has been tested and confirmed working with NotePad++ 7.5.5. It does the following tasks: Installs NotePad++ for the operating systems architecture (32-bit or 64-bit) Automatically updates any…
Ubuntu terminal commands cheat sheet
File commands Task Command Show current dirrectory pwd Show all files and folders in current directory ls Change directory cd e.g. cd usr Navigate to root directory cd / Navigate…
How to export Outlook auto-complete to Excel list
In Outlook when you send an email the address is remembered and added to an 'auto-complete' list. The next time you type the email address into the 'to' field (as…
Windows 10 – How to bring back Windows Photo Viewer
Windows 10 comes with a range of new applications for using your files, one of these is 'Photos' which replaces Windows Photo Viewer (also known as Windows Picture and Fax…