1400 Computer Drive, Suite 220 | Westborough, MA 01581 Support

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.

Migrating from Excel 2003 to 2010 Guide

Migrating from PowerPoint 2003 to 2010 Guide

Migrating from Word 2003 to 2010 Guide

Migrating from Outlook 2003 to 2010 Guide

 

 

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.

read more

 

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.”

read more

 

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?

read more

 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

read more