Shortcut to Time/Date Stamp in Microsoft Excel 2010

Here is a quick short cut you can use to add a time and or date stamp into a cell in Excel.  For a Date Stamp, first select your cell and then press CTRL+; (Control Key and the Semi Colon key).  For the Time Stamp, once again select your cell and then press CTRL+ SHIFT+: (Control Key, Shift Key, and the Colon Key).

New Website for Author

One of the many benefits of a WordPress site is its ability to grow with your company, your budget and your needs.  Your Computer Lady built a two page site for author, Mary Simonsen.  Mary has written three books in her new Patrick Shea Mysteries series. All she needed right now was a small site and a blog.  But we have a plan in place for the future!  We can add a page for each book that will offer excerpts. We can add pages for new books. We can add additional social media connections.  Mary has already used the site for an Amazon promotion.

Check out these excellent books!

App for a Traveler – Pocket Guide (iPhone & Android)

There are hundreds of self guided tours for cities around the globe. The tours are free via a data connection or for a few dollars you can download the tour in advance.  It’s important when you travel to allow yourself time to visit the city. Smell the roses!  Often your host for the meeting will be willing to be your guide. If not, Pocket Guide will help you.

Click here to learn more about Pocket Guide

Using Spike in Microsoft Word 2010

Many of us have used the clipboard to copy and paste information.  There is also a very similar tool you can use called Spike. One of the differences with Spike is that you can Cut multiple sections of text without having to paste in between, and have no fear of losing data.  Then when you do paste what has been Spiked, it pastes in the order it was Spiked which makes it much easier to rearrange large sections of text.  So, now that you know why you would want to use Spike, here is how you can use it. To add text to Spike first highlight your text and then press CTRL+F3 (Control key and F3), and you can continue using this step until you have Spiked all your content in the new order you would like it to appear.  Then to Paste all your information and clear your Spike simultaneously, press CTRL+ SHIFT+F3 (Control key, Shift Key, and F3).  If you would like to paste your information without clearing Spike, so that you can paste it again, you can type the word Spike and then press F3 and your information will paste where ever your selection point is.

Having Difficult Conversations with Britt Andreatta- Lynda.com

"Leadership coach and lynda.com director of learning and development Britt Andreatta shares her tips and strategies for having difficult conversations. In her four-phase model, you'll discover the situations that lead up to difficult conversations, decide when the conversation is warranted, prepare for the interaction, and monitor outcomes to ensure success."

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.

7 Social Media Trends that Will Dominate 2014

Read this article as you start planning your marketing efforts for 2014.

The Top 7 Social Media Marketing Trends That Will Dominate 2014

Inserting the Exact Data into Numerous Cells at the Same Time in Microsoft Excel 2010

Many of us have used the great auto fill features that Excel has to complete a list, but what about those few times when we need the exact same information in each cell?  Here is how you can do that without all the copy/ pasting.  First highlight all the cells you need to have the same text, and then just start typing the information you would like to have in all the cells (note: DO NOT try and click in a cell before typing this will just un-highlight all your cells.) When you have finished entering your information instead of hitting Enter, press CTRL+ ENTER and it will fill into all your highlighted cells.  This also works if you need the exact same formula in several locations of your spreadsheet.

Your Computer Lady Completes New Web Site - Mesa Market Place Swap Meet

A retail shopping mecca with 1600 merchants at high season, Mesa Market wanted a site to better display their upscale location and high end merchants. This is not your grandmother's swap meet.  We're talking screen doors, clothing, flooring, jewelry, binoculars, artwork and so much more.

Social media is a big part of the marketing plan. Your Computer Lady designed a page to pull together Facebook, Twitter and YouTube to strengthen each social media effort.

As a retail site, it is important to make critical information such as maps, hours, dates, special events front-and-center. The new site layout does this while keeping a clean, comfortable appearance.

Many entertainers are so popular that they have return engagements. Many events like the annual classic car show are annual.  The WordPress site allows Mesa Market to create an event page and re-use it year after year making simple updates.

Mesa Market Place Swap Meet web site.

Your Computer Lady Completes New Web Site - The Z Group

The Z Group is a site for a manufacturers' representative company.

• Lots of links to manufacturers' sites. They already have technical data on their sites so there is no need to re-invent the wheel.
• We used a lot of photos from the manufacturers. Good photography is an expense for a site. As a rep company, The Z Group has permission and is encouraged to use manufacturers' photos. Big cost savings!
• More technical data. Your website should be the repository for the technical data and information your clients ask for regularly:  a handing chart, industry standards, etc. Why email a piece of information 50 times a week when you could email a simple link to the data on your site? That's a great way to increase traffic on the site.
• Information your staff needs. You can store a tremendous amount of information on a website. You can have private pages that only staff have access to. Keep policies, forms and how-to documents accessible and consistent.

The Z Group web site.

Vimeo Essential Training with: Jason Osder- Lynda.com

Vimeo is the high-quality video hosting and sharing solution for independent filmmakers and artists. Discover how you can find a creative outlet and audience for your videos on Vimeo.

Short Cut For Reorganizing a List in Microsoft Word 2010

Many times, I will get a list typed up only to realize that the information in numbers 5 and 2 should be switched.  Well this tip will save you all the copy/pasting or retyping when we make those kind of mistakes.  Just click anywhere in the list item that you would like to move, and then hold down ALT+SHIFT and simultaneously use your arrow keys either up or down to move the item where you would like it to be in your list.  

Up and Running with Evernote for Windows with: David Rivers- Lynda.com

Harness the power of Evernote for Windows, a popular cloud note-taking and note-sharing tool. The course begins with a look at ways Evernote can help you note and track important items and then build and work with notes and collect notebooks for sharing.