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.