February 6, 2014

Format Painter in Microsoft Word and Excel 2010

When it takes you several steps to get a section of text or cell formatted exactly how you want it, you do not want to have to repeat those steps again for another section of text or cell.  So, there is this great tool called format painter that you can use to save yourself a few steps.  Format painter copies just the formatting of your selected text or cell. To use it, first select the text or cell that has the formatting you would like to copy.  Then under the Home tab in the Clipboard group click Format painter.  Next select the text or cells that you would like that formatting to be copied to.  Also, if you would like to use that same formatting to be copied to multiple locations, you can double click on the Format Painter button and you will stay in Format Painter mode until you click it again.

February 5, 2014


New Trend in Social Media – Read this!

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.

February 4, 2014

Quickly Add or Delete Columns or Rows with Keyboard Shortcuts in Microsoft Excel 2010

When working on a spreadsheet it is easiest to work without ever having to take your hands off the keyboard.  Using these keyboard shortcuts can help you with this task.  Press CTRL+ SHIFT+ = and a dialog box will open up and depending on your selection you can add a row or column.  Also, if you press CTRL + - (the minus key) you can delete a row or column once again depending on the selection you make when the dialog box comes up.  

February 3, 2014

AutoCAD 2014 Essentials: 03 Editing and Organizing Drawings with Jeff Bartels- Lynda.com

"Properly managing a drawing is essential to being productive in AutoCAD. In this AutoCAD 2014 Essentials course, author Jeff Bartels concentrates on the tools and features dedicated to organizing and editing geometry in AutoCAD. Learn how to make selections, create and adjust layers, emphasize objects using hatch patterns, and scale, explode, and join elements. The course also includes lessons on creating fillets and chamfers, copying existing objects into rectangular or circular patterns, and accessing specialized tools that make measurements and calculations a lot easier. At the end, a challenge drawing is provided to test your skills."

Grow your brain.

January 30, 2014

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.

January 29, 2014

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. 

January 28, 2014

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.