|
Choose The Best Program For The Job
14 December 2008 Choosing The Best Program For The Job
The Microsoft Office System offers so many choices for accomplishing most tasks that sometimes it can be hard to even know where to begin. So, like most people, you get comfortable with one program and use it to do everything it possibly can.
But, here's the thing. Each program in the Microsoft Office System is a specialist—an expert with its own unique purpose. When you use the right specialist for any job, you are certain to spend less time and get better results.
With that in mind, this article will help you get started by looking at four key types of business tasks and offering recommendations of which program is best for your particular needs.
Organizing Notes
If you're a meticulous note-taker, you probably create a lot of bulleted lists in Microsoft Office Word. And, for their part, lists in Word are surely a big improvement over that sky-high stack of legal pads next to your desk or the bulletin board covered in sticky notes. But, while nothing beats Word for creating most any kind of document, there is an Office program that can take your notes, reminders, and to-do lists to a level that just might astonish you—that's Microsoft Office OneNote.
So, when do you turn to OneNote or Word? Take a look:
|
If you want to… |
Use this program… |
Because… |
|
Create an easily-organized, unlimited, multi-subject notebook that can travel with you |
OneNote |
OneNote is the perfect notebook. It never runs out of pages, lets you categorize and arrange your pages in a couple of clicks, and enables you to e-mail notes to colleagues for easier collaboration. |
|
Capture most every kind of note—from typed lists to hand-written meeting notes, audio and video recordings, and even your favorite doodles—all in one place
|
OneNote |
OneNote lets you keep different types of notes together for easy reference. Markup your typed list with handwritten notes, or record a presentation to review later—and access them all from the very same page. |
|
Collaborate and brainstorm with colleagues during a meeting
|
OneNote |
Share your live OneNote session with colleagues working on their own computers. Enable others to view your notes as you take them or even take and edit notes as a group. |
|
Help protect your sensitive information
|
Word or OneNote |
In Word, you can allow editing or commenting on just part of your document and\or by certain people only.
With OneNote, you can password protect notebook sections to keep them confidential. |
|
Create detailed outlines to deliver to others as a document
|
Word |
Word's outline numbering and list style features provide flexible, dynamic outlining and formatting options that help turn a basic list into a polished document. |
Of course, Word and OneNote also work great together. OneNote lets you send your notes to Word so that you can go straight from the conference room to writing your report, without unnecessary stops and extra typing. OneNote also works well with with Microsoft Office Outlook. You can create tasks, appointments, and contacts directly from OneNote, or add Outlook calendar details to a OneNote page.
Creating Documents and Presentations
You can create and format text, tables, charts, and graphics in Excel, Microsoft Office PowerPoint, or Word (or Microsoft Office Visio, for that matter). Can that be right?
Well, yes and no. Though each program has abilities in each of these categories, remember that they all have their specialties. When you use the best program for the job, you'll be amazed at how great your documents can look—and how much less time you'll spend getting them done.
|
If you want to… |
Use this program… |
Because… |
|
Create any kind of document—from a basic memo to a complex report with text, tables, and graphics
|
Word |
From professional branding for letters and memos to complex presentations and reports, Word is the most effective home for your documents. |
|
Create multi-media presentations to deliver to a group, over the Web, or to send electronically
|
PowerPoint
|
Save a slide show to the Web for easy access by clients, or use the Package for CD feature to send a multi-media presentation and know that it will run like clockwork. |
|
Create diagrams and flowcharts for your documents
|
PowerPoint of Visio |
For simple flow charts or diagrams, PowerPoint gives you a host of timesaving tools to create graphics for your slide show or add to your Word document.
For intricate diagrams or those that need to change over time—try Visio. |
|
Analyze and chart data for your documents |
Excel |
For financial tables that are easy to calculate and look great in your finished report, crunch numbers in Excel and then paste them into Word as a Word table. You can format the table using your document's styles.
And, get the most powerful, flexible charting tools when you chart your data in Excel. |
Collecting Information
Every program in Office can help you collect and store information in one way or another—but the best program to use for your particular needs depends on the type of information, where it's coming from, and where it needs to go. A good rule of thumb when using Office to manage information is this—if you have to type the same thing twice, you can bet there's an easier way.
|
If you want to… |
Use this program… |
Because… |
|
Create forms that can deliver information to Access, Excel, Word, or other programs
|
InfoPath |
It doesn't take much more than dragging and dropping to create professional-looking, electronic forms. And, because InfoPath is Extensible Markup Language (XML)-driven, it's a snap to deliver form data wherever you need it to go. In fact, the data from a single InfoPath form can be split apart to go to multiple databases or even automatically reformatted into multiple reports. |
|
Create a form based on an existing data source
|
InfoPath
|
InfoPath can build forms from your existing Access or Microsoft SQL Server databases, Web services, or an XML document or schema. |
|
Collect and store large amounts of data that can be used to generate a variety of reports
|
Access |
Access is a powerful, relational database that makes it easy to store and access large amounts of data. When you need to continually add to your data or reorganize results without having to reorganize the main data source—that's the time to call upon Access. |
|
Create a simple database, with limited amounts of cross-referencing
|
Excel |
Excel can be a fast and easy solution when you just need to sort, filter, or calculate a relatively limited amount of data (an Excel worksheet has 65,536 rows—so it doesn't have to be that limited).
Note If you start with Excel and find later that you need a relational database, import Excel data into Access with just a few clicks. |
|
Customize and organize your e-mail, contact and scheduling information
|
Outlook |
Categorize your contacts, tasks, and appointments; set rules to automatically sort your e-mail as it arrives; do a mail merge in Word directly from your Outlook contacts.
Note You can also create a mail merge in Word from data saved in Excel or Access. |
When you take advantage of what each program has to offer, you can spend less time inputting information and more time making the information work for you.
Working with Data
Excel and Access have a lot in common when it comes to managing data. But there are key differences to know about that can save you tons of time.
Access is the source when you need to store and manage large quantities and different types of information that can work together. On the other hand, nothing beats Excel for crunching numbers. And, numbers or not, Excel can make your basic information lists much more dynamic (with much less work) than you might expect.
|
  |
|
