November 7, 2013

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.

November 6, 2013

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.

lynda.com




November 5, 2013

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.  

November 4, 2013

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.

Learn it all.