Auto Sum Short Cut in Microsoft Excel 2010

Auto Sum is one of the most used formulas in Excel, so it is nice that is has a short cut on the keyboard. Just press ALT + = and Excel will suggest the data to sum. Press enter if the selection is correct, if not simply highlight the correct cells and then press enter.

Revit Architecture 2014 Essential Training with: Paul F. Aubin- Lynda.com

Build your competency in Autodesk Revit from the ground up. In this course, Paul F. Aubin teaches you the core building information modeling (BIM) skills you need to complete solid architectural drawings in Revit 2014.

Automatic Borders in Microsoft Word 2010

Here is a great short cut to create Automatic borders that can be used at the top or bottom of a page or even as a section break.  There are several different options, but with each choice you will type the specified character 3 times and then Enter.  For a straight line use the Hyphen key (---), for a double straight line use the Equal Sign(===), for a bolded straight line use the Underscore (___), and lastly for a dotted line use the Asterisks symbol (***).  Now there is no need to even move your hands from the keyboard to enter a border.

Teens & Texting

According to Verizon, 63% of teen communication is still text messaging. Note that that said communication. As in phone calls, in-person conversations, emails, letters, grunts and smoke signals.  That is just plain scary.

Easily Remove Formatting in Microsoft Word 2010

While we can use paste specials to remove formatting when copying and pasting information from the internet to a word document, sometimes we just forget. Rather than starting over or spending tedious time reformatting, you can highlight your pasted text and press CTRL+SPACEBAR and it will remove all formatting, hyperlinks and reset to your default font.

Video SEO Basics with: Ian Lurie - Lynda.com

"How do you attract more traffic to your videos when Google can't search them? SEO expert Ian Lurie shows how to optimize your YouTube and other video listings for search engines and convert that traffic to achieve your business goals."

Always Start Right Where You Left Off in Microsoft Word 2010

As many of our documents can be a work in progress, it is nice to be able to open your document and go back to right where you left off. With this tip you can do exactly that every time.  Just press SHIFT+F5, and your cursor will move to where it was when your document was last saved.  So even if it has been a few days, you can open your document and be able to start right where you left off.