PowerPoint Presentation – Arizona Masonry Guild

For the past 10+ years, Your Computer Lady has created three different PowerPoint presentations for the Arizona Masonry Guild for the Excellence Awards.  The first presentation is for the judges to review while selecting the project winners.  The second presentation is shown during the dinner presenting all projects that were submitted. The third presentation is the backdrop for the evening. Introductions are made for the MC and other speakers. Photos of the items for the live auction are shown during bidding. The head jurist selects photos to use in presenting the award winners. One of Your Computer Lady’s favorite parts of the evening presentation is the announcement of the winner of the Bart del Duca Award. Pictures are gathered from family and friends. The award winner is surprised to see their baby picture show up on the screen!

New Web Site – CSI Las Vegas Chapter

Your Computer Lady built a new WordPress site for the Las Vegas Chapter. We started with content from an old Dreamweaver site then expanded to meet the needs of the chapter including event registration, online payments, blog discussions. Eventually volunteers will be trained to maintain the site.

Printing a Page Range in Microsoft Outlook 2010

These days we are all trying to save on resources and cut down office costs. An easy way to do that is to print less of our emails, but there are times where we just need that hard copy.  So instead of printing the whole email, you are just going to print the portion you need.  Unfortunately though, where most Office programs allow you to select what pages you would like to print, that option does not seem to be there in Outlook.  Well here is where it is hiding; in the print screen click on the small Print Options button and in the pop up window you can now select a page range.

Neoporte Modern Door – Design Reference Guide

Your Computer Lady assisted Neoporte Modern Door with creating a Design Reference Guide detailing for customers the different accessories and options for creating their custom steel door.   The Design Reference Guide was created in Word and printed as a PDF with clickable links in the table of contents for the client to be able to click to specific sections within the Guide. The advantage of creating in Word was that it is easy to update the pages and new options are added. The pages can also be used on the company’s website. The PDF format makes it easy for clients to download the information.

Coaching and Developing Employees with: Lisa Gates- Lynda.com

In this course, business coach Lisa Gates teaches managers to harness the power of coaching in the workplace. Learn the benefits of developing your team and helping employees build their skills in ways that transform and empower them to do more productive and engaging work. Then discover how to build your own leadership and coaching skills and equip yourself with tools that encourage insight and growth. The course wraps with a look at how you can maintain the coaching momentum in the workplace and address common challenges.

New Web Site - CIW Defense Equipment

As a high quality water treatment service company, CIW Defense Equipment asked Your Computer to create a new web site to showcase their products and services to their clients. Software used: WordPress

Opening Old Office Documents

Have you ever gotten an error message when trying to open a REALLY old Microsoft Office Document? With Office 2010 you don’t have to worry about losing those old documents.  Just follow these steps to make a quick setting change and you will be able to open all of those files in the future. 

• Click Options under the File tab
• Then in the pop up window click Trust Center in the list on the far left
• On the bottom right click the Trust Center Settings button
• Then in the new list on the left click File Block Settings
• Now just remove check marks from the Office Files that you would like to be able to open

"Drum Machine Set" - Animusic.com

Filter Tool in Microsoft Excel 2010

The Filter Tool in Excel is very helpful when you are sorting through a lot of data.  You are quickly able to view only the data that you need.  First click the Data tab and in the Sort & Filter group, then click Filter.  Now a drop down arrow will appear next to each column on your first row. Click the arrow where you can select exactly what data you would like filtered out.  For example, let’s say you have a list of names and addresses that you send out newsletters to.  But, for this specific mail out you only want to mail to people within a certain city.  Rather than having to scroll through all of your data, you can simply Filter your list by the Column designated for cities.

Email Marketing – Design Dimensions

Your Computer Lady has assisted Barbara Kaplan, owner, Design Dimensions on her email marketing.   Barbara had published several exceptional interior design articles in the City Sun Times.  Your Computer Lady has taken these articles and used them to create a bi-weekly email campaign.  Writing is hard work! Let’s get the most use possible from your efforts. Keeping her emails fresh and informative has been the key to Barbara’s success in email marketing. Software used: Constant Contact.

YouTube Essential Training with: Jason Osder- Lynda.com

YouTube is a revolutionary video-sharing platform that has facilitated broadcasts of user-generated content—hundreds of thousands of videos are uploaded every day. In this course, Jason Osder shows you how to view, upload, and share videos on YouTube. Learn how to start an account, build a following, promote videos on Facebook and Twitter, and shoot and edit film specifically for a YouTube audience. Plus, get tips on troubleshooting video, such as removing compression artifacts and analyzing video performance.

Administration Help – Lights Up Arizona

Your Computer Lady has been making sales calls to set up appointments for the principal of Lights Up Arizona.  This sales effort has generated several leads! Software used: Zoho CRM

Insert Current Date in Microsoft Word 2010

If you have form letters/ documents that you use frequently this will help you to never forget to change the date again. Just press SHIFT+ALT+D and the current date will appear, and the next time you open this document on a different day the date will automatically update.  If you need to adjust how your date appears click the Insert tab and in the Text group click Date & Time and you will see all of your available options.

Facebook Support - Leo Buscaglia Foundation

Over the past two years, Your Computer Lady has been making Facebook posts for the Leo Buscaglia Foundation.  We started with zero Likes and are currently over 1,200 by posting conversation pieces and posts promoting their grant recipients.  A recent post was seen by 1,658 people.

"Pipe Dream Set" - Animusic.com

Color of Incoming Messages in Outlook 2010

Here is a different way to organize your emails in Outlook 2010.  You can have the color of your incoming messages from a designated contact automatically set to a color of your choice. Here is how you can set it up.

1. Click on the View tab
2. On the far left in the Current View group click View Settings
3. In the pop up window click Conditional Formatting
4. In the next window click Add, now once you have highlighted the new rule (which is labeled Untitled) you can rename it by clicking on it, now click Condition.
5. Now click the From button and you can choose a contact or multiple contacts from your address book, and then click OK.
6. Lastly click the Font button and change the color and/or font for this rule.

So now when looking at your inbox, you can easily find messages you are looking for just by seeing what color it is. 

Monday Productivity Pointers with: Jess Stratton- Lynda.com

In this series on productivity, author Jess Stratton takes you through the latest tools that will help you run your business and life more efficiently. Each installment covers a particular feature or technique in a different online tool, such as Google Apps, Skype, YouTube, Mint.com, Etsy, and more. Check back every Monday for tips on topics from recording and publishing video chats to managing your finances online.

Inserting a Sparkline on your Excel 2010 Spreadsheet

A Sparkline is a new way to creatively display your data in excel. Using them you can quickly and easily see trends in your data and they are super easy to use.

To use a Sparkline, first select the cell/cells you would like your Sparkline to appear in. Then select the Insert tab and look for the Sparklines group.  From here you can select which type of Sparkline you would like to use (column, line, or win/loss).  Once you have made your selection, a pop up window will appear.  The Location Range will already be filled in to the selection of cells you highlighted at the beginning.  All that is left is to enter the range of cells your data is in.  You can manually enter it in, or you can also press the button to the right of the Data Range and then highlight the data you would like to use.  Then just click OK and you will see your new Sparkline.  

Animusic.com - Pipe Dream 2 - Bonus Feature

Using Conversation View in Microsoft Outlook 2010

Many times when we are having conversations through email we need to look back and see what was said by both parties.  When you set up your Inbox to show Conversation View you no longer have to flip back and forth between your Inbox and Sent emails.  It’s very simple, just click on the View tab and in the Conversations group click the box next to Show as Conversations. A pop up window will appear asking if you would like Conversations to be applied to all your folders or just the folder you are currently in.

AutoCAD 2014 New Features with: Jeff Bartels- Lynda.com

Start incorporating all the new features of Autodesk AutoCAD 2014 into your CAD workflow. Author Jeff Bartels covers the new Autodesk 360—enabled collaboration tools, enhanced command line with content and search functionality, and georeferencing options. The new AutoCAD productivity and security features are also explored. Plus learn about working with point cloud data and virtual environments using Autodesk ReCap.

Trimming Videos in Power Point 2010

When you need to show a video in a power point presentation, most of the time you are just wanting to show a sort clip. In Power Point 2010 you can trim your video precisely to the part you want shown without having to worry about hitting stop at a certain time.  Once you have inserted your video, click on the Playback tab, and in the Editing group click Trim Video.  A pop up window will appear were you can set your start and finish time for your video to the exact points that you would like it to start and finish at.  

ANIMUSIC 3 - Kickstarter Project