Toggle Between Worksheets in Microsoft Excel 2010

If you are entering data into multiple worksheets in the same document, it can be tiresome to have to continually use the mouse to switch back and forth between worksheets.  Did you know that if you press CTRL + PGDN you can toggle to the next worksheet to the right, and if you want to toggle to the left you can press CTRL+ PGUP?   Now you never have to lift your hand from the keyboard to switch between worksheets.

New Trend in Social Media

Hashtags are a new trend that you need to start using.  This article gives a good explanation of what they do and how you can use them to reach your target audience. 

Using Hashtags in Social Media: A How-To Guide

Copy Formula to Multiple Cells in Microsoft Excel 2010

Many times we use the same formula, but don’t want to have to constantly retype it in each cell to reflect the individual references to each specific row.  If you have ever found yourself in this place, this trick will save you lots of time.  First, create the formula that you need and then move your cursor to the lower right corner of the cell, and when you see a dark plus sign double click.  Now you will see that the formula has been copied to all the cells below.  The data showed in these cells will automatically be specific to the cells in that row.

Social Media Today

This article is a good overview of social media as it stands today.  

How Local Businesses Should Size Up & Tackle Social Media

Add Holidays to your Outlook Calendar

Did you know that you can have national holidays added to your Outlook calendar without having to manually enter them every year?  First, click on the File tab and then Options.  Now in the new dialog box click Calendar on the list in the left hand side of the screen.  Now under the section labeled Calendar Options, click the button that says Add Holidays, and then select the country’s holidays you would like to appear and click Ok.  Now your holidays will automatically update every year!

15 Ways to Grow Your Email Marketing List

Here is a good article with practical recommendations for growing your email list. Email marketing is the best value in social media for small businesses. 

15 Ways to Grow Your Email Marketing List

Set a Reminder to Reply to an email in Outlook 2010

Sometimes you may be busy and just quickly checking your emails and try to make a mental note to respond to an email later.  Unfortunately, those mental notes don’t always work!  However, with Microsoft Outlook you can easily set yourself an actual reminder. Right click on the message and click Follow Up.  Now in the drop down list that appears, click Add Reminder.  Then make sure the check box is selected next to Reminder, and select the date and time you would like your reminder.