Friday, September 4, 2009

Outlook Tips - Create Email Template

Sometimes, you may find that you will be sending emails of the same content again and again (maybe to send monthly report, etc...) and you'll find that you have to type same sentances for these emails again and again.

If that's the case, try saving the email message as a template and later you can reuse it.
  1. Compose new email as you usually do with normal emails. Put in the subject and if you are going to always send to the same receipient, you can put the receipient email addresses in the To, CC or BCC field.
  2. Once complete, click the Office Button and select Save As.

  3. In the Save As dialog box, change the Save as type: to Outlook Template.
  4. Name the file and select your file location if you want to save it in different location or just leave it in the default template location as it is.

For earlier version users, you must first disable the Use Microsoft Office Word 2003 to edit e-mail messages feature found in Tools > Options menu under the Mail Format tab of the Options dialog box.

Follow the steps 2 to 4 as stated above (slight difference in step 2 where you should click File menu instead of Office Button).

To use the template (same process for Outlook 2007 or earlier):

  1. From Tools menu, go to Forms and select Choose Form... .

  2. In the Choose Form dialog box, select User Templates in File System from Look In: combo box.

  3. Select the template listed or click the Browse button if the template is in other location.
  4. Click Open.

Now you can continue to add attachment(s) or amend the template as required.


Monday, August 24, 2009

PowerPoint Tips - Create Your Own Shape

Lets create our own shapes by changing standard shape with PowerPoint 2007.
  1. Select a shape and place it on your slide (I selected an oval). Resize it as you want.
  2. With the shape selected, go to Drawing Tools ribbon, Format tab.
  3. Click Edit Shape from Insert Shapes group and select Convert to Freeform.

  4. Repeat step 3 but this time select Edit Points. You will see the shape will have multiple points for you to adjust.

  5. Now you can drag any edge of your shape to form a new shape of your own.

    (Sample of a new shape made of two circles. One as the body and the other as the head, grouped together as one shape)


Word Tips - Upgrading Equation Editor for Word 2003 to MathType

MathType by Design Science is the powerful, full-featured version of Equation Editor. If you frequently include equations in your documents, you will find MathType is much better suited to your needs.

MathType is as easy to use as Equation Editor and has many extra features to help you work faster and create better-looking documents.

MathType includes:
  • Euclid™ font set with hundreds of additional math symbols.
  • New templates and symbols for geometry, chemistry and much more.
  • Professional color support.
  • Create equations for World Wide Web documents.
  • Translators that output equations to other languages such as TeX, AMS-TeX, LaTeX, MathML and custom languages.
  • Special commands for equation numbering, formatting, and converting Microsoft Word documents.
  • Customizable toolbars to hold hundreds of your most frequently used symbols, expressions and equations.
  • Customizable keyboard shortcuts.
  • A comprehensive printed user manual, loaded with tips and tutorials.
  • Much more…

Design Science continuously enhances MathType, implementing the latest technology to make equation writing easier and compatible with all your favorite software.

Visit MathType on the World Wide Web, or call Design Science to receive complete and current information about MathType.

Design Science, Inc.
(800) 827-0685 (United States and Canada only)
(562) 433-0685 (outside the United States and Canada)
(562) 433-6969 (fax)


World Wide Web:


Sunday, August 23, 2009

Word Tips - Create Complex Equations in Office Applications

Creating complex formula is hard but things get easy with the equation builder in Microsoft Word.

Word 2007 users can easily find the function from Symbols group under the Insert tab.

You can click on the upper part of the Equation button to create your own equation or click the lower part to select any of the built-in equations.

You can also combine your equation with the built-in equations from the Equation button under Tools group in the Design tab.

For earlier Word version users, you will have to add the Equation Editor button onto any of your existing toolbars (you can create a new toolbar if you want to) or menus.
  1. From View menu, go to Toolbars and select Customize.
  2. Click Commands tab.
  3. Select Insert under Categories:.
  4. Drag the Equation Editor button found under Commands: into any toolbars.

  5. Close the Customize dialog box and now you can add your equation by clicking the Equation Editor button you've just added. You will see the Equation toolbar and an empty placeholder is ready to put your equation.

  6. Same for Word 2007 or earlier version, just click in the dotted boxes and replace with any symbol, number or alphabet you wish to use.
  7. Once complete, click anywhere outside of the equation placeholder.

    (Sample of equation... Do you think you can easily create this equation without the equation builder?)

You can also copy this equation into PowerPoint or Excel if you want to use the same equation in these applications.


Saturday, August 15, 2009

Visio 2007 Top 10 Benefits

Microsoft Office Visio 2007 drawing and diagramming software makes it easy for IT and business professionals to visualize, explore, and communicate complex information. Go from complicated text and tables that are hard to understand to Visio diagrams that communicate information at a glance. Instead of static pictures, create data-connected Visio diagrams that display data, are easy to refresh, and dramatically increase your productivity. Use the wide variety of diagrams in Office Visio 2007 to understand, act on, and share information about organizational systems, resources, and processes throughout your enterprise.

Office Visio 2007 is available in two stand-alone editions: Office Visio Professional, and Office Visio Standard, which has the same basic functionality as Office Visio Professional but includes a subset of its features and templates. Office Visio Professional 2007 includes advanced functionality, such as data connectivity and visualization features, that Office Visio Standard 2007 does not.

  1. Visualize, explore, and communicate your systems, resources, processes, and the data behind them.
    Effectively visualize, explore, and communicate your processes, resources, systems, and the data behind them with the wide range of diagram types in Office Visio 2007. Find recently used templates and documents quickly using the new Getting Started window. Easily determine which template to use by viewing enhanced thumbnail previews. With Office Visio Professional 2007, open sample, data-connected diagrams from the new Samples category in the Getting Started window to get ideas for creating and designing your own diagrams.

  2. Be more productive by integrating diagrams with information across sources.
    Integrate data with diagrams to combine disparate sources of complex visual, textual, and numeric information. Data-connected diagrams provide visual context for data and create a complete picture of a system or process. More easily link diagrams to data from a variety of data sources by using the new Data Link functionality in Office Visio Professional 2007. Associate all the shapes in a diagram with data using the new Automatic Link Wizard.

  3. Reduce manual data reentry by letting Office Visio 2007 keep diagrams up-to-date for you.
    No need to worry about data in Visio diagrams being out of date. Using Office Visio Professional 2007, easily refresh data in diagrams by using the new Data Refresh feature, or schedule Office Visio 2007 to automatically refresh the data in the diagram at fixed intervals. Easily deal with data conflicts that may arise when data changes by using the new Refresh Conflicts task pane.

  4. Visualize and act on complex information by displaying data in diagrams.
    Visualize data in diagrams with Office Visio Professional 2007 so you can easily understand the data and effectively act on the results. Display data in any diagram as text, data bars, icons, and color-coding—all using the new Data Graphics feature in Office Visio Professional 2007.

  5. Explore data and easily track trends, identify issues, and flag exceptions with PivotDiagrams.
    Visualize and explore your business data in hierarchical form showing data groups and totals by using the new PivotDiagram template in Office Visio Professional 2007. Drill down into complex data, display data using Data Graphics, dynamically create different views of data, and better understand complex information. Insert PivotDiagrams into any Visio diagram to provide metrics and reports that help you track the progress of a process or system. Connect to a variety of data sources—including Microsoft Office SharePoint Server 2007, Microsoft Office Project 2007, and Microsoft Office Excel 2007—to generate PivotDiagrams. More effectively track and report on resources and projects managed in Office SharePoint Server 2007 and Office Project 2007 by generating visual reports from those programs in PivotDiagram form.

  6. Create diagrams faster by letting Visio connect shapes for you.
    Using new AutoConnect functionality, let Office Visio 2007 automatically connect, distribute, and align shapes in diagrams for you—all in one action. Just drag a shape onto the drawing page and position it over one of the blue arrows that appear on a shape that is already on the drawing page; Visio does the rest.

  7. Communicate complex information with new templates and shapes.
    Visually communicate in more ways with new and enhanced templates and shapes in Office Visio 2007. For example, in Office Visio Professional 2007, diagram IT service processes with the new ITIL (Information Technology Infrastructure Library) template, or create diagrams based on Lean Methodology and visualize more-efficient manufacturing processes with the new Value Stream Map template. And, more easily find information on working with new and existing Visio diagram types in the new Office Visio 2007 Help window. Use it to easily search the entire Microsoft Office Online Web site directly from within Visio for answers to your questions, tips and tricks, and more templates.

  8. Effectively convey information with professional-looking diagrams.
    Design professional-looking Visio diagrams by choosing a color or effect (text, fill, shadow, line, and connector formatting) for an entire diagram by using the new Theme feature. Choose from the built-in themes included with Visio, or create your own custom themes. Office Visio 2007 uses the same built-in themes as other 2007 Microsoft Office system programs. So, if you apply the same built-in themes in your Visio diagrams that you use in your Microsoft Office Word documents and Microsoft Office PowerPoint presentations, they all match, making it much easier to use the files with one another. Also, design more dynamic workflows with the enhanced 3-D Work Flow shapes that were designed with the new built-in Visio themes in mind.

  9. Communicate using diagrams and share them with a broad audience.
    Provide cost-effective access to valuable organizational data by making it available through secure diagrams that are easy to share using Office Visio 2007, view in Windows Internet Explorer when you have the free Visio Viewer installed, or preview in Microsoft Office Outlook 2007. Adjust security and privacy settings for all 2007 Microsoft Office system programs, including Visio, at the new Trust Center. And, for audiences who don’t have Visio or Visio Viewer, save diagrams as Web pages, JPG files, or GIF files. Even save Visio diagrams in PDF format and in the new Microsoft XPS file format to make them more portable and reach broader audiences.

  10. Customize Office Visio 2007 programmatically and create custom data-connected solutions.
    Easily extend Office Visio 2007 programmatically or by integrating it with other applications to fit your industry-specific scenarios or unique organizational requirements. Develop your own custom solutions and shapes, or use those from Visio solution providers. Visualize your custom solutions with Visio diagrams, such as data flow and Windows user interface diagrams, by using templates in the Software and Database category of Office Visio Professional 2007.
    With Office Visio Professional 2007 and the Visio Drawing Control, create custom data-connected solutions that make it easy to connect to and display data in any context. You can control several new features in Office Visio 2007 programmatically, including connecting to a data source, linking shapes to data, displaying linked data graphically, connecting shapes to one another automatically (AutoConnect), monitoring and filtering mouse-drag actions, and applying theme colors and theme effects. You can find more information on all new developer-related features in Office Visio 2007 on the Microsoft Developer Network (MSDN) and in the Visio 2007 Software Development Kit (SDK).

- Siti Suriani

Publisher 2007 Top 10 Benefits

Microsoft Office Publisher 2007, also available as part of Microsoft Office Small Business 2007 and Microsoft Office Professional 2007, makes it easy for business users to create and distribute impressive marketing materials in-house.

  1. Efficiently create high-quality publications that reflect your brand identity.
    The new Getting Started experience provides dynamic previews so you can easily create and apply your brand elements to all Office Publisher 2007 templates. First develop your brand identity using custom color schemes, font schemes, your logo, and your business information. Then apply your branding with one click by choosing from an extensive library of customizable design templates or blank publications, including newsletters, brochures, flyers, postcards, Web sites, and e-mail formats.

  2. Preview and access high-quality Microsoft Office Online templates from within Office Publisher 2007.
    Get more Office Publisher 2007 templates free from Office Online. New capabilities in Office Publisher 2007 help you easily locate, preview, open, and save Publisher templates from Office Online right within the Publisher Catalog. View Office Online templates from within Office Publisher 2007 categories, or use the new Search tool to find just the right template quickly, whether it’s located on Office Online or included in Office Publisher 2007. You can also efficiently categorize, preview, open, and save your templates within My Templates for fast retrieval.

  3. Connect with customers by personalizing your publications.
    Use enhanced Mail Merge, Catalog Merge, and new E-Mail Merge to create personalized publications for print or e-mail distribution. Merge task pane options guide you through the process of selecting lists, adding text and image fields and personalized hyperlinks, or previewing and completing your mailing. Improvements in e-mail distribution and viewing, including support for sending multipage publications as a single page message, make it easier than ever to create and send publications as e-mail messages.

  4. Convert your publications to PDF or XPS format.
    Convert your publication to Portable Document Format (PDF) or XML Paper Specification (XPS) format.1 With Office Publisher 2007 you can share and print publications in PDF and XPS without additional third-party tools. PDF settings within Office Publisher 2007 include options for creating PDF documents suitable for online viewing, desktop printing, and commercial press.

  5. Simplify the process of creating publications with Office Publisher Tasks.
    Get assistance with common Publisher procedures and simplify the process of creating and distributing publications and marketing materials using new Publisher Tasks. Publisher Tasks include tips for personalizing your publication, preparing your mailing lists, preparing publications for commercial printing, reusing content, working with images, and more.

  6. Combine lists within Office Publisher 2007 for targeted mailings.
    Using improved Mail Merge, you can create, manage, and store a single customer list in Office Publisher 2007 by combining and editing customer lists from multiple sources, including Microsoft Office Excel, Microsoft Office Outlook, Microsoft Office Outlook with Business Contact Manager, Microsoft Office Access, and more.

  7. Save time by reusing your work.
    Several new and improved features help you make the most of the time you invest in your work. Save time and effort by storing frequently used text and graphics in the new Content Library to use in other Publisher publications. Or, quickly reuse content from one publication type, such as a multipage newsletter, by placing it into an e-mail template or Web layout for online distribution. Use the improved Save as Picture feature to save publication elements for reuse in other programs. You can also insert your existing text and graphics from other programs into your Publisher publications.

  8. Build custom publications from a database.
    Use the improved Catalog Merge to automatically build a publication by merging pictures and text from a data source (such as Excel or Access). Create custom publications of varying complexity, ranging from a datasheet to a sophisticated catalog.

  9. Fine-tune your publications with powerful, intuitive design tools.
    Whether you’re starting from a template or a blank publication, you can further customize and refine your publication using the rich collection of intuitive design, layout, typography, and graphics tools available in Office Publisher 2007. You can adjust tracking and kerning, create and apply multiple master pages, adjust grids and guides, use baseline alignment, insert images from a scanner or digital camera, recolor and crop images, and more. Before printing, publishing, or distributing your publications, be sure to run the improved Design Checker to quickly identify and correct potential commercial printing, Web, or e-mail problems.

  10. Effectively manage and track your marketing campaigns.
    Improved Office Publisher 2007 integration with Office Outlook 2007 with Business Contact Manager (available in Office Small Business 2007 and Office Professional 2007) provides new tools for managing and tracking Marketing Campaigns. Create your print or e-mail collateral in Office Publisher 2007 and use Office Outlook 2007 with Business Contact Manager to easily track marketing materials you send and the responses you receive.

- Siti Suriani

Project 2007 Top 10 Benefits

Microsoft Office Project Standard 2007 gives you robust project management tools with the right blend of usability, power, and flexibility, so you can manage projects more efficiently and effectively. You can stay informed and control project work, schedules, and finances; keep project teams aligned; and be more productive through integration with familiar Microsoft Office system programs, powerful reporting, guided planning, and flexible tools.

  1. Effectively manage and understand project schedules.
    Set realistic expectations with project teams, management, and customers using Office Project Standard 2007 to build schedules, allocate resources, and manage budgets. Understand the schedule with features such as Task Drivers for tracing the source of issues, Multiple Level Undo for testing scenarios, and Visual Cell Highlighting for automatically shading the tasks affected by a change.

  2. Get productive quickly.
    The Project Guide, an interactive step-by-step planning aide, helps you quickly master the project management process. Customizable for different methodologies, this tool walks you through creating a project, assigning tasks and resources, tracking and analyzing data, and reporting results. Intuitive toolbars, menus, and other features enable you to quickly master project management fundamentals.

  3. Leverage existing data.
    Office Project Standard 2007 integrates smoothly with other Microsoft Office system programs. Build projects with a few keystrokes by converting existing task lists in Microsoft Office Excel and Microsoft Office Outlook into project plans. Resources can be added to projects from Microsoft Active Directory or from a Microsoft Exchange Server address book.

  4. Build professional charts and diagrams.
    Analyze and report Project data in professional reports and charts by using the Visual Reports engine, which generates templates for Visio diagrams and Excel charts based on Project data. You can share templates you build with other users. Or you can choose from a list of customizable, ready-to-use report templates.

  5. Effectively communicate information.
    Easily present information in various formats according to the needs of stakeholders. You can format and print one-page schedules or other reports. Use the Copy Picture to Office Wizard to smoothly export Project data into Microsoft Office Word for formal documents, Office Excel 2007 for custom charts or spreadsheets, or Microsoft Office PowerPoint for crisp presentations.

  6. Gain greater control of resources and finances.
    With Office Project Standard 2007, you can easily assign resources to tasks and adjust their assignments to resolve conflicts over allocations. Control finances by assigning budgets to projects and programs. Improve your cost estimates with Cost Resources.

  7. Quickly access the information you need.
    You can group Project data by any predefined or custom field. This saves you time by consolidating data so you can quickly locate and analyze specific information. Easily identify changes between different versions of a project—thus, efficiently tracking scope and schedule changes.

  8. Track projects according to your needs.
    A rich set of predefined or custom metrics helps you track data (percent complete, budget versus actual, earned value, and the like) relevant to your needs. You can track project performance over the project lifespan by saving project snapshots in up to 11 baselines.

  9. Customize Office Project 2007 to your needs.
    Tailor Office Project Standard 2007 specifically to your project. Choose custom display fields that integrate with your project schedule. Modify toolbars, formulas, graphical indicators, and reports. XML, Microsoft Visual Basic for Applications (VBA), and Component Object Model (COM) add-ins facilitate data sharing and creation of custom solutions.

  10. Get Office Project 2007 assistance when you need it.
    Office Project Standard 2007 provides a wealth of assistance to novice and experienced users. It includes a robust Help search engine, smart tags, and wizards.

- Siti Suriani

OneNote 2007 Top 10 Benefits

Microsoft Office OneNote 2007 is a digital notebook that provides a flexible way to gather notes and information, powerful search capabilities so users can find what they are looking for quickly, and easy-to-use shared notebooks that help teams work together more effectively.

  1. Gather your notes and information in one place.
    Gather, store, and manage your notes and information — including text, pictures, digital handwriting, audio and video recordings, and more — in a single location. Having all your important information at your fingertips can help you make more informed decisions and be better prepared.

  2. Back up your valuable information.
    Office OneNote 2007 automatically saves and backs up your notebooks, whether stored locally or on a network file share, so you’re less vulnerable to data loss.

  3. Find information more quickly.
    Powerful search technology with optical character recognition helps you find what you’re looking for more quickly — whether you’re searching handwritten notes, text in pictures, or spoken words in audio and video recordings. You can configure Microsoft Office SharePoint Portal Server 2003 or Microsoft Office SharePoint Server 2007 to index Office OneNote 2007 files automatically to incorporate the data into your company’s knowledge base.

  4. Work together more effectively.
    Shared notebooks give everyone access to the same information at the same time, online or offline. Office OneNote 2007 manages changes for you so that multiple users can work simultaneously in the same notebook—there’s no need to keep track of versions and changes. With Live Sharing Sessions, geographically dispersed teams can view and edit the same page of notes at the same time.

  5. Avoid duplicate work.
    Office OneNote 2007 makes it easy to collect, store, and search information about projects in a central location. Capitalize on ideas, notes, and best practices when briefing new project teams or team members. Take advantage of OneNote archives to avoid duplicate work.

  6. Organize your way.
    Organize information in the way that works best for you. See all your open notebooks in a single view, and easily arrange and rearrange your notes with drag-and-drop functionality. You can add hyperlinks to other pages in your notebook so you can quickly find content relevant to the task at hand.

  7. Prioritize and manage tasks and your to-do list more efficiently.
    Use note tags to mark and easily track actions and important items. Note tags can be customized according to your needs and quickly viewed in a summary pane. Tasks created in Office OneNote 2007 synchronize with Microsoft Office Outlook tasks so you can manage your projects more efficiently.

  8. Make meetings more productive.
    Office OneNote 2007 gives you the flexibility to capture all of the information presented in meetings, including status updates, presentations, documents, typed and handwritten notes, and more. With all meeting notes stored in one location, everyone has access to the same information, helping ensure that all team members are on the same page and that everyone walks away with a consistent set of action items.

  9. Get up to speed quickly.
    The familiar look and feel of other Microsoft Office system programs and an intuitive user interface make it easy to get started using Office OneNote 2007 right away. Integration with the 2007 Microsoft Office system means you can share information between Office OneNote 2007 and other Microsoft Office system programs easily.

  10. Improve productivity away from the office.
    Synchronize your Microsoft Windows Mobile–powered devices with Office OneNote 2007 so you can take contents of your notebook with you and view them on your mobile device. In addition, information you capture on your Smartphone or Windows Mobile–based Pocket PC, including photos and text, can be transferred to Office OneNote 2007 and made text-searchable.

- Siti Suriani

InfoPath 2007 Top 10 Benefits

With Microsoft Office InfoPath 2007, you can create rich, dynamic forms that teams and organizations can use to gather, share, reuse, and manage information — improving collaboration and decision-making throughout your organization. Office InfoPath 2007 can help you gather information more effectively.

  1. Deploy InfoPath forms as Microsoft Office Outlook e-mail messages.
    With Office InfoPath 2007, you can deploy forms as Outlook e-mail messages, so colleagues can complete forms without leaving the familiar Outlook environment. After you’ve collected the information in Office Outlook 2007, you can export it to a Microsoft Office Excel spreadsheet or merge the data back to a single InfoPath form.

  2. Extend business processes beyond the firewall.
    Office InfoPath 2007 and InfoPath Forms Services make it easy to extend forms solutions beyond your firewall because you can complete forms using many different Web browsers and mobile devices.

  3. Easily convert Microsoft Office Word documents and Excel spreadsheets to InfoPath forms.
    By converting Word documents and Excel spreadsheets to InfoPath form templates, you can build data integrity, improve version control, and add structure to information gathering by converting legacy documents to rich InfoPath form templates.

  4. Make complex form design easier.
    Office InfoPath 2007 helps people build forms with a simple drag-and-drop interface and provides support for prebuilt template parts and shared data connections.

  5. Create PDF or XPS records of your form data.
    With the addition of a free plug-in, you can create a Portable Document Format file (PDF) or XML Paper Specification (XPS) version of your completed InfoPath form for archival and records management.

  6. Master your forms workflow using Office InfoPath 2007 and Microsoft Office SharePoint Server 2007.
    Use the integrated workflow management tools in Office SharePoint Server 2007 to drive information-gathering processes efficiently.

  7. Design a single form for Web browsers and Office InfoPath 2007 clients.
    Office InfoPath 2007 includes a design checker to help ensure consistency for forms deployed to InfoPath Forms Services.

  8. Enhance protection of important information in InfoPath form templates.
    Office InfoPath 2007 includes support for information rights management to help protect forms from inappropriate usage and distribution.

  9. Centralize forms management for the entire organization.
    InfoPath Forms Services of Office SharePoint Server 2007 enables organizations to centrally manage electronic forms by providing access to only those users who have a secure connection.

  10. Develop advanced forms solutions with Office InfoPath 2007 and Microsoft Visual Studio 2005.
    Build InfoPath forms solutions by creating InfoPath projects hosted within Visual Studio 2005, so developers can build solutions using managed code and the Microsoft .NET Framework.

- Siti Suriani

Groove 2007 Top 10 Benefits

Microsoft Office Groove 2007 is a collaboration software program for working on a broad range of project activities, from simple document collaboration to custom solutions integrated with business processes.

  1. Bring the team, tools, and information together in one place.
    Teams often lack context when working on a project because not everyone is in the same place and connected to the same information and systems. Groove workspaces add context by putting all people, tools, and data in one place — the workspace — that's accessible to all team members right on their computers.

  2. Customize each workspace for the team's unique needs.
    With Office Groove 2007, you and your team decide what tools you need to get the job done. Choose from more than ten basic tools, such as Files, Discussion, and Calendar, as well as several prebuilt workspace templates. Or design your own custom tools with Groove Forms and Groove InfoPath Forms.

  3. Collaborate with colleagues, partners, and customers — with one product.
    No more switching tools when you need to work with people outside your organization. With Office Groove 2007, it's as easy to invite a customer or partner to a workspace as it is a coworker.

  4. Stay productive anywhere, online or offline.
    Office Groove 2007 stores all your workspaces, tools, and data right on your computer — there's no need to connect to the corporate network to access or update information. You stay productive whether you're working in the office, at a customer site, on the road, or from home.

  5. Stay in sync, automatically and efficiently.
    Groove automatically sends the changes you make in a workspace to your team members' computers. And your team members' changes are sent to you each time you log onto Office Groove 2007 while connected to the Internet. No more attaching, detaching, uploading, or downloading.

  6. See who's working on what, when.
    With built-in presence awareness, alerts, and unread marks, you know who's working on what, when, without having to ask. You and your team spend less time coordinating and more time working.

  7. Synchronize SharePoint document libraries with Office Groove 2007.
    With the new built-in SharePoint Files tool, you can easily check out documents from Microsoft Office SharePoint Server 2007 or a Windows SharePoint Services 3.0 team site into an Groove workspace, collaborate on them, and push them back when you're done — all with just a few mouse clicks.

  8. Create a form with Microsoft Office InfoPath 2007; share it with Office Groove 2007.
    With the new built-in InfoPath Forms Tool, you can import forms solutions created in Office InfoPath 2007. Why? So you and your team can collect and track fielded data, such as status reports and questionnaires, right inside your project workspaces.

  9. Make the most of impromptu encounters with Microsoft Office Communicator integration.
    With new integration with the 2005 and 2007 versions of Office Communicator, Office Groove 2007 helps you engage your teammates at just the right time, wherever they are. See the presence information for your Communicator contacts and start communicating with them right from Office Groove 2007.

  10. Work with international teams in their own languages.
    With support for 28 languages, your global team members can now experience the power of Office Groove 2007 in their native languages.

- Siti Suriani

PowerPoint 2007 Top 10 Benefits

Microsoft Office PowerPoint 2007 enables users to quickly create high-impact, dynamic presentations while integrating security-enhanced workflow and ways to easily share this information.

  1. Get better results faster with the Microsoft Office Fluent user interface.
    The redesigned look and feel of the Office Fluent user interface makes creating, presenting, and sharing presentations an easier and more intuitive experience. Rich features and capabilities are presented in a streamlined, uncluttered workspace that minimizes distraction and enables people to achieve the results they want more quickly and easily.

  2. Create powerful, dynamic SmartArt diagrams.
    Easily create high-impact and dynamic workflow, relationship, or hierarchy diagrams from within Office PowerPoint 2007. You can even convert a bulleted list into a SmartArt diagram, or modify and update existing diagrams. It’s easy for users to take advantage of rich formatting options with new contextual diagramming menus.

  3. Easily reuse content with Office PowerPoint 2007 Slide Libraries.
    Wish there was a better way to reuse content from one presentation to another? With PowerPoint Slide Libraries, you can store presentations as individual slides on a site supported by Microsoft Office SharePoint Server 2007 and easily repurpose the content later within Office PowerPoint 2007. Not only does this cut down the time you spend creating presentations, but any slides you insert can remain synchronized with the server version, so your content is always up to date.

  4. Communicate with users across platforms and devices.
    Help ensure broad communication with your PowerPoint presentations by converting your files to XPS and PDF files for sharing with users on any platform.

  5. Use custom layouts to assemble presentations more quickly.
    In Office PowerPoint 2007, you can define and save your own custom slide layouts so you no longer have to waste valuable time cutting and pasting your layouts onto new slides or deleting content on a slide with your desired layout. With PowerPoint Slide Libraries, it is easy to share these custom slides with others so that your presentations have a consistent and professional look and feel.

  6. Accelerate your review processes using Office PowerPoint 2007 and Office SharePoint Server 2007.
    With built-in workflow capabilities in Office SharePoint Server 2007, you can initiate, manage, and track review and approval processes from within Office PowerPoint 2007, enabling people to accelerate presentation review cycles across the organization without requiring them to learn new tools.

  7. Uniformly format your presentations with Document Themes.
    Document Themes enable you to change the look and feel of your entire presentation with just one click. Changing the theme of your presentation not only changes the background color, but also the colors, styles, and fonts of the diagrams, tables, charts, shapes, and text within your presentation. By applying a theme, you can be confident that your entire presentation has a professional and consistent look and feel.

  8. Dramatically modify shapes, text, and graphics with new SmartArt graphics tools and effects.
    You can manipulate and work with your text, tables, charts, and other presentation elements in richer ways than ever before. Office PowerPoint 2007 makes these tools readily available through the streamlined user interface and contextual menus, so that in just a few clicks, your work can have greater impact.

  9. Add more security to your PowerPoint presentations.
    You can now add a digital signature to your PowerPoint presentations to help ensure their contents are not changed after they leave your hands, or you can mark a presentation as “final” to prevent inadvertent changes. Using content controls, you can create and deploy structured PowerPoint templates that guide users into entering the correct information, while helping to protect and preserve the information in the presentation that shouldn’t be changed.

  10. Reduce your document sizes and improve file recovery at the same time.
    The new, compressed Microsoft Office PowerPoint XML Format offers a dramatic reduction in file size while also offering an improvement in data recovery for damaged files. This new format provides a tremendous savings to storage and bandwidth requirements and reduces the burden on IT costs.

- Siti Suriani

Access 2007 Top 10 Benefits

Microsoft Office Access 2007 helps information workers quickly track and report information with ease thanks to the Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge. Users can share information over the Web on Microsoft Office SharePoint Server 2007 lists where it can be audited and backed up.

  1. Get better results faster with the Office Fluent user interface.
    Office Access 2007 provides a completely new experience with the Office Fluent user interface, new navigation pane, and tabbed window views. Even with no database experience, any user can start tracking information and creating reports to make more informed decisions.

  2. Get started quickly using prebuilt solutions.
    With a rich library of prebuilt solutions, you can start tracking your information immediately. Forms and reports are already built for your convenience, but you can easily customize them to meet your business needs. Contacts, issue tracking, project tracking, and asset tracking are only few of the out-of-the-box solutions included in Office Access 2007.

  3. Create multiple reports with different views of the same information.
    Creating a report in Office Access 2007 is truly a “what you see is what you get” (WYSIWYG) experience. You can modify a report with real-time visual feedback and save various views for different audiences. The new grouping pane and filtering and sorting capabilities help you display the information so you can make more informed business decisions. .

  4. Create tables quickly without worrying about database complexity.
    With automatic data type detection, table creation in Office Access 2007 is as easy as working with a Microsoft Office Excel table. Type your information and Office Access 2007 will recognize whether it is a date, currency, or another common data type. You can even paste an entire Excel table into Office Access 2007 to begin tracking the information with the power of a database.

  5. Enjoy new field types for even richer scenarios.
    Office Access 2007 enables new field types such as attachments and multivalue fields. You can now attach any document, image, or spreadsheet to any record in your application. With the multivalue field, you can now select more than one value (for example, assign a task to more than one person) in each cell.

  6. Collect and update your information directly from the source.
    With Office Access 2007, you can create forms using Microsoft Office InfoPath 2007 or HTML to gather information for your database. You can then send this form to your teammates via e-mail and use their responses to populate and update your Access table to eliminate the need to retype any information.

  7. Share your information with Microsoft Windows SharePoint Services.
    Share your Access information with the rest of your team using Windows SharePoint Services and Office Access 2007. With the power of both applications, your teammates can access and edit the data and view real-time reports directly through a Web interface.

  8. Track Windows SharePoint Services lists with the rich client capabilities of Office Access 2007.
    Use Office Access 2007 as your rich client interface to analyze and create reports from Windows SharePoint Services lists. You can even take the list offline, and then synchronize any changes when you reconnect to the network, making it easy for you to work with your data at any time.

  9. Move data to Windows SharePoint Services for better manageability.
    Make your data more transparent by moving it to Windows SharePoint Services. This way, you can routinely back up the data on the server, recover deleted data from the recycle bin, track revision history, and set access permissions, so you can better manage your information.

  10. Access and use information from multiple sources.
    With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information.

- Siti Suriani

Excel 2007 Top 10 Benefits

Microsoft Office Excel 2007 is a powerful and widely used tool that helps people analyze information to make more informed decisions. Using Office Excel 2007 and Excel Services, you can share and manage your analysis and insight with coworkers, customers, and partners with greater confidence.

  1. Office Excel 2007 features the Microsoft Office Fluent user interface to help you find powerful tools when you need them.
    Find the tools you want when you need them using the results-oriented Office Fluent user interface in Office Excel 2007. Based on the job you need to accomplish, whether it’s creating a table or writing a formula, Office Excel 2007 presents the appropriate commands when you need them.

  2. Import, organize, and explore massive data sets within significantly expanded spreadsheets.
    Work with massive amounts of data in Office Excel 2007, which supports spreadsheets that can be up to 1 million rows by 16,000 columns. In addition to the bigger grid, Office Excel 2007 supports multicore processor platforms for faster calculation of formula-intense spreadsheets.

  3. Use the completely redesigned charting engine in Office Excel 2007 to communicate your analysis in professional-looking charts.
    Build professional-looking charts faster with fewer clicks using charting tools in the Office Fluent user interface. Apply rich visual enhancements to your charts such as 3-D effects, soft shadowing, and transparency. Create and interact with charts the same way, regardless of the application you are using, because the charting engine in Office Excel 2007 is consistent in Microsoft Office Word 2007 and Microsoft Office PowerPoint 2007.

  4. Enjoy improved and powerful support for working with tables.
    Create, format, expand, filter, and refer to tables within formulas because Office Excel 2007 has greatly improved support for tables. When you’re viewing data contained in a large table, Office Excel 2007 keeps table headings in view while you scroll.

  5. Create and work with interactive PivotTable views with ease.
    PivotTable views enable you to quickly reorient your data to help you answer multiple questions. Find the answers you need faster and create and use PivotTable views more easily by dragging fields where you want them to be displayed.

  6. “See” important trends and find exceptions in your data.
    Apply conditional formatting to your information more easily to discover patterns and highlight trends in your data. New schemes include color gradients, heat maps, data bars, and performance indicator icons.

  7. Use Office Excel 2007 and Excel Services to help share spreadsheets more securely with others.
    Excel Services, a feature of Microsoft Office SharePoint Server 2007, dynamically renders a spreadsheet as HTML so others can access the information using a Web browser. Because of the high degree of fidelity with the Office Excel 2007 client, Excel Services users can navigate, sort, filter, input parameters, and interact with the information, all within their Web browser.

  8. Help ensure you and your organization work with the most current business information.
    Prevent the spread of multiple or outdated copies of a spreadsheet throughout your organization by using Office Excel 2007 and Office SharePoint Server 2007. Control which users can view and modify spreadsheets on the server using permission-based access.

  9. Reduce the size of spreadsheets and improve damaged file recovery at the same time.
    The new, compressed Microsoft Office Excel XML Format offers a dramatic reduction in file size, while its architecture offers an improvement in data recovery for damaged files. This new format provides a tremendous savings to storage and bandwidth requirements, and reduces the burden on IT personnel.

  10. Extend your business intelligence investments because Office Excel 2007 provides full support for Microsoft SQL Server 2005 Analysis Services.
    Take advantage of the flexibility and the new cube functions in Office Excel 2007 to build a custom report from an OLAP database. You can also connect to external sources of data more easily using the Data Connection Library.

- Siti Suriani

Word 2007 Top 10 Benefits

Microsoft Office Word 2007 helps people create and share professional-looking content by combining a comprehensive set of writing tools with the easy-to-use Microsoft Office Fluent user interface.

  1. Spend more time writing and less time formatting.
    The Office Fluent user interface presents the right tools when you need them, making it easy to format your documents quickly. Now you can find the right features in Office Word 2007 to make your documents communicate more effectively. Using Quick Styles and Document Themes, you can quickly change the appearance of text, tables, and graphics throughout the entire document to match your preferred style or color scheme.

  2. Communicate more effectively with SmartArt diagrams and new charting tools.
    New SmartArt diagrams and a new charting engine help you create great-looking content with 3-D shapes, transparency, drop shadows, and other effects.

  3. Quickly assemble documents using Building Blocks.
    Building Blocks in Office Word 2007 can be used to assemble documents from frequently used or predefined content such as disclaimer text, pull quotes, sidebars, cover pages, and other types of content. This will help ensure you don't spend needless time recreating content or copying and pasting between documents; it also helps ensure consistency across all of the documents created within your organization.

  4. Save as PDF or XPS directly from Office Word 2007.
    Office Word 2007 offers you a choice for sharing documents with other people. You can convert your Word documents to Portable Document Format (PDF) or XML Paper Specification (XPS) format without the addition of third-party tools to help ensure broad communication with users on any platform.

  5. Publish and maintain blogs directly from Office Word 2007.
    You can now publish blogs directly from Office Word 2007. You can configure Office Word 2007 to link directly to your blog site, and use the rich Word experience to create blogs with images, tables, and advanced text formatting features.

  6. Master your document review processes using Office Word 2007 and Microsoft Office SharePoint Server 2007.
    With built-in workflow services in Office SharePoint Server 2007, you can initiate and track document review and approval processes from within Office Word 2007 to help accelerate review cycles across your organization without forcing people to learn new tools.

  7. Connect your documents to business information.
    Create dynamic Smart Documents that update themselves by connecting to your back-end systems using new document controls and data bindings. By using the new XML integration capability, organizations can deploy intelligent templates to assist people in creating highly structured documents.

  8. Remove tracked changes, comments, and hidden text from your documents.
    Detect and remove unwanted comments, hidden text, or personally identifiable information using the Document Inspector to help ensure that sensitive information doesn't escape when your documents are published.

  9. Use the tri-pane review panel to compare and combine documents.
    Office Word 2007 makes it easy to find out what changes were made to a document. A new tri-pane review panel helps you see both versions of a document with deleted, inserted, and moved text clearly marked.

  10. Reduce your file sizes and improve corrupt file recovery.
    The new Ecma Office Open XML Formats offer a dramatic reduction in file size as well as improvement in recovery for damaged files. These new formats provide a tremendous savings to storage and bandwidth requirements, and reduce the burden on IT personnel.

- Siti Suriani

Outlook 2007 Top 10 Benefits

Office Outlook 2007 helps users better manage their time and information, connect across boundaries, and help remain safe and in control.
  1. Instantly search all your information.
    Having problems finding the information you need? Use Office Outlook 2007 to search for keywords, dates, or other flexible criteria to locate items in your e-mail, calendar, contacts, or tasks to save valuable time. Instant Search in Office Outlook 2007 is fully integrated within the interface so you never have to leave Outlook to find the information you need.

  2. Easily manage your daily priorities and information.
    Check your priorities for the day by looking at the To-Do Bar where your flagged mails and tasks are clearly laid out. The To-Do Bar also connects tasks you may have stored in other Microsoft Office programs like Project, OneNote, and Microsoft Windows SharePoint Services technology. Finally, the integration of the To-Do Bar items on the calendar helps you easily schedule and block off time to follow up on items.

  3. Get better results faster with the Microsoft Office Fluent user interface.
    Office Outlook 2007 has redesigned the look and feel of the messaging interface to make composing, formatting, and acting upon information an easier and more intuitive experience. You now have all of the rich features and capabilities of Outlook in an accessible and streamlined location, making it simple to navigate your options.

  4. Connect with people easily and effectively.
    New Office Outlook 2007 calendaring functionalities provide easy ways to share your calendar with anyone within or outside of your organization, giving your important contacts immediate access to your information. You can create and publish Internet calendars to Microsoft Office Online, add and share Internet calendar subscriptions, e-mail calendar snapshots, or even send a customized electronic business card to one of your clients, making it easy to communicate with anyone.

  5. Increased collaboration and functionality with Microsoft Exchange Server 2007.
    Office Outlook 2007, used in conjunction with Exchange Server 2007, offers a rich and complete Outlook experience. Users benefit from a new scheduling assistant that automates time-consuming calendaring tasks, the ability to schedule and customize out-of-office communications, and managed folders that facilitate compliance needs. Office Outlook 2007 and Exchange Server 2007 also combine to deliver a new level of secure collaboration, offering multiple messaging approaches with enhanced security that are easy to use and reassure users they can be confident in the security of their messages.

  6. Manage your shared information and content in one interface.
    Office Outlook 2007 provides you a rich interaction with information stored in Windows SharePoint Services technology at any time. You can connect Windows SharePoint Services documents, calendars, contacts, tasks, and other information to Office Outlook 2007, giving you a central place to manage your information. Additionally, you have full editing capabilities, so that any changes you make to this information stored in Office Outlook 2007 will be reflected on the server version.

  7. Enjoy new measures that help keep you safe from junk e-mail and malicious sites.
    Office Outlook 2007 has taken new measures to help keep you safe from junk mail and "phishing" Web sites. To help protect you from divulging personal information to a threatening Web site, Office Outlook 2007 has an improved junk e-mail filter and has added new features that disable links and warn you about threatening content within an e-mail message.

  8. Send text messages from Office Outlook with one easy click.
    Outlook Mobile Service is a feature of Outlook that enables you to send and receive text and picture messages between Office Outlook 2007 and any mobile phone. Outlook Mobile Service also enables you to forward Outlook e-mail, contacts, appointments, and tasks to yourself or other people as text messages. You can even set Office Outlook 2007 to automatically send e-mail, reminders, and your daily calendar as text messages right to your mobile phone.

  9. Organize your information in new, rich ways.
    Using Color Categories in Office Outlook 2007, you can easily personalize and add categories to any type of information — e-mail, calendar items, contacts, or tasks. Color Categories give you a simple, visual way to distinguish items from one another, so it’s easy to organize your data and search for information.

  10. Manage all your communication in one interface.
    With Office Outlook 2007, you can now read and manage your Really Simple Syndication (RSS) feeds and blogs right from within Office Outlook 2007, the most natural place to manage this information. Using the integrated support for RSS feeds in Office Outlook 2007, you no longer have to leave Outlook to read the latest world news, catch up on your favorite sports team, or remain up to date on interesting blogs. It's easy to get started adding these subscriptions using the built-in home page in Office Outlook 2007 provided by Office Online.

- Siti Suriani

Wednesday, August 5, 2009

Outlook Tips - View Your Webmail from Your MS Outlook

Big organisations mostly offers access to thier emails for their personnels via webmails. For these users, all they need is a computer with internet access and of course an internet browser.
For Microsoft Outlook users... you can actually access your webmail without using any internet browser.
Here's how to do it...
Step 1: Create a folder under your account.
  1. From the Standard Toolbar, click the New pull-down button and select Folder... .

  2. Type a name in the field under Name: and make sure you select the root of your email account for the Select where to place the folder: list.

Step 2: Convert the folder to view your webmail.

  1. Right-click on folder you've just created and select Properties.

  2. On the folder's properties dialog box (mine is showing "Webmail Properties" as I've named my folder as "Webmail"), go to Homepage tab.
  3. Type the website address you usually use in your internet browser, starting with http:// in the Address: field.

  4. Click to enable the checkbox for Show home page by default for this folder.
  5. Click OK.

Now you can access your webmail from Outlook just by selecting the folder you've created and then login to your webmail account but make sure you are currently online to view it, just like you would do when viewing with the internet browser.

You can actually use this method to view any website you want like I do to view my training schedule.


Tuesday, August 4, 2009

Outlook Tips - Make Your Outlook Check or Send for New Emails More Frequently

By default, your Microsoft Outlook will check for new emails or send any emails in your outbox every 30 minutes. There might be a very important email coming in and need your action, I would say immediately but since new emails will only come in every 30 minutes, it might be too late for you to react on the email received.

You can actually change the setting to read new emails from as frequent as every 1 minute to maximum of every 120 minutes.
  1. Go to Tools menu, select Option....
  2. On the Options dialog box, go to Mail Setup tab and click Send/Recieve... button.

  3. On the Send/Recieve Groups dialog box, change the value (default is 30) for Schedule an automatic send/receive every ... minutes field under Setting for group "All Accounts" (or any other account you may have in your Group Name field.

  4. Once done, click Close and then click OK to close the Options dialog box.

Don't set it to 1 minute of your internet connection speed is poor. Maybe you can reduce it to 5 minutes.

By doing this simple setting, it could help you to save your career... ;)


Friday, July 31, 2009

Office Day @ Angkasapuri, Kuala Lumpur

I was given the opportunity to do a presentation on New Features of Microsoft Office 2007 for more than 300 audients from different government agencies under Ministry of Information, Communication and Culture. Started with Microsoft Office PowerPoint 2007, follow by Microsoft Office Outlook 2007 and Microsoft Office Visio 2007 and finally end with Microsoft Office Excel 2007.

- Siti Suriani

Thursday, July 30, 2009

Word Tips – Easiest Option to format a report using MS Word 2007

Normally user will spend more time to do formatting rather than focusing on the content. Here is how you can do it even faster….

Below is the sample report before formatting:-

Make sure the entire report is finalized already.

  1. Click anywhere within the report.
  2. From the Home tab, under Styles group, click on the Change Styles drop down arrow button – change the set of styles, colors and fonts (apply for the entire document).
  3. Point to Style Set and move over to see the live preview of each style from the drop down list.

Style Set Samples:-

  1. Distinctive

  2. Elegant

  3. Fancy

  4. Formal

  5. Manuscript

  6. Modern

  7. Simple

  8. Traditional

- Siti Suriani

Monday, July 27, 2009

Excel Tips - Getting List from Other Spreadsheet for Display with Data Validation List

You can create your own pull-down list or combo box by using the data validation feature in Excel but the main problem is the list has to be in the same spreadsheet as the combo box that you want to use. What most of us will do is just create a list somewhere else in the same spreadsheet and then hide it either by hiding the columns or rows of the list or change the font colour to white so it is invisible.
You can actually make use of the range name for the list that is in other sheet tabs and there is no need to copy it to the spreadsheet that you want to put the combo box.
Here's how...
  1. Select the list that you want to use (it could also be from the table array you use for VLookup or HLookup. If it is, just select the list excluding the header which is the column one for VLookup table array or row one for HLookup table array). It is best if you can first sort your list in ascending order because the list taken in data validation will follow your actual list without sorting them for you.
  2. With the list selected, click in the name box located to the left of the formula bar and type a name (the name has to be unique and shouldn't be separated if it consists of more than one word) and then press Enter.

  3. Return to the other spreadsheet and select the cell(s) you want to create combo box.
  4. With the cell(s) selected, go to Data tab and select Data Validation from Data Tools group (for Excel 2003 or earlier, go to Data menu and select Validation...).

  5. On the Data Validation dialog box, go to Settings tab.
  6. Select List from Allow combo box.

  7. Type the name you have given for the list in step 2, starting with the equal sign (=) in the Source field (I used FruitList for my example).

  8. Click OK or you can continue setting the Input Message and/or Error Alert tab if you want to.

You can combine the usage of this combo box with any lookup function or use it alone.


Tuesday, July 21, 2009

Excel Tips - Hide Formula from Being Displayed in the Formula Bar

You may want to hide the formula that you are using in your Excel from being seen by other viewers who are using your spreadsheet.
To hide the formula, you will have to protect your worksheet but before protecting, you'll have to set the cell's format.
  1. Select the cell(s) with the formula(s) you want to hide.
  2. From Home tab, click Format from Cells group and select Format Cells (for earlier Excel versions, go to Format menu and select Cells).

  3. From the Format Cells dialog box, go to the Protection tab.
  4. Select the Hidden check box (leave the Locked check box selected to protect from user changing or deleting the cell content).

  5. Click OK.

(If you want to allow entering or editing data on certain cells, select those cells and follow step 2 and 3. Then uncheck the Locked check box and click OK.)

Now you can protect your worksheet.

  1. From Home tab, click Format from Cells group and select Protect Sheet... or you can also find Protect Sheet button in the Changes group from Review tab (for earlier versions, go to Tools menu, point at Protection and select Protect Sheet...).
  2. Apply your password to protect (optional) and repeat the same password after clicking OK.

REMINDER! Password is case sensitive. To unprotect, you must type the password exactly like the one you've created. If you forgot the password then you can say good bye to your worksheet :).


Excel Tips – Protect Certain Part of Spreadsheet from Changes

Sometimes we want to block users from making any changes to our important data area but elsewhere within the same worksheet they can make any changes they wish for. By default when we set the protect worksheet, the entire worksheet is being protected. How do we actually make the setting, so that only selected area within the same worksheet cannot be modified?

  1. Click on the top left of the worksheet or press Ctrl+A to Select All

  2. Press Ctrl+1 to open up the Format Cells dialog box
  3. Click on the Protection tab
  4. Clear the Locked check box
  5. Click OK

  6. Highlight the area in the data area.

  7. Open the Format Cells dialog box again
  8. This time around, check the Locked check box
  9. Click OK

  10. Next step is to protect the worksheet
  11. Click on the Review tab, Changes group, Protect Sheet command button (for MS Excel 2003 – Click on the Tools menu, Protection, Protect Sheet)

  12. Type a password to unprotect sheet
  13. Reenter the password

  14. Try to make changes on the selected data area
  15. The message box below will come out

Now all is being set, users are not allowed to make any changes on the selected data area.

- Siti Suriani