Tips and Tricks
Identifying Duplicate Values in Excel 2007/2010
Disabling IE Tab Preview in Windows 7
If you are using Internet Explorer and Windows 7, you may have noticed that when you mouse over an IE browser window, a preview of the open tabs in the browser is shown. While this is useful to give you an idea of the sites you have open, it can get annoying if you have multiple tabs open at the same time. If you would prefer to disable this feature, you can.
Just go to Tools
> Internet Options (in the upper right-hand corner of the browser)
> Click on the “Settings” button in the window that pops up.
> In the list of Tabbed Browsing Settings, uncheck “Show previews for individual tabs in the taskbar.”
> Click on OK and you should be good to go.
Pause a PowerPoint Slideshow with Easy Keyboard Shortcuts
Instead of leaving the presentation or covering the projector lens with a piece of paper, you can press “B” to show a black screen or “W” to show a white screen.
How to Join Text from Different Cells into One Cell
The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a person's first name in cell A1 and the person's last name in cell B1, you can combine the two values in another cell by using the following formula:read more
Migrating from Microsoft Office 2003 to 2010
Are you new to Office 2010? A lot has changed in seven years! Download these easy to use guides to make the transition a little easier.
MS NAV 2009 Keyboard Shortcuts
Getting Around the Desktop in Windows 7
Switching from XP to Windows 7? Click here to see what’s new and how to Get Around the Dekstop.
Share your contacts folder using Outlook 2007.
By sharing your contacts, you allow others to view, edit, or create contacts shared across your company.
To share your contacts:
1. In the Contacts section of the Navigation pane, click the “Share My Contacts” folder.
2. Enter the name of the person with whom you want to share your contacts.
3. Enter a subject.
4. Type a note in the body of your message.
5. You can also check the box next to “Request permission to view recipients’s contact folder.”
6. Click “Send.”
How to Recognize Phishing E-mails
From time to time you may receive email and question whether it’s valid or fraudulent. Phishing e-mail messages are designed to steal personal information about you such as passwords, account numbers, etc. They ask for personal data, or direct you to Web sites or phone numbers to call where they ask you to provide personal data. Phishing emails can cause a multitude of security concerns for you and your systems.
A few clues can help you spot fraudulent e-mail messages or links within them.
What Does a Phishing E-mail Look Like?
Microsoft Dynamics NAV Keyboard Shortcuts
Alt + Arrow Down: Open the lookup menu on a cell with a drop-down menu
Alt + M: Launch the MS Dynamics NAV menu
Alt + R: Launch the Reports menu
Alt + Tab: Switch between open items
Ctrl + +: Insert new line in a grid
Ctrl + E: Export to Excel
Ctrl + L: Show Links
Ctrl + N: Create New/Insert
Ctrl + O: Open company
Ctrl + W: Export to Word