SCCM OS Deployment – How to monitor the Task Sequence
During the execution of a task sequence, you can monitor the progress in real time by looking at the report titled “History – Specific task sequence advertisements run on a specific…
Excel
Excel 2010 – How to create drop down lists
A drop down list allows you to enter data into an Excel spreadsheet from a preset list of entries. This can be done to make data entry easier or to…
How to Add an Excel 2010 Macro to the Quick Access Toolbar
The following process details how to add a Macro shortcut to the Toolbar which will be available to all opened Excel documents. Create a 'Personal.XLSB' file To make the macros…
Word Excel 2010 – Enable Developer Tab
To show the Developer tab for Microsoft Office 2010 applications Start the Office 2010 application (Word, Excel etc) Select the 'File' menu Select 'Options' From the left hand menu select…
Windows 7 USMT – Exclude Files
The User State Migration Tool can be customised to either include or exclude files or folders being transferred to the new installation of Windows 7. To change the options you…
How to search Active Directory for old computers
The following command prompt commands can be used when auditing Active Directory for old computer objects. Please note, if you're using Windows XP you will need to run the follwing…
VBS – Export List of Active Directory Users to Excel
The following VBS script can be used to export a list of Active Directory user accounts and their details from your domain to an Excel spreadsheet. Download: here (note, you…