Transpose a Table in Excel 2010

Many times when creating a table in excel and trying to decide the best way to present your data, it would be easier to transpose your table rather than recreating a second table.  Good news is that you can there is no need to do double the work.  Just select and copy the table you would like to transpose. Then select the place on your spreadsheet you would like your second table to appear. Next click on the Home tab, and in the Clipboard group select the drop down arrow underneath the Paste option and when you hoover over the 3rd icon on the 2nd row you will see it says Transpose. Once you click this icon you will see your transposed table.

Easy Envelope Budget Aide

 Did your parents ever sit down with some envelopes with you when you got your first allowance? Did they explain why you needed to separate your money into categories such as savings and spending?  In today’s world where everything is paid for with plastic and all our money is deposited at the bank, this system isn’t really practical anymore.  Easy Envelope Budget Aide is a way that you can still use the lessons your parents taught you about budgeting, but with using today’s technology.  With this app you can create a budget, and also note when money has been taken out so you know when to stop spending in a certain category.  With the free account, you can sync your account to a second user so you don’t have to worry about double spending.  With a paid account there are additional features like the ability to have more users and more envelopes/ categories.  Click Here to learn more about this app.

Delay the Delivery of Sent Email in Outlook 2010

There are times when you would like to purposely delay the sending of certain emails, but you don’t want to sit around at your computer to send it at that later time.  Simply get your message ready to send and in the message window select the Options tab, and in the More Options group select Delay Delivery.  In the new window that opens up, look in the section labeled Delivery Options.  Mark the box next to Do Not Deliver Before, and select the date and time you would like your email to be sent.  Now once you click send, your message will stay in your Outbox until the time you have designated.  It is important to remember that if you are using a POP3 or IMAP email account, Outlook has to stay open until your message is sent.

Evernote App

This is an app that Harry McCracken talks about in Time Magazine, April 8, 2013. Ask the Expert.

“Evernote Premium ($5 per month or $45 peryear, iPhone, Android, Windows Phone, BlackBerry). The basic, free version of this tool for collecting notes, images, audio recording and other bits and pieces of information is a gem.  It’s also a gateway drug for the paid upgreade, which caters to serious note takers; with features like the ability to upload massive quantities of high resolution photos.”

Using All Your Paste Options in Microsoft Office 2010

We all know how easy it is to copy and paste information from a documents, websites ect., but many times when we paste our information it does not have the formatting we would like.  An easy way to have a little more control of the formatting of the content you paste is to select the drop down arrow underneath the Paste option (Found in the Home tab in the Clipboard group).  When you hoover over the icons, you can see the different formatting options you have when pasting your content.  Also, when here you can choose to Set a Default Paste (only in Microsoft Word), this allows you to use your shortcut keys hassle free. 

Email Vs Social Media

"The thought is that, just as we've moved away from paper memos, we'll eventually move away from email because social media simulates a much more natural conversation. And media platforms like Facebook, Twitter, and LinkedIn presently and frequently communicate with their audience using…wait for it…EMAIL!"

Click Here to read the rest of this article

Convert your PowerPoint Presentation to a Video

Many times we have these great power point presentations that can easily be used to promote your product and/or business, but are limited to showing these presentations in locations where PowerPoint is available.  Here is a tip to show you how to save your presentation as a video, so you can show your presentation anywhere you can play a video.  Simply open your presentation and click on the File tab, and then select Save and Send. Lastly, in the left hand column, select Create a Video and then select the specific options that you would like your video to have, click the Create Video button, and you can now save your newly created video.

Fantastical App

This is an app that Harry McCracken talks about in Time Magazine, April 8, 2013. Ask the Expert.

“Fantastical (4.99, iPhone).  An elegant replacement for the iPhone’s stock calendar app, Fantastical lets you type or speak items in plain English, like ‘Dinner with Marie at 7 p.m. on Friday’ Then it unerringly figures out what you meant and pencils in an appointment at the appropriate day and time.”

Specify a Certain Data type for your cells in Microsoft Excel 2010

A tool that is especially useful when multiple people are working on the same document and you want to make sure that the correct type of data is going into the correct cells. An easy way to do that is to highlight the cells you would like to designate for the same type of data.  Next, click on the Data tab and in the pop up window you can select what type of data you would like to allow in those cells.  

7 Tips for Making Other People Feel and Insightful

Sometimes I get so focused on getting the meeting started, getting tasks completed, being on time for the next appointment that I forget I am working with people. This article from Gretchen Rubin’s The Happiness Project website is a good reminder that I need to take time to make the people I work with feel important. Hmm. Maybe it would even be a good idea for friends and family!

 Click Here to Read the Article

Automatically Delete Your Trash in Outlook 2010

Here is a way that you don’t have to manually empty your Trash in Outlook.  First, click on the File Tab and then Options.  In the list on the left side of the Options window click Advanced.  Then in the section labeled Start and Exit click to add a check mark next to Empty Deleted Items Folder when Exiting Outlook. Now you never have to go back and empty your trash again.

Photoshop App

This is an app that Harry McCracken talks about in Time Magazine, April 8, 2013. Ask the Expert.

"Photoshop Touch($4.99, iPhone, Android).  The phone-size edition from the most famous name in image-editing software retains a startling percentage of the desktop version’s power.  You can crop, re size and retouch photos and apply fancy filters to make your pictures look like watercolor paintings or pencil sketches."

Add a Business Card to your Signature in Microsoft Outlook 2010

Here is a way to help an email signature be more professional and also make it very easy for others to insert your contact information into their address book.  The first thing you need to do is to add yourself as a contact to your contact list,  and make sure that all the information you want to show on your electronic business card is listed in your contact.  Note that you can also add a picture/ company logo to your contact as well.  Next go the File tab and click on Options.  Then in the Options window click Mail and in the Compose Messages section click on Signatures.  Now click New and give your Business Card signature an appropriate name, and in the tool bar underneath the Edit Signature section click Business Card and select your contact information.  Lastly, in the upper right corner make the appropriate selections in the drop down boxes as to which emails you would like your new business card signature to be applied to.

Hone your site's content- Lynda.com

On the web, content is king; it conveys your message, dictates the categories for your site’s navigation, and establishes your brand. InFoundations of UX: Content Strategy, Patrick Nichols demonstrates how to strategically assess your website’s content and audience, and build an online experience that efficiently reflects your unique brand and voice.

Automatically Close your Message after you Reply in Microsoft Outlook 2010

After you respond to an email what is the next thing that you do? Close the message right?  Here is neat trick that you can use to have Outlook automatically close your email so you don’t have to take that extra little step.  First click on the File tab, and then select Options.  In the Options window, click Mail and then scroll down to Replies and Forwards.  Then click the box to add a check mark next to Close original message window when replying or forwarding, and now you are done once you click Ok. 

App Prices

These are some interesting statistics that might contradict what you think about free apps vs. paid apps. 

Statistics are from Harry McCraken’s article “Some of the best things on smartphones aren’t free” found in Time Magazine, April 8, 2013

  

Quickly Inserting a Screen Shot in Microsoft Outlook 2010

Now that Microsoft Outlook uses the Ribbon like other Office programs many of the same features are now available to Outlook users.  One feature that I have found particularly helpful is the ease of inserting a screen shot in Microsoft Word.  Now that same capability is available in Outlook as well.  Once you are in a new message window, click on the Insert tab and then in the Illustrations group click Screen Shot and it will show the available screens for you to take a shot of.  Or if you would like just a portion of a screen, click on Screen Clipping instead and you can select just a portion of one of your screens.