Archive for the ‘Office 2007’ Category

Office Tip: Format Painter

Thursday, January 14th, 2010

Have you noticed that small paintbrush on your formatting toolbar (Office 2003) or the Ribbon  (Office 2007)? As an instructor, I’ve found that most people ignore it, or don’t even notice it, because they don’t know what it does.

That little paintbrush is called FORMAT PAINTER.  It’s an extremely useful formatting tool that cuts down on formatting time as you work in any Office document (Word, Excel, PowerPoint, Publisher.)

Format any selection of text. Select that text and click the FORMAT PAINTER once and your cursor turns into a small paintbrush. You can now select a new chunk of text and the same formatting will be applied.  Once you click off the text, the paintbrush goes away and you can continue working on your document.

This is useful if you’ve applied bold, underline, and a new font.  Instead of choosing all 3 of those options again, you need to only choose the FORMAT PAINTER.

If you want to apply certain formatting to more than one selection, double-click the FORMAT PAINTER. Your cursor will remain a paintbrush and allow you to change the formatting to as many different areas as necessary. When you are done formatting, click the FORMAT PAINTER button again.

For more tips to help you be more productive, attend any of our Microsoft Office classes! All of our instructors love to help you learn all the tips and tricks!

  • Share/Bookmark

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

Using Office at Home

Tuesday, October 20th, 2009

Initially, most people use Office 2007 at work, and apply the things they learn to their jobs and look for ways to make things run more efficiently at the office.  Office 2007 can help make your entire life simpler!  You don’t even need to start from scratch.

If you’ve ever used a template that someone else made (or that you created) for work purposes, there are also many templates available for home purposes. If you’re a parent, there is a Microsoft Office Parent Toolbox that provides ideas and templates to make things easier on the homefront.  While I could have created a potty training chart for my 2yo from scratch, it was much simpler to download an existing one and apply it right away! (she’s doing great – - thanks for asking!)

At the Parent Toolbox, you’ll find templates and documents made in Word, Excel, and even PowerPoint! No matter what you need to run your home more efficiently, you’re bound to find a tool to help.  Microsoft Office 2007 is a tool you can use throughout your life!

  • Share/Bookmark

Office 2007: Quick Access Toolbar

Thursday, October 15th, 2009

When upgrading from Office 2003, the loss of familiar tool bars is sometimes upsetting to users. If you like your buttons laid out on a toolbar, you can easily customize the Quick Access toolbar.  The Quick Access toolbar (or QAT) is located at the top of your screen, next to the Office button, and above the Ribbon.

Click on the down arrow at the end of the QAT and you can add a small number of additional commands to the existing three commands. Those choices are not your only ones!  Choose MORE COMMANDS and you will be taken to the Options dialog box and a large variety of commands that you can add. From this window, you can also choose to move the QAT below the Ribbon.

The QAT is customized for each individual software program, and each program has specific commands available. Some of the commands are not found on the Ribbon at all, but can be found by adding buttons to the Quick Access toolbar.

If you’ve inherited an installation and you want to create your own QAT, choose RESET at the bottom of the Options window.  The three original buttons will appear and you can customize to your liking.

For more tips & tricks about using Office 2007 efficiently, attend one of our many classes.  We look forward to sharing our knowledge with you!

  • Share/Bookmark