Category Archives: Microsoft Office

Stop Hitting Snooze: Change the Default Reminder Time for Outlook Appointments

How many times has the Outlook reminder popped up on your screen only for you to hit the Snooze button to be reminded again in 5 minutes. How can you possibly be productive while hitting the snooze button repeatedly throughout the day?   This isn’t exactly an earth-shattering geek tip, in fact most of youContinue reading “Stop Hitting Snooze: Change the Default Reminder Time for Outlook Appointments”

How to add loads of folders at once using Microsoft Excel !

Instructions Using a Batch File Arrange your folder names in a single column. Click on the column’s header and type “FOLDERNAMES” in the name field beside the formula bar. Add a blank column to the left of the “FOLDERNAMES” column by right-clicking the column header and choosing “Insert.” Highlight the first cell in the blankContinue reading “How to add loads of folders at once using Microsoft Excel !”

MS EXCEL: How to add data from 2 cells together into another Cell.

Type in the following command, where A1 is the location of First Cell and B1 is value of Second Cell. You place this command into Third Cell which will output the data in A1 and B1 together with a space. (as seen in screenshot). Thanks to Keith Machale for this bit of knowledge. =CONCATENATE(A1&” “&B1)

Location of NK2 files of Outlook.

The location of the NK2 file of Outlook The location of the NK2 AutoCompelete file created by Outlook might be different from one computer to another, depending on the operating system and the version of Outlook. Here’s the rules for finding the location of your NK2 file: For Outlook 2003/2007 with Windows 2000, Windows XP,Continue reading “Location of NK2 files of Outlook.”