Archive for the ‘Uncategorized’ Category

Make Your Training “Just Right”!

November 21st, 2011 - by Angela

statisticsI ran across some statistics today that I did not want to see.  It was a survey about corporate training.  Almost half of the respondents thought that the corporate training they received was “too boring” and a quarter of them thought it was “irrelevant”.  Less than five percent thought that their corporate training was “just right”. 

Ouch!  How do we move more of those folks from the irrelevant/too boring camp into the “just right” camp?  How do we get training and development aligned with the needs of our organization so that more people find the training useful?  Every corporation wants their employee training to be successful and for the skills learned to transfer to their jobs.  So, what do we do?

Here are some ideas that can help make your training program less boring and more relevant:

* Assess the training to see if you even need it.  Some problems may be attributed to a person that is not in the right position or who does not have the right personality for that position.  

* Make sure that you show a direct link between the training and the participant’s job before, during and after the training session.  The participant needs to understand the importance of the learning from the session in direct relationship to the ability for that person and the organization to be successful. 

* Use a reward, where appropriate.  Some employees would be more motivated by having an incentive or reward when they reach certain levels of performance in training.  These rewards do not need to always be monetary, so get creative!

* When creating a training session, look for training methods and classes that have measurable outcomes.  When participants know what to expect, then they will be able to see the link between the training and their job more clearly.  Make sure and provide a way for the participant to evaluate and give feedback about the training, too.

* It is incredibly helpful when the supervisor for each participant knows what the training will encompass and what will be expected post-training.  When the supervisor realizes the importance of the training, they can reinforce that with the participant prior to and after the training.

I hope these tips are helpful to your organization’s training!

Computer Literacy

November 14th, 2011 - by Angela

computer-literacyRecently, I was talking with a friend who happens to be a university college professor. He remarked on how his junior and seniors knew everything about Facebook but knew little about true computer literacy.  He was disappointed because he knew that these students grew up using computers, but they only knew how to surf the web, participate in social media, and play games. 

In order to get all of the students up to speed in class, he spent a whole class period demonstrating tasks like saving to a USB drive, creating a research paper in Word, and using data in Excel to create a chart.  Additionally, he took his students to a keyboarding website, where they could increase their speed and accuracy.  He knew that his students needed this information to not only succeed in his class but in the competitive job market, as well.

His statements really made me think about the skills that are needed to not only get a job but to keep a job.  I did a little online searching to see what research was available for computer literacy rates for high school graduates.  I was not surprised to find that what my friend was stating seemed to be the general thought across many university, community college, and workplace findings.

If our high school graduates do not have those skills, when are they going to get them?  How do we expect them to succeed if they go to college or if they go straight into the workforce?  Of course, my trainer side immediately begins screaming, “Training!  Get them a one-on-one training session right now!”

If you are not proficient in Word, Excel, PowerPoint, and Windows, you do not have the skills that most jobs require right now.  Can you type at least 40 words per minute (while not looking at the keyboard)?  Can you quickly locate a file stored on your computer and create folders to organize your files on your hard drive or USB drive?  If not, you need to give me a call!  Set up a deskside training session or a whole class (if you have multiple people who need the same training).  This little investment can pay off with big dividends.

You do not want to be at a disadvantage in our highly competitive job market.  Computer literacy is a key factor in your ability to succeed in finding and keeping a job!

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!