Posts Tagged ‘spreadsheet’

There’s a Template for that!

January 25th, 2010 - by Angela

word-template-createRecently one of my family members, after many years of contemplation, decided to open her own business. She gave me a call and asked me to help her create some of the forms she’ll need.  I was impressed that she had already assembled some paper forms that she liked to use for ideas when we created the ones for her soon-to-be formed new company.

Initially we tried to start from scratch, using her logo and colors, to create the forms.  We worked for a while on this and did not get very much accomplished.  Then, it hit me…TEMPLATES! I am a little embarrassed to say that I didn’t think of doing that first. They should take away my trainer badge some days!

I immediately opened the list of templates within Excel. We found some great invoices, receipts, statements, etc.  We were able to start with the forms she liked and then customize them to fit her logo, design, and contact information.  We also went into the Word templates and created a fax form (that she could use to fax from within her computer or print and use with her fax machine) and letterhead. She was delighted with the end results of our forms.

Next, I showed her how she could create labels with mail merge using Word and either her Contacts list, Excel spreadsheet list, or Access database table.  We also discussed how she could import and export data back and forth between the different Office applications.  She was excited at how many options there were. 

After creating the different forms, we decided to design a PowerPoint presentation for her to use in sales meetings with potential clients. I didn’t make the same mistake that I had with the forms.  We went straight to the templates this time.  I showed her the design slides that we could customize with her logo, colors and information.  She was glad that there were even some presentations with content for sales presentations to guide her.

If you own or are opening your own business, it would be well worth your time and money to invest in training.  A trainer could show you how to make your business operations work more efficiently by using Microsoft Office effectively. I definitely believe that it is better not to re-invent the wheel when you could save time by customizing templates that others have willingly shared.

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!