PC Flu Season

November 7th, 2011 - by Angela

pcWell, if you have missed all of the commercials and advertisements for flu shots, you are probably the person who needs one.  We all stay so busy this time of year (and all year round, really) that we often do not take the time for some preventative medicine.  I did get my flu shot this year because a great friend sent me multiple email reminders.  I know how important it is since I am in a room with computers or sitting with someone at a computer quite frequently.  Computers love to keep germs on the keyboard and mouse.

Because this upcoming holiday season is so busy, we have to be especially vigilant and cautious about keeping ourselves well.  But, this should not apply just to us.  We should remember that our computers need to stay healthy and virus-free, too.  Sometimes we think we are too busy to worry about that, though.  If we are not extra careful about the sites we visit, the media we download, and the files we share, we might end up with a virus. 

Here are some tips/reminders on how to keep your computer virus free:

– Make sure your virus software is installed and up-to-date.  You can schedule most anti-virus, anti-spyware, anti-malware and Internet security programs to run updates daily.  You also need to make sure that the software checks and updates it’s virus definitions frequently.  If you decide to install new software, make sure and completely uninstall your old one or else you might have conflicts.

 – Avoid clicking on links in social media and in emails unless you have requested that someone send you the link.  You do not want to download programs from unknown sources.  Be especially wary of emails that contain executable (.exe) files as attachments.  I know that it is hard to keep from clicking on the link on someone’s Facebook page about the adorable kitten’s antics.  But, is it really worth watching so much that you risk downloading a Trojan or other virus in the case that it is not a legitimate video?

– Set your Macro Virus Protection in Microsoft programs to High, so that it will only allow macros in documents from trusted sources.  When a trusted source sends you a Word, Excel, or other Microsoft file, you can still choose to enable the Macros in that specific file. 

Hope you and your computer stay virus-free this season!!

Save the Day with Excel Text Functions

October 31st, 2011 - by Angela

save-the-dayHave you ever had to import text from another source into Excel?  Many of us need to pull data from a corporate database or similar source into Excel and then manipulate that data.  How many times have you pulled the information in, especially people’s names, and then discovered that the text did not look presentable? The text is either in all capitals or all lowercase letters. Either way it is not formatted in a professional manner.

For example, say that you have imported data from a mainframe that included a large number of names of individuals, but the names appear in all lowercase letters. Your need to include the imported information as part of a larger report in Excel.  The data you have must be formatted correctly and to be presented at an upcoming meeting.

In a crisis situation, some of us might just try re-typing all of the information but that takes up way too much precious time. You might also be thinking that you can use the Find and Replace feature, but would have to be very careful so that no text is replaced in error.  That would use up too much time, too.

If you want the names to appear with the first letter of each name capitalized, you can use Excel’s PROPER function.  If your names are in column A, you would want to create a new column to the right of Column A.  Your new column would be column B now. For our example, I’m going to assume that the names start in cell A2 (with a heading of some sort in cell A1).  So, in cell B2, I would key in the formula =PROPER(A2).  Then, copy that formula down into the remaining cells.

If you are copying the newly formatted column of data into another spreadsheet to add to other data, then make sure and use the Paste Special and choose Values Only.  You need to do this because the cells with the proper formatting are actually just formulas with a cell reference to Column A data.  If you do not use the Paste Special for Values Only, you will get reference error messages. If you do not need to copy the newly formatted column of data, another easy fix is to hide column A. 

There are a number of text functions that can help you. You can explore them by clicking on the Formulas tab and clicking the drop-down arrow for the Text icon in the Function Library Group.  Check back for future posts when we look at other Text functions in Excel.

Business Life and the World Series

October 24th, 2011 - by Angela

baseball-stressWhile writing this blog post, I am watching the World Series.  I am a big baseball fan and love it when two good, well-matched, and competitive teams make it to baseball’s most important series.  So, as I sit and try to compose something that is relevant and interesting (or at least try to do one of those), I am anxiously willing my favorite team to win.  I know that people rooting for the other team are experiencing the same emotions and adrenaline rush.

The stress is completely wearing me out.  I have to continue to remind myself that this is just one game in a series of games.  But, I know that the players for the Texas Rangers and St. Louis Cardinals are not viewing it that way.  Winning games in the World Series is their job.  It is what they have worked for all season.  This is the culmination of every practice and game they have played.

Each of us has to deal with stress in our jobs, too.  I honestly admit that I have felt my “business life” stress level rise over the past few years.  More and more is being expected of us, whether it is someone else or ourselves putting on that pressure.  I know that those expectations are only going to increase in coming months, according to predictions by economists and business forecasters.

So, what can we do about this stress?  Well, I have a few ways that I am dealing with my stress that I thought I would share.  Hopefully, you can add these strategies to your toolbox, if you are not already employing them in your life right now.  Most importantly, you can morph and customize your strategies and these ideas into something that will work for you!

1.  Stay Calm - The best way to project confidence in an emergency situation is to keep your voice at a moderate level and to think quickly but thoroughly before you speak.  The same thing applies in a stressful situation at work that stays stressful over time.  Try not to get wrapped up in complaining or placing blame.  It is best to work purposefully, quickly, and project a calm, collected exterior.  Do this especially when you feel like you want to panic.

2.  Train/Prepare - (Of course I am going to mention training…I am a trainer.)  Examine your job and think about what you can train for now to advance, perform better, or even transition to a new position or career.  The people who are first responders are prepared to be disciplined but also to be flexible.  In a stressful environment at work, we need to have those same traits.  We must try to foresee (as best we can) the pitfalls that might be headed our way, as well.

3. Communicate - I have found that creating an environment with a good flow of communication can reduce stress dramatically.  Generally, if I attempt to be honest and forthcoming, I have had a positive relationship with others that I work with, even during stressful times.  I also need to communicate with myself and keep in touch with how I am doing internally.  Reminding myself that the stress in my business life does not need to bleed over into my personal life does seem to help.  Each day, I have a new chance to try to deal with my stress in a constructive way and win my own World Series!

These are just three of my “business life” stress reducers.  If you have any others, please leave a comment.  I would love to add them to my strategies for reducing stress!

Using Speak Cells in Excel

October 17th, 2011 - by Angela

speak-cellsRecently, I was working with someone who was sight impaired.  I was actually supposed to be the one helping out, but ended up being the beneficiary of some new information.  I love learning about new features and love seeing them aid someone so powerfully! 

While I was teaching this friend about keyboard shortcuts in Excel, she mentioned the she heard of an Excel element called “Speak Cells”.  Since I had not tried out that feature before, I immediately told her that we should test it out.  In her Excel 2010 version, we found the built-in “Speak Cells” audio feature in Excel.  It can help you proofread numbers and other data by actually sounding out the numbers for you. You can choose to have the information repeated by column or by row.

In order to enable the feature, you can add the “Speak Cells” icons to your Quick Access Toolbar.  The Quick Access Toolbar is at the top left of your Excel window.  If you click the down arrow to the right of the Quick Access Toolbar, you can then select More Commands.  When the dialog box opens, look for the Choose Commands area and click the drop down arrow next to Popular Commands.  Choose All Commands.  Make sure and take a look at all of the great items in the All Commands list.  You might find a few more things to add to your Quick Access Toolbar.

Next, scroll down the list on the left side until you see the commands for Speak Cells. You will want to add several icons within the Speak Cells group including:  Speak Cells, Speak Cells - Stop Speaking Cells, Speak Cells by Column, Speak Cells by Row, and Speak Cells on Enter.  Adding all of these icons will increase your flexibility in using the Speak Cells feature. To select the desired icon(s), double-click each of the icons to move them over to the right list that shows the items on your Quick Access Toolbar.  When you have added them all, click OK.

I really like using the Speak Cells on Enter, especially to proofread.  To use that feature, just click on the Speak Cells on Enter icon in the Quick Access Toolbar.  When you click on a cell and hit the enter key, it will speak the contents of that cell to you.  Just make sure you have your speakers turned on or your headphones on!  Enjoy using your new “Speak Cells” feature!

Should You Upgrade to Office 2010?

October 10th, 2011 - by Angela

decisionsAre you still trying to decide whether to switch to the Microsoft Office 2010?  Here is a brief overview of features new to Microsoft’s newest Office version.

One of the most popular changes in the Office 2010 software is the replacement of the Office Button with the File tab (located to the left of the Home tab).  Under the File tab, you will find the common file management tasks related to creating, storing, printing, opening and closing your files.  When using the file tab, you are using what Microsoft now refers to as the Backstage View.

 The following is a brief look at some of the new features offered in the most common application programs in Office 2010-Word, Excel, PowerPoint, and Access:

 Word 2010

  –  Edit and apply effects to photos without additional software.

  –  Organize your documents and navigate easily with the new navigation pane.

  –  Add powerful special effects to words with new text effects.

 Excel 2010

  — Highlight important data trends in seconds using Sparklines.

  — Clarify information with color schemes and data bars in Conditional Formatting.

  — Spend less time sifting through data with new PowerPivot features.

 PowerPoint 2010

  — Embed, trim, add bookmarks and special effects to videos right in PowerPoint.

  — Apply sophisticated effects to pictures, like color saturation and artistic filters.

  — Broadcast presentation instantly by creating a link for real-time, online viewing.

 Access 2010

  — Make exploring your data easy using Access drag-and-drop navigation forms.

  — Create insightful reports with new design, layout, and data analysis tools.

  — More easily automate common tasks using the revamped Macro Designer.

If you or your organization could use these great new features, you should definitely look at upgrading to Office 2010.  If not, you may be exactly where you need to be with Office 2007.  If you need any help with either of these versions, let me know!

Budget Planning for Training

October 3rd, 2011 - by Angela

budget-planningLike many organizations who have a fiscal year end in December, you may already be planning your budget for 2012. Or, you may be planning to plan your budget.  Since I have a brain for planning, I am usually thinking about 10 steps ahead down the road at all times.  I know many of you who plan budgets each year have to be the same way.  For corporations to get a budget in place, you have to start early.  If you are in that position, I thought it would be good to help you think about ways to get the training you need incorporated into that financial plan for 2012.

To provide a successful training program for you organization, you need to know what on-going and remedial needs you have.  Talk to your colleagues.  Find out what would help them be more efficient and effective in their work.    You can do this using a formal survey, sending an informal email, or even just by walking around.  Make sure you refer back to feedback from this year’s training sessions. 

After you determine your general needs, be sure that you take into account new technology that will be implemented within your corporation in the next couple of years.  You may need a “new features” training session for new software upgrades (like Microsoft Office 2010, for example).  If you need help during this process, give me a call so that we can help you determine what training options are available for the software that you are using.  Here is a link to our page about our training services for you to see some of the options available to you: www.versitas.com/training-services.php .

When lining out your training requests for the budget, make sure to include the training/trainer costs, supplies, snacks/refreshments, and any other associated costs/fees.  You will need to be flexible and figure out where you can compromise on your plan due to financial restraints.  Look at outsourcing versus in-house training.  Sometimes it takes more time/effort to create an in-house program when there is already someone with the expertise you need outside your group.  Other times, you already have what you need for a portion of your training to be done within your organization. 

No matter what you choose for your training program, make sure you are looking for what will best serve everyone at your organization.  It might be easy to just keep doing what you have been doing.  If that is helping everyone be successful, then you are on the right road.  If not, then you will definitely want to re-examine and adjust.  Again, if I can help, just let me know!

More Cool Tips for Windows 7

September 28th, 2011 - by Angela

rabbit-hatMost Windows students that I work with use computers that are 2-5 years old.  If this is the case for you at work or at home, you may experience memory problems that can cause random reboot and/or computer freezes. If you think your computer may be experiencing memory problems, you could find out for sure using the Memory Diagnostic Tool provided with Windows 7.

To run the diagnostic tool: Click Start, type “mdsched” in the search box.  Then, click “mdsched” in the upper part of the Start menu. This action pops up the Windows Memory Diagnostic dialog box. Save your work and close any open program. Then click on Restart now and check for problems. The computer restarts. Windows Memory Diagnostics runs automatically and performs a standard memory test that lets you know if the memory is out of order.

Another question that I get in class sometimes is about how to restore previous folders that were open during the user’s last session.  You can have Windows open all of the folders (in Windows Explorer) that were open right before you shut down or logged off the computer.  Click Start and then click Computer. Press and release the Alt key which will bring up the menu. Next, choose the Tools menu and launch the Folder Options. After selecting the View tab in the Folder Options dialog box, move to the bottom of the Advanced Settings list box. Select the Restore previous folder windows at logon and confirm by clicking OK. When you restart your computer or session, any open folders will be displayed as in the previous session.

This final tip is not to be used for the new/novice Windows 7 user.  It is called “God mode”.  You can use it to access all of the Windows 7 features/settings in a single dialog box. To do this, right-click on the desktop, point to New and choose Folder. Type the following and press Enter: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} The folder’s icon will change instantly. Double-click on it and you will find the numerous shortcuts available. Some things you can change are: AutoPlay settings, your default programs, and Display color calibration. Enjoy discovering all kinds of commands and settings changes you can make in God Mode.

Have fun!

Helpful and Fun Windows 7 Tips

September 20th, 2011 - by Angela

excel-magic-tipsAfter using Windows 7 for a year or so, I feel like I am beginning to find out more of the “fun” features.  By “fun” I mean in a techno-nerdy trainer way.  I love finding new tips and tricks to make Windows 7 more functional and easy to use.  Some of these tips could be classified in beginner/novice, while others are more advanced.  I decided to include some of these tips in this post and in the next one to add to your Windows 7 repertoire. 

One of the things I teach beginning Windows students is how to move and copy files.  However, I usually encounter a few students who avoid the drag and drop.  If you are one of these, then you will like this tip.  It is how to add a “Move to folder” option in the right click menu for your files.

Click Start, type regedit and click regedit at the top of the Start menu. (This opens the Registry editor.  Be very careful in there!) Next choose Expand HKEY_CLASSES_ROOT, AllFilesystemObjects then Shellex. Right click on ContextMenuHandlers, point to New and click Key. Type Move to Folder then press Enter. In the right pane, right-click on Default and select Modify. Type {C2FBB631-2971-11D1-A18C-00C04FD75D13} in the Value data textbox, and confirm by clicking OK. Close the Registry Editor window. Now when you right-click on a file in Windows Explorer, the Move to Folder command is available.

One thing I always encourage my students to do when they purchase a computer and when they make big updates is to create a restore point. Making a change in the registry, installing an unofficial device driver or modifying any other part of the computer can cause malfunctions in Windows.  It is best to create a restore point. If the computer becomes unstable due to the change, you can return to its previous state using the restore point you just created.

Click Start, type restore in the Search text box and click Create a restore point at the top of the Start menu. The System Properties dialog box appears. Select the System Protection tab. Click Create, choose a name for the restore point, and click Create. A moment later, a dialog box informs you that the restore point was created. You can then safely make your change.

If you make a change in the Registry or install something that destabilized the system and you made a restore point (instructions given above), you can restore the lost stability in a few mouse clicks. Click Start, type recovery in the Search text box and click on System Restore. This action pops up the System Restore dialog box. Click Next. Select the restore point you want to use, click Next and then Finish. Now, you just have to wait until the restoration is complete.

Check back next week for more Windows 7 tips and tricks!

A Few Excel Tips

September 12th, 2011 - by Angela

excel-tipsSince the number one application that I do training on is Excel, I thought I would include some tips on Excel in this post.  Most of the training requests that I get are for Excel Intermediate or Advanced.  Over the years, it seems that there are a few features that have come in handy several times, either for myself or in helping others in a training class. I hope you are able to use these tips, too!

 For those of you who use the database features in Excel, leading zeros may present a problem. For example, say you are entering names and addresses.  In the Zip Code field there may be a zip code beginning with a zero (05678). When you key in 05678 and press enter, Excel will not display the leading zero. Excel will display the number as 5678.

One way to correct the problem is to create a custom number format for all the cells in which you might be entering numbers beginning with a zero. To create a custom number format, first select all of the cells in which you will be entering numbers that might begin with a zero. Right click on that selection and choose Format Cells. On the Number tab, choose Custom under Category.

In the Type field, clear any displayed information (General, for instance) and enter a zero for every digit - including zeros - you want to show in the selected cell or cells. For example, if you wanted to enter 05678 you would enter 00000 in the Type field. Then all you need to do is click OK-a very simple solution to a one of those frustrating Excel situations!

Another tip to use within Excel’s database element (in the 2007 and 2010 versions) is the Excel table feature.  You can use the Table feature to help you calculate, format and sort data quickly. If you have ever needed to make an Excel spreadsheet look good in a hurry, then you will love the table feature.

To give your spreadsheet data a more professional appearance, start by selecting the data range and clicking on the Insert tab.  (NOTE: It will not work if you have blank rows between your column headings and your actual data.) Click the Table icon from the Table group to determine your range and click OK.  Next, select from one of the pre-designed table styles.  Click the “Total” check mark in the Table Styles option group and then scroll to the last row in the table.  If you click the drop-down arrow to the right of the column(s) you want summarized, you can then choose to Average, Count, Sum, etc. To sort the data on a specific column, you can click the down arrow at the top of that column and choose the sort option you would like.

Another question that I have dealt with recently was related to conversions between different measurements.  In the process of helping someone from another country, I had to figure out some exchanges between our American standard of measure and the Metric system.  Since I do not have all of those conversions memorized, I was able to use Excel to help out. If you have ever had to convert miles to kilometers, inches to centimeters, or Fahrenheit degrees to Celsius degrees then Excel can help you, too.

For Excel 2007/2010 users, click the Office Button in 2007 (or File tab in 2010) > Click Excel Options button > Click Add-Ins on the left > Click on Analysis ToolPak from list >    Make sure Excel Add-Ins is selected in the Manage box > Click Go.  Click to put a check mark in the box next to Analysis ToolPak and then click OK to return to your worksheet.

For Excel 2003 (or earlier) users, Go to the Tools menu > Select Add-Ins > Select the Analysis ToolPak check box > Click OK.

Then, you can use the Excel functions to do the conversions.  For example, if you want to convert 2 1/2 pounds to kilograms, use the following Excel function: =CONVERT(2.5, “lbm”, “kg”) Your answer should be 1.133981. To find the kilogram equivalent of 1 pound, just replace 2.5 in the formula with 1.0, which should yield a result of 0.453592.  For a complete list of measurement unit conversions available in Excel, visit the following Microsoft web site: http://office.microsoft.com/en-us/excel/HP100623111033.aspx

Hope you are able to excel with Excel using these tips!

Useful Word Tips

September 7th, 2011 - by Angela

word-tipsEvery once in a while, I go back and look over my tips and tricks file for different applications.  This month, I reviewed the file for Word.  I use Microsoft Word almost every day, so I think reviewing over the shortcuts, tips and tricks at least once a year is definitely worth the time investment.  I know I cannot remember everything, so a refresher course on Word is extremely helpful!  I thought I would share a couple of the ones that the students in my Word classes really like including turning off the Automatic Word Lists and shortcuts to adding lines.

One of the most frustrating experiences in Word can be when you type 1 at the beginning of a sentence, press the Enter key which takes you to the next line and the number 2 automatically appears. Word’s insistence on automatically creating a list if a number or symbol is typed at the beginning of a sentence can be annoying.  As you may have noticed, Word automatically makes changes once it senses a pattern in your list.  This auto-formatted text can become tedious to change when you want to begin a sentence with a number or bullet point without beginning a new list.  Here is a simple solution.

If you wish to turn off Auto Formatting in Word 2007, click the Office button (if using Word 2010, click the File tab), Word Options, and Proofing; click the AutoCorrect Options button; select the AutoFormat As You Type button; remove the checkmarks from the Automatic Bulleted Lists and Automatic Numbered Lists, click OK, and click OK again. If you are using Word 2003, click the Tools menu, select AutoCorrect Options, choose the AutoFormat As You Type tab; remove the checkmarks from the Automatic Bulleted Lists and Automatic Numbered Lists, and click Apply.

The feature can easily be turned back on if needed by following the steps above and clicking to replace the checkmarks that were removed. No more automatic lists in Word!

Have you ever wanted to quickly insert a line below the text that you just typed in Microsoft Word? There is a simple way to do this without using the borders feature. Follow these steps:

Key the line of text in Word

Press Enter

Key three hyphens

Press Enter

A line appears below the text! For a double line, follow the steps above but key three equal signs instead of three hyphens. For a bold line, follow the steps above but key three underscores (Shift + hyphen) instead of three hyphens. For a dotted line, follow the steps above but key three asterisks (Shift + 8)  instead of three hyphens. It is that easy!!

Enjoy these tips and remember to review them regularly so that you do not forget them!