Posts Tagged ‘Microsoft’

Certification

February 16th, 2010 - by Angela

ub_cs_graduationHave you ever thought about becoming Microsoft certified in Word, Excel, Access, Outlook or PowerPoint? I’m surprised at how many of the clients I train have not thought about adding a Microsoft Office Specialist certificate to their list of accomplishments.

How many times do people go to job interviews and say they know Excel at the expert level but are not able to deliver once they are hired?  I think it would be so important to be able to back up my skills with a world recognized certificate from Microsoft.  Not only would I be able to say that I knew the software but Microsoft would say that I knew the software.

I must note that Microsoft has not made it easy to understand the certifications.  The name of the certification has changed from MOUS (Microsoft Office User Specialist) in the 97 Office version to MOS (Microsoft Office Specialist) for 2000, XP, and 2003 versions to MCAS (Microsoft Certified Application Specialist) for 2007 version. Since I have been certified since the 97 version, I sometimes don’t know what to call myself.

Each certification, though, has definitely contributed to my career path. Having the certifications on my resume has helped me to succeed in reaching several of my goals. Not only have they contributed to my life, but I’ve watched many students build their confidence in their skills by studying for, taking and passing the tests.

Several times I’ve done one-on-one training sessions for clients that are studying to take a Microsoft certification test. The training is an investment that can have a big payoff if you are able to advance in your career with the new certification. 

If you are interested in taking one of the certification exams, start at the Certiport website. (http://www.certiport.com) They administer the Microsoft exams.  If you need some training to help study and get ready for the exam, let me know! At Versitas, we love helping you succeed!

Great Tools!

December 15th, 2009 - by Angela

toolsThis past week, I did a customized 1-on-1 deskside training class on specific topics in Microsoft Excel, Visio, and Project.  It had been a while since I’d done training on Visio and Project. As we went over the individual’s questions, I was reminded of what great tools Project and Visio are.  (Note: Versitas doesn’t sell any of these products, so these are just my personal thoughts on the software.)

If your company uses either of those applications, I’m sure you know what I’m talking about.  If you don’t, I’ll fill you in.  Visio is a drawing software that lets you turn your designs, diagrams and maps, etc., into visual documents easily. You can create flowcharts, organizational charts, maps, and much more.  There are stencils available with all kinds of shapes to use for your designs.

The student I was working with was mainly concerned with floor plans.  She had scanned in her floor plans and wanted to plot items on those plans. She had an Excel spreadsheet listing all of the items and their dimensions/specs.  I showed her how to import the Excel spreadsheet items in a list in Visio that she could use to drag those specs onto the items/shapes she had plotted in Visio.

It was all so easy!  She thought she was going to have to go shape by shape and type in all of the information.  It was one of those “happy trainer moments” to see the look of relief on her face when she realized the time she was going to save.  Also, she was now going to be able to WOW her clients with the quality of her presentations.

We also worked with some Introductory topics in Project.  Project is a project management software that assists in developing task timelines, planning and managing budgets, assigning and tracking resources, and assessing progress.  Some people think Project is too complex.  With a little training, it doesn’t feel overwhelming at all.  In fact, it really can help a project manager in so many aspects.

Most of my student’s projects initially followed a similar pattern and format setup.  I told her that she would need to spend some time setting up a generic template.  After creating the first one, she could use that template for her other projects.  She would have some date adjusting and other tweaking to do but those would require little time if the template was set up correctly.

We really had a fun training session.  She was excited to see how these tools could work for her.  I was happy to see what a great help the software would be for her with just our half day of training.  It made me realize once again that the software we use can be so useful to our jobs!

Thoughts on Office Live Workspace

September 28th, 2009 - by Angela

microsoft_windowsofficelive4

This week I’ve been trying out a couple of new products that I haven’t had time to experiment with yet.  They aren’t new technologies but are some things I’ve wanted to try out.  My main goal was to see if they were useful enough to recommend to clients, especially since they are free software.

 

In my training with Versitas, I am sometimes asked about my evaluation of different software.  I know that not everyone is working with unlimited budgets these days, so I try to look for add-ons that can work with someone’s current software. 

 

So, I found a little time this week to try out Microsoft Office Live Workspace and SharedView.  Office Live Workspace is supposed to be able to work seamlessly with Microsoft Office 2007 to give you space to store, edit, and share files with others.  I thought that might be a good option for some of my clients if they did not have the IT manpower to set up and maintain a SharePoint server.

 

I purposefully did not read any reviews or evaluations of Office Live or SharedView.  I wanted to get my take on it without being biased by others’ thoughts.  Here is the scoop on Microsoft Office Live Workspace (technically in beta version).  You can upload, store, and share any Microsoft Office Word, PowerPoint and Excel document.  You get 5GB of storage room!  I like this alternative to a flash drive for use when I am training.  SharedView allows you to connect with others to view, share, edit, and collaborate on documents.  This is a great option for me to use if I need to create training materials with other trainers located in various cities. 

 

So, how did it go?  The account setup process for Microsoft Office Live Workspace was very easy.  Since I already had a Hotmail account, I didn’t have to enter any personal information.  It is a big plus in my book if I don’t have to remember another username/password!  During the download/install process for SharedView, it was recommended that I download Silverlight, an XML update and Sign-in Assistant - all free.  The whole process only took about 20 minutes.  I like that kind of quick installation!

 

I created a workspace for my Versitas files and uploaded several to try it out.  When I opened up Microsoft Word and clicked on the Office button, I have the options to “Open From” and “Save To” Microsoft Office Live Workspace.  You have to log in the first time but can change the settings so that it will automatically log you in for future use.  Cool!  I have a access to all of my uploaded documents that I put into my created Versitas workspace on the Office Live website.

 

My overall opinion?  Pros: Easy to install and use.  Cons: Can only upload files that are Word, Excel, or PowerPoint.  If I were Microsoft and designed a free software, I’d probably limit that, too.  This software is not for everyone but I would recommend it for clients that need basic collaboration and/or Microsoft Office file web storage that is easy to use.  You may want to give it a try!

Upgrading from Office 2003 to Office 2007

August 18th, 2009 - by Angela

Early last year I made the jump from Office 2003 to Office 2007.  I had heard and read about how different the new user interface was and had even seen it demonstrated at a conference.  Even so, I still get a little concerned when I make the move to a new software version.  I don’t think I was completely prepared for how dramatic the changes were. 

In order to even install the upgrade, I had to double the memory on my laptop.  (There have been many times that I wish it were that easy to upgrade our brains.  Why can’t I just double my memory from time to time?)  Then, after reading several articles on upgrading hints/tips, I adjusted several other settings to make the best use of the software on my computer.  Whew…I was already worn out and had not even started playing around with the software yet!

Fortunately, I had a week long series of Microsoft Office 2007 training classes coming up in the next month.   I was glad to have that scheduled so that I would feel the pressure to really digest the new software quickly and not procrastinate and learn it as I went along..  Once the training started, it was good that my upgrade experience was fresh in my memory so I could answer questions from students about upgrading their home computers to match their work computers.

Here are some things that I learned that might help you if you are upgrading to Microsoft Office 2007.

1)  Be patient with yourself.  The new user interface uses tabs, wide toolbars, and drop-down groups of items (officially called ribbons and galleries).  After using the menu for File -> Page Setup, it is difficult when there is no longer a menu at all.  Initially, I spent most of my time looking for each item’s new location.  It took me about a month of solid use to get used to all the new tabs and buttons. 

2)  Really take time to examine each tab and button group.  Just like when you learn a new language, you have to understand the structure of sentences and grammar, so you have to learn the structure of the new interface.  Microsoft did a good job in creating the new interface.  For the most part, it does make sense where most items have been placed.  I think the new interface is much more user friendly than previous versions.

3)  Try out some of the new features, like Smart Art and Live Preview.  I am so addicted to having Live Preview!   When I do training in Office 2003, I get frustrated when I remember that I don’t have that feature.   I also like the ability in Excel to be able to type a long formula and not cover up the column headings!  The color schemes are really amazing, too. 
 
5)  The one piece of the software suite that was not changed much is Outlook.  It had a dramatic overhaul in a previous version, so you will still see the regular menu like you had before in combination with some new ribbons and galleries.  Also, you can use the launcher button in many of the groups of buttons on the tabs to get to the dialog box that looks like the 2003 version.
 
6)  If you look at the tabs on 2007, you’ll see the buttons grouped together.  In the bottom right corner of each of these groups, there is a button that looks like the right and bottom side of a square.  This launcher button will open a dialog box that relates to that group of buttons.  So, if you are in Word 2007, on the Home tab in the Font group, click the launcher button.  It will open the Font dialog box that you remember from version 2003.

7)  If you are struggling initially, most of the old shortcuts will still work.  Because my last name has a tilde symbol (~) over the “n”, I use the Alt+I, S, shortcut to get to the symbol dialog box.  That still works in the new Office 2007 version.  You can always go to the good old Help button and search for the shortcut list for more of these. 

Of course, just about the time you’ve mastered Office 2007, Microsoft will release their newest offering Office 2010….here we go again!

Software Training in a De-personalized World

August 3rd, 2009 - by Angela

Last week I was working on my laptop in the living room and received an email from my husband. He was in our bedroom study…just a couple of steps away in the room next to me.  I’m not kidding!  In another instance, a friend of mine told me about the time she found her four children all sitting in the same room together but arguing with each other on Facebook.  What’s happening here?

 

On a television show last month, I watched an interview with a dad whose daughter had racked up thousands of text messages in one month.  Fortunately he didn’t have to pay the almost $3,000 that the bill would have been because he had an unlimited texting service plan.  Instead of talking to the daughter in person, the father texted her to tell her that she was grounded from texting.  These are three examples of de-personalization in our everyday lives.

 

Advances in technology (such as chatting online, communicating via Facebook and Twitter, and texting on cell phones) have depersonalized so many social parts of life.  It’s not necessarily all bad, but it’s important to be aware of it.

 

In many of my software training classes with Versitas, I hear students comment on how important human interaction is to help them learn.  When offered online versus in-person classes, I have many students that choose to attend the in-person training class.  It seems that many people are craving training that is taught by an actual instructor in the classroom.  Especially when employees are sitting in cubicles all day communicating via email and phone, in-person training often seems to boost morale by allowing actual human interaction between the employees.

 

Although online classes might be the perfect match for some students, other students consistently prefer to attend an instructor-led training class.  Every training method must compete for the attention of students, who must often check email or voicemail during the training.  This is where in-person training can be very helpful.  The personal touch of meeting eye-to-eye with an individual gives a personal contact that happens during in-person training. The nuance of feeling the moment and understanding when an individual needs that extra bit of attention is an important ingredient and helps to really teach the skills that are needed in today’s corporate environment.

 

Individuals in a corporation like everyone else want to know that they are being listened to and taken seriously.  Learning new applications or programs like Microsoft Access, PowerPoint, Excel, etc., can be anywhere from overwhelming to monotonous and impersonal when an individual tries to learn something on their own.  With an instructor carefully listening to their questions and needs, I believe it can help create a better learning experience.

 

After all, isn’t that what it’s really all about?