Posts Tagged ‘Office’

Office Tip: Macros

Tuesday, July 6th, 2010

Macros allow you to automate something that you do often, and may require many steps to accomplish. Recording macros is a fairly simple process, but sometimes errors occur.  There may be times when someone else has created (or programmed) a macro in VBA (Visual Basic for Applications) but didn’t thoroughly test it. If you run a macro and it gets stuck, or loops endlessly, press CTRL + BREAK and you’ll be able to enter the Visual Basic Editor and step through the remaining steps of the macro (or just exit!)

This tip will work for macros created in all Microsoft Office programs.

To learn more great tips, attend one of our many Microsoft Office classes.  We’ll hold a seat just for you!

  • Share/Bookmark

Tags: ,
Posted in Office | No Comments »

Office Tip: Smart Art Customization

Thursday, April 22nd, 2010

Smart Art has been a great addition to the Microsoft Office suite in 2007.  It allows you to create complex and great-looking graphics to represent organizational charts, processes, lists and more. Sometimes, though, you want to add more information to the graphic and you might think you are limited to the Smart Art as it is presented.

The most common addition is adding a callout graphic to add a note to one of the pieces in your Smart Art graphic. In both Word and Excel, you will go to the INSERT tab, and then choose SHAPES in the ILLUSTRATIONS group. You will find a CALLOUT graphic, or any other shape you may want to add. Move the shape where you need it, and then add your text.

In Microsoft PowerPoint, you will find the CALLOUT graphics on the HOME tab, in the DRAWING group.

If you want to learn more ways to use Microsoft Office to increase your productivity and skill levels, please consider taking a class! We look forward to teaching you some of the tricks we know.

  • Share/Bookmark

Tags: ,
Posted in Office, Tips | No Comments »

Office Tip: Language Packs

Tuesday, April 20th, 2010

One of the frustrations of multi-lingual people using Microsoft Office has been the difficulty of having spell-check and other features in a language other than the installed language.  Microsoft offers FREE Language Interface Packs in a variety of languages to download, which gets rid of this frustration.

To check out the languages offered, visit this link. The Language Packs work in Microsoft Word, Excel, PowerPoint, and Outlook for both Office 2003 and Office 2007.

For more tips and tricks on using Microsoft Office to the best advantage, take a class with us! We look forward to seeing you soon.

  • Share/Bookmark

Tags: ,
Posted in Office, Tips | No Comments »

Microsoft Office 2003 to 2007

Thursday, December 10th, 2009

All of our public classes are taught in Microsoft Office 2007, and we do our best to help those who have recently transitioned to the upgrade.  I’ve been using word processors and spreadsheets with drop-down menus for almost 20 years, so the Ribbon took some time to become comfortable. I knew how to do everything from the drop-down menus, but once I learned the Ribbon, I learned to like it.

Microsoft knows that there have been major changes with how users interact with Office 2007, and they want to help make it easier.  At their website, they offer interactive guides to help you figure out how to do everything in 2007 that you did in 2003.  Using their online guides, you can enter a question (for example – how do I import data into Excel from an external source?) and it will show you how it was done in Microsoft Excel 2003, and then how to do the exact same thing in Microsoft Excel 2007!

These guides are available for all software packages in Office, except Publisher.

We’d love the chance to show you around Office 2007 in person, though! Attend any of our Microsoft classes for personalized and in-person instruction.

  • Share/Bookmark

Tags: ,
Posted in Office, Office 2007 | No Comments »

Office 2010: What to Expect?

Tuesday, November 10th, 2009

Sometime in 2010, Microsoft will release Office 2010!  This news may encourage some users to upgrade to 2007, or they may decide to wait until 2010 hits the shelves.  No matter what version of Office you’re currently using, there are some great new features that will be available in Office 2010.

What can you expect in Office 2010?  While much of it will look the same, they have added the Ribbon to Outlook, Publisher, Visio and Project!  Each piece of the suite will now have a similar look and feel. Users will also be able to customize the Ribbon to make it more efficient for individual needs.

For users that loved the improvements to Pivot Tables in 2007, they will be excited at the upgrades for Pivot Tables in 2010.  Not only are there more features, but they have added Slices — which makes Pivot Tables even more useful and user-friendly.

Feel free to visit Microsoft’s website and watch short videos about the changes in Office 2010.  And, then plan to come in for some training so you can learn all the new tips & tricks next year!

  • Share/Bookmark

Tags:
Posted in Office | No Comments »