tag:blogger.com,1999:blog-20268719392461940762024-03-17T20:03:41.325-07:00Microsoft Office Tips & TricksMS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-2026871939246194076.post-51678941642770942822009-09-04T07:38:00.000-07:002009-09-04T09:18:16.917-07:00Outlook Tips - Create Email Template<div align="justify"><span style="font-family:arial;">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. </span></div><div align="justify"><span style="font-family:arial;"><br /> </div></span><div align="justify"><span style="font-family:arial;"></div></span><div align="justify"><span style="font-family:arial;">If that's the case, try saving the email message as a template and later you can reuse it.</span></div><ol><li><div align="justify"><span style="font-family:arial;">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 <strong>To</strong>, <strong>CC</strong> or <strong>BCC </strong>field.</span></div></li><li><div align="justify"><span style="font-family:arial;">Once complete, click the <strong>Office Button</strong> and select <strong>Save As</strong>.<br /><br /><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SqE6J_dGuyI/AAAAAAAAAJs/sRQtkpd9cac/s1600-h/1.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 162px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377643373383826210" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SqE6J_dGuyI/AAAAAAAAAJs/sRQtkpd9cac/s320/1.jpg" /></span></a><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">In the <strong>Save As</strong> dialog box, change the <strong>Save as type:</strong> to <strong>Outlook Template</strong>.</span></div></li><li><div align="justify"><span style="font-family:arial;">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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">For earlier version users, you must first disable the <strong>Use Microsoft Office Word 2003 to edit e-mail messages</strong> feature found in <strong>Tools</strong> > <strong>Options</strong> menu under the <strong>Mail Format</strong> tab of the <strong>Options</strong> dialog box.</span></p><p align="justify"><span style="font-family:arial;">Follow the steps 2 to 4 as stated above (slight difference in step 2 where you should click <strong>File</strong> menu instead of <strong>Office Button</strong>).</span></p><p align="justify"><span style="font-family:arial;">To use the template (same process for Outlook 2007 or earlier):</span></p><ol><li><div align="justify"><span style="font-family:arial;">From <strong>Tools</strong> menu, go to <strong>Forms</strong> and select <strong>Choose Form...</strong> .<a href="http://2.bp.blogspot.com/_lX611N_RlBg/SqE6KVG1KzI/AAAAAAAAAJ0/Qd6Z0H11Ifo/s1600-h/2.jpg"><span style="font-family:arial;"><br /><br /><img style="WIDTH: 320px; HEIGHT: 310px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377643379195980594" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SqE6KVG1KzI/AAAAAAAAAJ0/Qd6Z0H11Ifo/s320/2.jpg" /></span></a><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">In the <strong>Choose Form</strong> dialog box, select <strong>User Templates in File System</strong> from <strong>Look In:</strong> combo box.<br /><br /><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SqE6K7zwbBI/AAAAAAAAAJ8/totKCXm3-x8/s1600-h/3.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 143px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377643389584960530" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SqE6K7zwbBI/AAAAAAAAAJ8/totKCXm3-x8/s320/3.jpg" /></span></a><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">Select the template listed or click the <strong>Browse</strong> button if the template is in other location.</span></div></li><li><div align="justify"><span style="font-family:arial;">Click <strong>Open</strong>.</span></div></li></ol><p align="justify"><span style="font-family:arial;">Now you can continue to add attachment(s) or amend the template as required.</span></p><p align="justify"><strong><span style="font-family:arial;">- MRBAR</span></strong></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-5280822964239397662009-08-24T01:07:00.000-07:002009-08-24T06:55:54.685-07:00PowerPoint Tips - Create Your Own Shape<div align="justify"><span style="font-family:arial;">Lets create our own shapes by changing standard shape with PowerPoint 2007.</span><br /><ol><li><span style="font-family:arial;">Select a shape and place it on your slide (I selected an oval). Resize it as you want.</span></li><li><span style="font-family:arial;">With the shape selected, go to <strong>Drawing Tools</strong> ribbon, <strong>Format</strong> tab.</span></li><li><span style="font-family:arial;">Click <strong>Edit Shape</strong> from <strong>Insert Shapes</strong> group and select <strong>Convert to Freeform</strong>.</span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SpKYBb-HfqI/AAAAAAAAAJM/ITM2Yr8_Mo0/s1600-h/1.jpg"><br /><br /><span style="font-family:arial;"><img style="WIDTH: 318px; HEIGHT: 138px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373524455862009506" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SpKYBb-HfqI/AAAAAAAAAJM/ITM2Yr8_Mo0/s320/1.jpg" /></span></a><br /><br /></li><li><span style="font-family:arial;">Repeat step 3 but this time select <strong>Edit Points</strong>. You will see the shape will have multiple points for you to adjust.<br /><br /></span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SpKYBgie4-I/AAAAAAAAAJU/f0PpdBNY5Is/s1600-h/2.jpg"><span style="font-family:arial;"><img style="WIDTH: 174px; HEIGHT: 129px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373524457088279522" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SpKYBgie4-I/AAAAAAAAAJU/f0PpdBNY5Is/s320/2.jpg" /></span></a><span style="font-family:arial;"> </span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SpKYB4pxjWI/AAAAAAAAAJc/b6h9hd3VAU4/s1600-h/3.jpg"><span style="font-family:arial;"><img style="WIDTH: 290px; HEIGHT: 186px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373524463561313634" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SpKYB4pxjWI/AAAAAAAAAJc/b6h9hd3VAU4/s320/3.jpg" /></span></a><br /><br /></li><li><span style="font-family:arial;">Now you can drag any edge of your shape to form a new shape of your own.<br /><br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SpKYCdoSBNI/AAAAAAAAAJk/eHR1Z_IZrqQ/s1600-h/4.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 236px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373524473487164626" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SpKYCdoSBNI/AAAAAAAAAJk/eHR1Z_IZrqQ/s320/4.jpg" /></span></a><br /><br /><br /><span style="font-family:arial;">(Sample of a new shape made of two circles. One as the body and the other as the head, grouped together as one shape)</span></li></ol><p><strong><span style="font-family:arial;">- MRBAR</span></strong></p></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com2tag:blogger.com,1999:blog-2026871939246194076.post-292149344497556902009-08-24T00:34:00.000-07:002009-08-24T00:42:39.694-07:00Word Tips - Upgrading Equation Editor for Word 2003 to MathType<div align="justify"><span style="font-family:arial;"><strong>MathType</strong> 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.<br /><br />MathType is as easy to use as Equation Editor and has many extra features to help you work faster and create better-looking documents.<br /><br />MathType includes:</span></div><span style="font-family:arial;"><ul><li><div align="justify">Euclid™ font set with hundreds of additional math symbols.</div></li><li><div align="justify">New templates and symbols for geometry, chemistry and much more.</div></li><li><div align="justify">Professional color support.</div></li><li><div align="justify">Create equations for World Wide Web documents.</div></li><li><div align="justify">Translators that output equations to other languages such as TeX, AMS-TeX, LaTeX, MathML and custom languages.</div></li><li><div align="justify">Special commands for equation numbering, formatting, and converting Microsoft Word documents.</div></li><li><div align="justify">Customizable toolbars to hold hundreds of your most frequently used symbols, expressions and equations.</div></li><li><div align="justify">Customizable keyboard shortcuts.</div></li><li><div align="justify">A comprehensive printed user manual, loaded with tips and tutorials.</div></li><li><div align="justify">Much more…</div></li></ul><p align="justify">Design Science continuously enhances MathType, implementing the latest technology to make equation writing easier and compatible with all your favorite software.<br /><br />Visit MathType on the World Wide Web, or call Design Science to receive complete and current information about MathType.<br /><br />Design Science, Inc.<br />(800) 827-0685 (United States and Canada only)<br />(562) 433-0685 (outside the United States and Canada)<br />(562) 433-6969 (fax)<br /><br />E-mail: <a href="mailto:sales@mathtype.com">sales@mathtype.com</a><br /><br />World Wide Web: <a href="http://www.mathtype.com/msee">http://www.mathtype.com/msee</a><br /><br /><strong>- MRBAR</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com18tag:blogger.com,1999:blog-2026871939246194076.post-77950620848304302592009-08-23T22:06:00.001-07:002009-08-24T06:54:38.216-07:00Word Tips - Create Complex Equations in Office Applications<div align="justify"><span style="font-family:arial;">Creating complex formula is hard but things get easy with the equation builder in Microsoft Word.<br /><br /></span><span style="font-family:arial;">Word 2007 users can easily find the function from <strong>Symbols</strong> group under the <strong>Insert</strong> tab.</span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SpIh1Lx0PmI/AAAAAAAAAI8/GdIL4AYhRl8/s1600-h/5.jpg"><span style="font-family:arial;"><br /><br /><img style="WIDTH: 106px; HEIGHT: 92px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373394502984941154" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SpIh1Lx0PmI/AAAAAAAAAI8/GdIL4AYhRl8/s320/5.jpg" /></span></a><br /><br /><span style="font-family:arial;">You can click on the upper part of the <strong>Equation</strong> button to create your own equation or click the lower part to select any of the built-in equations.</span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SpIh1hv4RgI/AAAAAAAAAJE/AFDqsU-Eu4A/s1600-h/6.jpg"><span style="font-family:arial;"><br /><br /><img style="WIDTH: 451px; HEIGHT: 134px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373394508882396674" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SpIh1hv4RgI/AAAAAAAAAJE/AFDqsU-Eu4A/s320/6.jpg" /></span></a><br /><br /><span style="font-family:arial;">You can also combine your equation with the built-in equations from the <strong>Equation</strong> button under <strong>Tools</strong> group in the <strong>Design</strong> tab.<br /><br /></span><span style="font-family:arial;"><strong><span style="color:#ff0000;">For earlier Word version users</span></strong>, you will have to add the <strong>Equation Editor</strong> button onto any of your existing toolbars (you can create a new toolbar if you want to) or menus.</span></div><ol><li><div align="justify"><span style="font-family:arial;">From <strong>View</strong> menu, go to <strong>Toolbars </strong>and select <strong>Customize</strong>.</span></div></li><li><div align="justify"><span style="font-family:arial;">Click <strong>Commands</strong> tab.</span></div></li><li><div align="justify"><span style="font-family:arial;">Select <strong>Insert</strong> under <strong>Categories:</strong>.</span></div></li><li><div align="justify"><span style="font-family:arial;">Drag the <strong>Equation Editor</strong> button found under <strong>Commands:</strong> into any toolbars.</span><a href="http://2.bp.blogspot.com/_lX611N_RlBg/SpIglBYB2sI/AAAAAAAAAIc/3PpxdF0lRQE/s1600-h/1.jpg"><br /><br /><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 304px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373393125802891970" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SpIglBYB2sI/AAAAAAAAAIc/3PpxdF0lRQE/s320/1.jpg" /></span></a><br /><br /><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SpIglV2D6cI/AAAAAAAAAIk/C3DgyfepVdQ/s1600-h/2.jpg"><span style="font-family:arial;"><img style="WIDTH: 266px; HEIGHT: 55px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373393131297565122" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SpIglV2D6cI/AAAAAAAAAIk/C3DgyfepVdQ/s320/2.jpg" /></span></a><br /><br /></div></li><li><div align="justify"><span style="font-family:arial;"><strong>Close</strong> the <strong>Customize</strong> dialog box and now you can add your equation by clicking the <strong>Equation Editor</strong> button you've just added. You will see the <strong>Equation</strong> toolbar and an empty placeholder is ready to put your equation.<br /><br /></span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SpIgl52ZC4I/AAAAAAAAAIs/Mk6MoxiTuig/s1600-h/3.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 120px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373393140962626434" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SpIgl52ZC4I/AAAAAAAAAIs/Mk6MoxiTuig/s320/3.jpg" /></span></a><span style="font-family:arial;"><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">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. </span><span style="font-family:arial;"><em><br /></em></span></div></li><li><div align="justify"><span style="font-family:arial;">Once complete, click anywhere outside of the equation placeholder.<br /><br /><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SpIgmZTSCxI/AAAAAAAAAI0/aD9Td9KXEcU/s1600-h/4.jpg"><span style="font-family:arial;"><img style="WIDTH: 114px; HEIGHT: 84px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5373393149405301522" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SpIgmZTSCxI/AAAAAAAAAI0/aD9Td9KXEcU/s320/4.jpg" /></span></a><br />(Sample of equation... Do you think you can easily create this equation without the equation builder?) </span></div></li></ol><p align="justify"><span style="font-family:arial;">You can also copy this equation into PowerPoint or Excel if you want to use the same equation in these applications.</span></p><p align="justify"><span style="font-family:arial;"><strong>- MRBAR</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-90599800693989287422009-08-15T18:12:00.000-07:002009-08-23T21:56:24.595-07:00Visio 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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.<br /></span></div><br /><div align="justify"><span style="font-family:arial;">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.</span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Visualize, explore, and communicate your systems, resources, processes, and the data behind them.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Be more productive by integrating diagrams with information across sources.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Reduce manual data reentry by letting Office Visio 2007 keep diagrams up-to-date for you.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Visualize and act on complex information by displaying data in diagrams.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Explore data and easily track trends, identify issues, and flag exceptions with PivotDiagrams.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create diagrams faster by letting Visio connect shapes for you.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Communicate complex information with new templates and shapes.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Effectively convey information with professional-looking diagrams.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Communicate using diagrams and share them with a broad audience.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Customize Office Visio 2007 programmatically and create custom data-connected solutions.<br /></strong>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.<br /></span><span style="font-family:arial;">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).</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com2tag:blogger.com,1999:blog-2026871939246194076.post-59196023402991694162009-08-15T17:59:00.000-07:002009-08-23T21:56:48.080-07:00Publisher 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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. </span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Efficiently create high-quality publications that reflect your brand identity.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Preview and access high-quality Microsoft Office Online templates from within Office Publisher 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Connect with customers by personalizing your publications.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Convert your publications to PDF or XPS format.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Simplify the process of creating publications with Office Publisher Tasks.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Combine lists within Office Publisher 2007 for targeted mailings.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Save time by reusing your work.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Build custom publications from a database.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Fine-tune your publications with powerful, intuitive design tools.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Effectively manage and track your marketing campaigns.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com3tag:blogger.com,1999:blog-2026871939246194076.post-83395724659240833562009-08-15T17:52:00.000-07:002009-08-23T22:00:26.915-07:00Project 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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.</span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Effectively manage and understand project schedules.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Get productive quickly.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Leverage existing data.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Build professional charts and diagrams.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Effectively communicate information.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Gain greater control of resources and finances.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Quickly access the information you need.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Track projects according to your needs.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Customize Office Project 2007 to your needs.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Get Office Project 2007 assistance when you need it.<br /></strong>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. </span></div></li></ol><p align="justify"><span style="font-family:Arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com4tag:blogger.com,1999:blog-2026871939246194076.post-80585147851149288652009-08-15T17:46:00.000-07:002009-08-23T22:01:27.519-07:00OneNote 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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.</span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Gather your notes and information in one place.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Back up your valuable information.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Find information more quickly.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Work together more effectively.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Avoid duplicate work.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Organize your way.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Prioritize and manage tasks and your to-do list more efficiently.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Make meetings more productive.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Get up to speed quickly.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Improve productivity away from the office.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-64634677151880303032009-08-15T17:38:00.000-07:002009-08-23T22:01:46.393-07:00InfoPath 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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. </span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Deploy InfoPath forms as Microsoft Office Outlook e-mail messages.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Extend business processes beyond the firewall.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Easily convert Microsoft Office Word documents and Excel spreadsheets to InfoPath forms.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Make complex form design easier.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create PDF or XPS records of your form data.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Master your forms workflow using Office InfoPath 2007 and Microsoft Office SharePoint Server 2007.<br /></strong>Use the integrated workflow management tools in Office SharePoint Server 2007 to drive information-gathering processes efficiently.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Design a single form for Web browsers and Office InfoPath 2007 clients.<br /></strong>Office InfoPath 2007 includes a design checker to help ensure consistency for forms deployed to InfoPath Forms Services.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Enhance protection of important information in InfoPath form templates.<br /></strong>Office InfoPath 2007 includes support for information rights management to help protect forms from inappropriate usage and distribution.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Centralize forms management for the entire organization.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Develop advanced forms solutions with Office InfoPath 2007 and Microsoft Visual Studio 2005.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com3tag:blogger.com,1999:blog-2026871939246194076.post-34960057781555379222009-08-15T17:27:00.000-07:002009-08-23T22:02:07.597-07:00Groove 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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. </span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Bring the team, tools, and information together in one place.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Customize each workspace for the team's unique needs.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Collaborate with colleagues, partners, and customers — with one product.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Stay productive anywhere, online or offline.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Stay in sync, automatically and efficiently.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>See who's working on what, when.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Synchronize SharePoint document libraries with Office Groove 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create a form with Microsoft Office InfoPath 2007; share it with Office Groove 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Make the most of impromptu encounters with Microsoft Office Communicator integration.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Work with international teams in their own languages.<br /></strong>With support for 28 languages, your global team members can now experience the power of Office Groove 2007 in their native languages.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com1tag:blogger.com,1999:blog-2026871939246194076.post-4001367938091380382009-08-15T09:06:00.000-07:002009-08-23T22:02:26.728-07:00PowerPoint 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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. </span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Get better results faster with the Microsoft Office Fluent user interface.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create powerful, dynamic SmartArt diagrams.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Easily reuse content with Office PowerPoint 2007 Slide Libraries.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Communicate with users across platforms and devices.<br /></strong>Help ensure broad communication with your PowerPoint presentations by converting your files to XPS and PDF files for sharing with users on any platform.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Use custom layouts to assemble presentations more quickly.</strong><br />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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Accelerate your review processes using Office PowerPoint 2007 and Office SharePoint Server 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Uniformly format your presentations with Document Themes.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Dramatically modify shapes, text, and graphics with new SmartArt graphics tools and effects.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Add more security to your PowerPoint presentations.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Reduce your document sizes and improve file recovery at the same time.</strong><br />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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com1tag:blogger.com,1999:blog-2026871939246194076.post-34470216763654660492009-08-15T09:01:00.000-07:002009-08-23T22:03:16.808-07:00Access 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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. </span></div><br /><ol><li><div align="justify"><span style="font-family:arial;"><strong>Get better results faster with the Office Fluent user interface.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Get started quickly using prebuilt solutions.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create multiple reports with different views of the same information.</strong><br />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. . </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create tables quickly without worrying about database complexity.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Enjoy new field types for even richer scenarios.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Collect and update your information directly from the source.</strong><br />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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Share your information with Microsoft Windows SharePoint Services.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Track Windows SharePoint Services lists with the rich client capabilities of Office Access 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Move data to Windows SharePoint Services for better manageability.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Access and use information from multiple sources.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-13122246613592427332009-08-15T08:46:00.000-07:002009-08-23T22:03:55.974-07:00Excel 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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.</span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><br /><ol><li><div align="justify"><span style="font-family:arial;"><strong>Office Excel 2007 features the Microsoft Office Fluent user interface to help you find powerful tools when you need them.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Import, organize, and explore massive data sets within significantly expanded spreadsheets.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Use the completely redesigned charting engine in Office Excel 2007 to communicate your analysis in professional-looking charts.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Enjoy improved and powerful support for working with tables.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Create and work with interactive PivotTable views with ease.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>“See” important trends and find exceptions in your data.<br /></strong>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. </span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Use Office Excel 2007 and Excel Services to help share spreadsheets more securely with others.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Help ensure you and your organization work with the most current business information.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Reduce the size of spreadsheets and improve damaged file recovery at the same time.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Extend your business intelligence investments because Office Excel 2007 provides full support for Microsoft SQL Server 2005 Analysis Services.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-75970393849596397032009-08-15T08:37:00.000-07:002009-08-23T22:04:20.732-07:00Word 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">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.</span></div><br /><br /><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Spend more time writing and less time formatting.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Communicate more effectively with SmartArt diagrams and new charting tools.<br /></strong>New SmartArt diagrams and a new charting engine help you create great-looking content with 3-D shapes, transparency, drop shadows, and other effects.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Quickly assemble documents using Building Blocks.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Save as PDF or XPS directly from Office Word 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Publish and maintain blogs directly from Office Word 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Master your document review processes using Office Word 2007 and Microsoft Office SharePoint Server 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Connect your documents to business information.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Remove tracked changes, comments, and hidden text from your documents.</strong><br />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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Use the tri-pane review panel to compare and combine documents.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Reduce your file sizes and improve corrupt file recovery.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-76188066520312335622009-08-15T08:24:00.000-07:002009-08-23T22:04:42.475-07:00Outlook 2007 Top 10 Benefits<div align="justify"><span style="font-family:arial;">Office Outlook 2007 helps users better manage their time and information, connect across boundaries, and help remain safe and in control.</span></div><div align="justify"><span style="font-family:arial;"></span></div><ol><li><div align="justify"><span style="font-family:arial;"><strong>Instantly search all your information.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Easily manage your daily priorities and information.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Get better results faster with the Microsoft Office Fluent user interface.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Connect with people easily and effectively.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Increased collaboration and functionality with Microsoft Exchange Server 2007.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Manage your shared information and content in one interface.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Enjoy new measures that help keep you safe from junk e-mail and malicious sites.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Send text messages from Office Outlook with one easy click.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Organize your information in new, rich ways.<br /></strong>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.</span></div></li><br /><li><div align="justify"><span style="font-family:arial;"><strong>Manage all your communication in one interface.<br /></strong>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.</span></div></li></ol><p align="justify"><span style="font-family:arial;">- <strong>Siti Suriani</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-65112787689132301132009-08-05T22:00:00.000-07:002009-08-23T23:39:17.512-07:00Outlook Tips - View Your Webmail from Your MS Outlook<div align="justify"><div><div><div><span style="font-family:arial;">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.<br /></span></div><div><span style="font-family:arial;">For Microsoft Outlook users... you can actually access your webmail without using any internet browser.</span></div><div><span style="font-family:arial;"></span></div><div><span style="font-family:arial;">Here's how to do it...</span></div><div><span style="font-family:arial;"></span></div><div><span style="font-family:arial;">Step 1: Create a folder under your account.</span></div><ol><li><span style="font-family:arial;">From the <strong>Standard Toolbar</strong>, click the <strong>New</strong> pull-down button and select <strong>Folder...</strong> .<br /><br /></span><a href="http://2.bp.blogspot.com/_lX611N_RlBg/Snrz-PtFYvI/AAAAAAAAAHk/rptsk2XHl1s/s1600-h/1.jpg"><span style="font-family:arial;"><img style="WIDTH: 280px; HEIGHT: 217px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366870156658434802" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/Snrz-PtFYvI/AAAAAAAAAHk/rptsk2XHl1s/s320/1.jpg" /></span></a><br /><br /></li><li><span style="font-family:arial;">Type a name in the field under <strong>Name:</strong> and make sure you select the root of your email account for the <strong>Select where to place the folder:</strong> list.<br /><br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/Snrz-V49lHI/AAAAAAAAAHs/8MiXdUmPaBA/s1600-h/2.jpg"><span style="font-family:arial;"><img style="WIDTH: 265px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366870158318867570" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/Snrz-V49lHI/AAAAAAAAAHs/8MiXdUmPaBA/s320/2.jpg" /></span></a><br /></li></ol><p><span style="font-family:arial;">Step 2: Convert the folder to view your webmail.</span></p><ol><li><span style="font-family:arial;">Right-click on folder you've just created and select <strong>Properties</strong>.<br /><br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/Snrz-rk54TI/AAAAAAAAAH0/mvRWcxZGlyE/s1600-h/3.jpg"><span style="font-family:arial;"><img style="WIDTH: 280px; HEIGHT: 308px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366870164140319026" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/Snrz-rk54TI/AAAAAAAAAH0/mvRWcxZGlyE/s320/3.jpg" /></span></a><br /><br /></li><li><span style="font-family:arial;">On the folder's properties dialog box (mine is showing "Webmail Properties" as I've named my folder as "Webmail"), go to <strong>Homepage</strong> tab.</span></li><li><span style="font-family:arial;">Type the website address you usually use in your internet browser, starting with <em>http://</em> in the <strong>Address:</strong> field.<br /><br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/Snrz-6q8xlI/AAAAAAAAAH8/SXbLcG8NDso/s1600-h/4.jpg"><span style="font-family:arial;"><img style="WIDTH: 250px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366870168192206418" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/Snrz-6q8xlI/AAAAAAAAAH8/SXbLcG8NDso/s320/4.jpg" /></span></a><br /><br /></li><li><span style="font-family:arial;">Click to enable the checkbox for <strong>Show home page by default for this folder</strong>.</span></li><li><span style="font-family:arial;">Click <strong>OK</strong>.</span></li></ol><p><span style="font-family:arial;">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.<br /><br /></span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/Snr0gcBTwDI/AAAAAAAAAIM/gbKvOccsuJo/s1600-h/6.jpg"><span style="font-family:arial;"><img style="WIDTH: 649px; HEIGHT: 345px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366870744080039986" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/Snr0gcBTwDI/AAAAAAAAAIM/gbKvOccsuJo/s320/6.jpg" /></span></a><br /><a href="http://4.bp.blogspot.com/_lX611N_RlBg/Snrz_A_TUKI/AAAAAAAAAIE/68bqCDKpt0U/s1600-h/5.jpg"></a></p><p><span style="font-family:arial;">You can actually use this method to view any website you want like I do to view my training schedule.</span></p><a href="http://4.bp.blogspot.com/_lX611N_RlBg/Snr0giMxxnI/AAAAAAAAAIU/fOgYDVMAt9w/s1600-h/7.jpg"><span style="font-family:arial;"><img style="WIDTH: 647px; HEIGHT: 357px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366870745738757746" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/Snr0giMxxnI/AAAAAAAAAIU/fOgYDVMAt9w/s320/7.jpg" /></span></a><br /><br /><br /><p><strong><span style="font-family:arial;">- MRBAR</span></strong></p></div></div><br /></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-31866856819917363832009-08-04T22:26:00.000-07:002009-08-04T22:52:46.697-07:00Outlook Tips - Make Your Outlook Check or Send for New Emails More Frequently<div align="justify"><span style="font-family:arial;">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.<br /></span><br /><span style="font-family:arial;">You can actually change the setting to read new emails from as frequent as every 1 minute to maximum of every 120 minutes.</span><br /><ol><li><span style="font-family:arial;">Go to <strong>Tools</strong> menu, select <strong>Option...</strong>.</span></li><li><span style="font-family:arial;">On the <strong>Options</strong> dialog box, go to <strong>Mail Setup</strong> tab and click <strong>Send/Recieve...</strong> button.</span></li><br /><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SnkcVBFVBAI/AAAAAAAAAHE/-TYEMzA7hok/s1600-h/1.jpg"><span style="font-family:arial;"><img style="WIDTH: 276px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366351578382271490" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SnkcVBFVBAI/AAAAAAAAAHE/-TYEMzA7hok/s320/1.jpg" /></span></a><br /><br /><li><span style="font-family:arial;">On the <strong>Send/Recieve Groups</strong> dialog box, change the value (default is 30) for <strong>Schedule an automatic send/receive every</strong> ... <strong>minutes</strong> field under <strong>Setting for group "All Accounts"</strong> (or any other account you may have in your <strong>Group Name</strong> field.</span></li><br /><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SnkcVS8qC9I/AAAAAAAAAHM/JtekVywS-OA/s1600-h/2.jpg"><span style="font-family:arial;"><img style="WIDTH: 281px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5366351583177739218" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SnkcVS8qC9I/AAAAAAAAAHM/JtekVywS-OA/s320/2.jpg" /></span></a><br /><br /><li><span style="font-family:arial;">Once done, click <strong>Close</strong> and then click <strong>OK</strong> to close the <strong>Options</strong> dialog box.</span></li></ol><p><span style="font-family:arial;">Don't set it to 1 minute of your internet connection speed is poor. Maybe you can reduce it to 5 minutes.</span></p><p><span style="font-family:arial;">By doing this simple setting, it could help you to save your career... ;)</span></p><p><strong><span style="font-family:arial;">- MRBAR</span></strong></p></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-84789233392323737152009-07-31T08:12:00.000-07:002009-08-07T20:06:53.891-07:00Office Day @ Angkasapuri, Kuala Lumpur<div align="justify"><span style="font-family:arial;">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. </span></div><br /><a href="http://1.bp.blogspot.com/_lX611N_RlBg/Snmmn9AGzHI/AAAAAAAAAHc/FWoMArt68-g/s1600-h/1.jpg"><img id="BLOGGER_PHOTO_ID_5366503636308774002" style="WIDTH: 320px; CURSOR: hand; HEIGHT: 191px" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/Snmmn9AGzHI/AAAAAAAAAHc/FWoMArt68-g/s320/1.jpg" border="0" /></a><br /><br /><a href="http://2.bp.blogspot.com/_lX611N_RlBg/SnmmnyZ_3aI/AAAAAAAAAHU/Iz1KEUXIaPE/s1600-h/2.jpg"><img id="BLOGGER_PHOTO_ID_5366503633464581538" style="WIDTH: 320px; CURSOR: hand; HEIGHT: 247px" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SnmmnyZ_3aI/AAAAAAAAAHU/Iz1KEUXIaPE/s320/2.jpg" border="0" /></a><br /><br /><span style="font-family:arial;"><strong>- Siti Suriani</strong></span>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-80683834394208251432009-07-30T05:32:00.001-07:002009-07-30T06:28:04.450-07:00Word Tips – Easiest Option to format a report using MS Word 2007<div align="justify"><div><div><div><div><div><div><div><span xmlns=""><p><span style="font-family:arial;">Normally user will spend more time to do formatting rather than focusing on the content. Here is how you can do it even faster…. </span></p><p><span style="font-family:arial;">Below is the sample report before formatting:-<br /><br /></span><a href="http://2.bp.blogspot.com/_lX611N_RlBg/SnGVbRydg4I/AAAAAAAAAE0/poLLpAbJzqY/s1600-h/1.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 174px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364232927039030146" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SnGVbRydg4I/AAAAAAAAAE0/poLLpAbJzqY/s320/1.jpg" /></span></a><br /><span style="font-family:arial;"></span></p><p><span style="font-family:arial;">Make sure the entire report is finalized already. </span></p><ol><li><span style="font-family:arial;">Click anywhere within the report. </span></li><li><span style="font-family:arial;">From the <strong>Home</strong> tab, under <strong>Styles</strong> group, click on the <strong>Change Styles</strong> drop down arrow button – change the set of styles, colors and fonts (apply for the entire document). </span></li><li><div><span style="font-family:arial;">Point to <strong>Style Set</strong> and move over to see the live preview of each style from the drop down list.<br /><br /></span><a href="http://2.bp.blogspot.com/_lX611N_RlBg/SnGVbkPo3hI/AAAAAAAAAE8/I96b9pIItoQ/s1600-h/2.jpg"><span style="font-family:arial;"><img style="WIDTH: 286px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364232931993247250" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SnGVbkPo3hI/AAAAAAAAAE8/I96b9pIItoQ/s320/2.jpg" /></span></a></div></li></ol><p><span style="font-family:arial;">Style Set Samples:- </span><br /></p><ol><li><div><span style="font-family:arial;">Distinctive<br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SnGVbxKNEbI/AAAAAAAAAFE/pUvSkh8GzFs/s1600-h/3.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 159px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364232935460114866" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SnGVbxKNEbI/AAAAAAAAAFE/pUvSkh8GzFs/s320/3.jpg" /></span></a><br /></div></li><br /><li><div><span style="font-family:arial;">Elegant<br /></span><a href="http://2.bp.blogspot.com/_lX611N_RlBg/SnGVcEIu1-I/AAAAAAAAAFM/WATiAr9a5kc/s1600-h/4.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 223px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364232940554213346" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SnGVcEIu1-I/AAAAAAAAAFM/WATiAr9a5kc/s320/4.jpg" /></span></a><br /><br /></div></li><li><div><span style="font-family:arial;">Fancy<br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SnGVcpHJ1RI/AAAAAAAAAFU/oHiIeqj2ft8/s1600-h/5.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 174px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364232950479705362" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SnGVcpHJ1RI/AAAAAAAAAFU/oHiIeqj2ft8/s320/5.jpg" /></span></a><br /><br /></div></li><li><div><span style="font-family:arial;">Formal<br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SnGV9oC9tBI/AAAAAAAAAFc/V4ySyLvythE/s1600-h/6.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 173px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364233517129380882" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SnGV9oC9tBI/AAAAAAAAAFc/V4ySyLvythE/s320/6.jpg" /></span></a><br /><br /></div></li><li><div><span style="font-family:arial;">Manuscript<br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SnGV-EbLnBI/AAAAAAAAAFk/XqoSYe3jrpc/s1600-h/7.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 252px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364233524747148306" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SnGV-EbLnBI/AAAAAAAAAFk/XqoSYe3jrpc/s320/7.jpg" /></span></a><br /><br /></div></li><li><div><span style="font-family:arial;">Modern<br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SnGV-BdsLCI/AAAAAAAAAFs/3T3V_OnzJac/s1600-h/8.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 172px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364233523952364578" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SnGV-BdsLCI/AAAAAAAAAFs/3T3V_OnzJac/s320/8.jpg" /></span></a><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SnGV-BdsLCI/AAAAAAAAAFs/3T3V_OnzJac/s1600-h/8.jpg"></a><br /><br /></div></li><li><div><span style="font-family:arial;">Simple<br /></span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SnGV-rGXg-I/AAAAAAAAAF0/8H-6aJJdFYI/s1600-h/9.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 176px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364233535128830946" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SnGV-rGXg-I/AAAAAAAAAF0/8H-6aJJdFYI/s320/9.jpg" /></span></a><br /><br /></div></li><li><div><span style="font-family:arial;">Traditional<br /></span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SnGV-5pGxbI/AAAAAAAAAF8/Yf7zeJp0Dno/s1600-h/10.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 148px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5364233539032630706" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SnGV-5pGxbI/AAAAAAAAAF8/Yf7zeJp0Dno/s320/10.jpg" /></span></a></div></li></ol><p><span style="font-family:arial;"><strong>- Siti Suriani</strong></span></p></span></div></div></div></div></div></div></div><br /></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-3694394737439878932009-07-27T18:24:00.001-07:002009-08-04T23:24:07.251-07:00Excel Tips - Getting List from Other Spreadsheet for Display with Data Validation List<div align="justify"><span style="font-family:arial;">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.</span></div><div align="justify"> </div><div align="justify"><span style="font-family:arial;">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.</span><br /></div><div align="justify"><span style="font-family:arial;">Here's how...</span></div><ol><li><div align="justify"><span style="font-family:arial;">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.</span><br /></div></li><li><div align="justify"><span style="font-family:arial;">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.</span></div></li><br /><a href="http://2.bp.blogspot.com/_lX611N_RlBg/Sm6-CfSQKeI/AAAAAAAAAEM/_UiuBQnIM9k/s1600-h/1.jpg"><img style="WIDTH: 320px; HEIGHT: 138px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5363433156211911138" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/Sm6-CfSQKeI/AAAAAAAAAEM/_UiuBQnIM9k/s320/1.jpg" /></a><br /><br /><li><div align="justify"><span style="font-family:arial;">Return to the other spreadsheet and select the cell(s) you want to create combo box.</span></div></li><li><div align="justify"><span style="font-family:arial;">With the cell(s) selected, go to <strong>Data</strong> tab and select <strong>Data Validation</strong> from <strong>Data Tools</strong> group (for Excel 2003 or earlier, go to <strong>Data</strong> menu and select <strong>Validation...</strong>).<br /></span></div></li><a href="http://2.bp.blogspot.com/_lX611N_RlBg/Sm6-Chx_NgI/AAAAAAAAAEU/LfcZTplPSqk/s1600-h/2.jpg"><img style="WIDTH: 185px; HEIGHT: 142px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5363433156881888770" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/Sm6-Chx_NgI/AAAAAAAAAEU/LfcZTplPSqk/s320/2.jpg" /></a><br /><br /><li><div align="justify"><span style="font-family:arial;">On the <strong>Data Validation</strong> dialog box, go to <strong>Settings</strong> tab.</span></div></li><li><div align="justify"><span style="font-family:arial;">Select <strong>List</strong> from <strong>Allow</strong> combo box.</span><br /><br /><a href="http://3.bp.blogspot.com/_lX611N_RlBg/Sm6-C3s_JFI/AAAAAAAAAEc/hK8ZFHr9M4s/s1600-h/3.jpg"><img style="WIDTH: 320px; HEIGHT: 251px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5363433162766492754" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/Sm6-C3s_JFI/AAAAAAAAAEc/hK8ZFHr9M4s/s320/3.jpg" /></a><br /></div></li><li><div align="justify"><span style="font-family:arial;">Type the name you have given for the list in step 2, starting with the equal sign (=) in the Source field (I used <em>FruitList</em> for my example).</span></div></li><br /><a href="http://4.bp.blogspot.com/_lX611N_RlBg/Sm6-C_6QdhI/AAAAAAAAAEk/jJXHYd6kizI/s1600-h/4.jpg"><img style="WIDTH: 320px; HEIGHT: 254px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5363433164969637394" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/Sm6-C_6QdhI/AAAAAAAAAEk/jJXHYd6kizI/s320/4.jpg" /></a><br /><br /><li><div align="justify"><span style="font-family:arial;">Click <strong>OK</strong> or you can continue setting the <strong>Input Message</strong> and/or <strong>Error Alert</strong> tab if you want to.<br /><br /><a href="http://3.bp.blogspot.com/_lX611N_RlBg/Sm6_ul44CZI/AAAAAAAAAEs/OBb1iS61bBE/s1600-h/5.jpg"><img style="WIDTH: 268px; HEIGHT: 75px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5363435013410392466" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/Sm6_ul44CZI/AAAAAAAAAEs/OBb1iS61bBE/s320/5.jpg" /></a></span></div></li></ol><p align="justify"><span style="font-family:arial;">You can combine the usage of this combo box with any lookup function or use it alone.</span></p><p align="justify"><span style="font-family:arial;"><strong>- MRBAR</strong></span></p>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-27368722800366841322009-07-21T05:40:00.000-07:002009-07-21T06:19:59.385-07:00Excel Tips - Hide Formula from Being Displayed in the Formula Bar<div><div align="justify"><span style="font-family:arial;">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.</span></div><div align="justify"><span style="font-family:Arial;"></span> </div><div align="justify"><span style="font-family:arial;">To hide the formula, you will have to protect your worksheet but before protecting, you'll have to set the cell's format.</span></div><ol><li><div align="justify"><span style="font-family:arial;">Select the cell(s) with the formula(s) you want to hide.</span></div></li><li><div align="justify"><span style="font-family:arial;">From <strong>Home</strong> tab, click <strong>Format</strong> from <strong>Cells</strong> group and select <strong>Format Cells</strong> (for earlier Excel versions, go to <strong>Format</strong> menu and select <strong>Cells</strong>).<br /><br /><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SmW-Y86ssfI/AAAAAAAAAD8/fA-PA-6RTNs/s1600-h/1.jpg"><img style="WIDTH: 192px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360900267332907506" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SmW-Y86ssfI/AAAAAAAAAD8/fA-PA-6RTNs/s320/1.jpg" /></a><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">From the <strong>Format Cells</strong> dialog box, go to the <strong>Protection</strong> tab.</span></div></li><li><div align="justify"><span style="font-family:arial;">Select the <strong>Hidden</strong> check box (leave the <strong>Locked</strong> check box selected to protect from user changing or deleting the cell content).<br /><br /><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SmW-ZOWdMBI/AAAAAAAAAEE/hoALHfe0g0A/s1600-h/2.jpg"><img style="WIDTH: 320px; HEIGHT: 278px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360900272012734482" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SmW-ZOWdMBI/AAAAAAAAAEE/hoALHfe0g0A/s320/2.jpg" /></a><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">Click <strong>OK</strong>.</span></div></li></ol><p align="justify"><span style="font-family:arial;">(If you want to allow entering or editing data on certain cells, select those cells and follow step 2 and 3. Then uncheck the <strong>Locked</strong> check box and click <strong>OK</strong>.)</span><br /></p><p align="justify"><span style="font-family:arial;">Now you can protect your worksheet.</span></p><ol><li><div align="justify"><span style="font-family:arial;">From <strong>Home</strong> tab, click <strong>Format</strong> from <strong>Cells</strong> group and select <strong>Protect Sheet...</strong> or you can also find <strong>Protect Sheet</strong> button in the <strong>Changes</strong> group from <strong>Review</strong> tab (for earlier versions, go to <strong>Tools</strong> menu, point at <strong>Protection</strong> and select <strong>Protect Sheet...</strong>).</span></div></li><li><div align="justify"><span style="font-family:arial;">Apply your password to protect (optional) and repeat the same password after clicking <strong>OK</strong>.</span></div></li></ol><p align="justify"><span style="font-family:arial;"><strong>REMINDER!</strong> 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 :).</span><br /></p><p align="justify"><span style="font-family:arial;"><strong>- MRBAR</strong></span></p></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-58283796733826915322009-07-21T05:07:00.001-07:002009-07-21T05:39:36.261-07:00Excel Tips – Protect Certain Part of Spreadsheet from Changes<div align="justify"><span xmlns=""><span style="font-family:arial;">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?</span></div><div align="justify"><br /><ol><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Click on the top left of the worksheet or press <strong>Ctrl+A</strong> to Select All<br /><br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SmWx38pM8gI/AAAAAAAAAC0/dumroTkgPzI/s1600-h/1.jpg"><span style="font-family:arial;"><img border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SmWx38pM8gI/AAAAAAAAAC0/dumroTkgPzI/s320/1.jpg" /></span></a><br /><br /></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Press <strong>Ctrl+1</strong> to open up the <strong>Format Cells</strong> dialog box</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Click on the <strong>Protection</strong> tab</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Clear the <strong>Locked</strong> check box</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Click <strong>OK</strong><br /><br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SmWx4Pv8YLI/AAAAAAAAAC8/2Zghi6SKQak/s1600-h/2.jpg"><span style="font-family:arial;"><img border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SmWx4Pv8YLI/AAAAAAAAAC8/2Zghi6SKQak/s320/2.jpg" /></span></a><span style="font-family:arial;"><br /><br /></span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Highlight the area in the data area.<br /><br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SmWx4dILuUI/AAAAAAAAADE/UarKY_e9YVQ/s1600-h/3.jpg"><span style="font-family:arial;"><img border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SmWx4dILuUI/AAAAAAAAADE/UarKY_e9YVQ/s320/3.jpg" /></span></a><span style="font-family:arial;"><br /><br /></span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Open the <strong>Format Cells</strong> dialog box again</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">This time around, check the <strong>Locked</strong> check box</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Click <strong>OK</strong><br /><br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SmWx4w94myI/AAAAAAAAADM/WiAJ8GaqM2I/s1600-h/4.jpg"><span style="font-family:arial;"><img border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SmWx4w94myI/AAAAAAAAADM/WiAJ8GaqM2I/s320/4.jpg" /></span></a><br /><br /></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Next step is to protect the worksheet</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Click on the <strong>Review</strong> tab, <strong>Changes</strong> group, <strong>Protect Sheet</strong> command button (for MS Excel 2003 – Click on the <strong>Tools</strong> menu, <strong>Protection</strong>, <strong>Protect Sheet</strong>)</span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SmWx5JPXv4I/AAAAAAAAADU/xhy2bne4688/s1600-h/5.jpg"><br /><br /><span style="font-family:arial;"><img border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SmWx5JPXv4I/AAAAAAAAADU/xhy2bne4688/s320/5.jpg" /></span></a><br /><br /></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Type a password to unprotect sheet</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Reenter the password<br /><br /></span><a href="http://3.bp.blogspot.com/_lX611N_RlBg/SmWzhpWdqgI/AAAAAAAAADs/CaErXq-Ancg/s1600-h/6.jpg"><span style="font-family:arial;"><img style="WIDTH: 309px; HEIGHT: 187px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360888322071570946" border="0" alt="" src="http://3.bp.blogspot.com/_lX611N_RlBg/SmWzhpWdqgI/AAAAAAAAADs/CaErXq-Ancg/s320/6.jpg" /></span></a><br /><br /></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">Try to make changes on the selected data area</span></div></li><li><div style="TEXT-ALIGN: justify"><span style="font-family:arial;">The message box below will come out<br /><br /></span><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SmWzh-AedSI/AAAAAAAAAD0/alSkkQLYsio/s1600-h/7.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 56px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360888327616492834" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SmWzh-AedSI/AAAAAAAAAD0/alSkkQLYsio/s320/7.jpg" /></span></a><br /></div></li></ol><p style="TEXT-ALIGN: justify"><span style="font-family:arial;">Now all is being set, users are not allowed to make any changes on the selected data area.<br /></span></p><br /><p><span style="font-family:arial;"><strong>- Siti Suriani</strong></span></p></span></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-80121264356408276702009-07-20T04:33:00.000-07:002009-08-06T19:59:00.654-07:00Word Tips - Create Table of Content<span style="font-family:arial;">Microsoft Word 2007 and earlier version has the feature of creating table of content from the title of each chapter or sub-chapter.</span> <div><br /><div align="justify"><span style="font-family:arial;"></span></div><div align="justify"><span style="font-family:arial;">Before able to use the TOC feature, you must first format your titles to heading style:</span></div><ol><li><div align="justify"><span style="font-family:arial;">From your document, click anywhere in the chapter's title line.</span></div></li><li><div align="justify"><span style="font-family:arial;">Select <strong>Heading 1</strong> from <strong>Styles</strong> group in the <strong>Home</strong> Tab (for previous Word version, goto <strong>Format</strong> menu and then select <strong>Styles and Formatting</strong>. You'll see Styles and Formatting appears normally on the right side of the window).<br /><br /><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SmRqs-na4_I/AAAAAAAAACk/6ZgXlhvmHBk/s1600-h/1.jpg"><img style="WIDTH: 320px; HEIGHT: 65px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360526777432859634" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SmRqs-na4_I/AAAAAAAAACk/6ZgXlhvmHBk/s320/1.jpg" /></a></span></div></li></ol><div align="justify"><span style="font-family:arial;">Repeat the steps above for all titles that you've created. You can actually perform these steps as you are creating your document. This way will save time rather that searching the titles from beginning to the end of your completed document.</span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><div align="justify"><span style="font-family:arial;">Select <strong>Heading 2</strong> style for sub-topic's title (level 2). You 'll see <strong>Heading 3</strong> style (for sub-sub-topic) will automatically appear after Heading 2 and more heading styles will appear when you choose the new heading style.</span></div><br /><div align="justify"><span style="font-family:arial;"></span></div><div align="justify"><span style="font-family:arial;">Once you've done applying the style, you can add a new page as your first page. This is important.... Use insert section brake and don't use page break so you can customise the page numbering for TOC and the contents separately.</span></div><br /><ol><li><div align="justify"><span style="font-family:arial;">Select the new first page.</span></div></li><li><div align="justify"><span style="font-family:arial;">Go to <strong>References</strong> tab and select <strong>Table of Contents</strong> from the <strong>Table of Contents</strong> group (for earlier version, go to <strong>Insert</strong> menu, hover on <strong>Reference</strong> and select <strong>Index and Table</strong>... and then select <strong>Table of Contents</strong> tab).<br /><br /><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SmRqtOnmpZI/AAAAAAAAACs/8w5P_kM4w7c/s1600-h/2.jpg"><img style="WIDTH: 217px; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360526781728597394" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SmRqtOnmpZI/AAAAAAAAACs/8w5P_kM4w7c/s320/2.jpg" /></a><br /><br /></span></div></li><li><div align="justify"><span style="font-family:arial;">Select one of the built-in TOC style or select <strong>Insert Table of Contents...</strong> if you want to display more that 3 levels of TOC by increasing the value in the <strong>Show levels</strong> (same for earlier version where you can see the <strong>Show level</strong> in the <strong>Table of Contents</strong> tab of the <strong>Index and Tables</strong> dialog box).</span></div></li></ol><p align="justify"><span style="font-family:arial;">If you do any changes on the document's title(s) or move the chapter and its title, you can just update the TOC and it will change the writing and page number automatically.</span></p><p align="justify"><span style="font-family:arial;">Easiest way is to press <strong>Ctrl+A</strong> to select all and then press the <strong>F9</strong> function key. You'll then have the option to update entire content or just the page number.</span></p><p align="justify"><strong><span style="font-family:arial;">- MRBAR</span></strong></p></div>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-35144583241401165152009-07-20T03:54:00.001-07:002009-07-20T04:11:48.202-07:00Excel Tips – Copying or Cutting Formula<span xmlns=""><p><span style="font-family:arial;">When you copy and paste formulas containing relative references, the references are adjusted.<br /></span></p><span style="font-family:arial;"><strong></strong></span><br /><span style="font-family:arial;"><strong>Microsoft Office Excel 2003</strong><br /><br /></span><span style="font-family:arial;"></span><ol><li><span style="font-family:arial;">Select cell with formula</span></li><li><span style="font-family:arial;">Click <strong>Copy</strong> on the <strong>Edit</strong> menu</span></li><li><span style="font-family:arial;">Select cell to paste</span></li><li><span style="font-family:arial;">Click <strong>Paste</strong> on the <strong>Edit</strong> menu<br /></span></li></ol><p><span style="font-family:arial;"><strong>Microsoft Office Excel 2007</strong><br /></span></p><ol><li><span style="font-family:arial;">Click <strong>Home</strong> tab</span></li><li><span style="font-family:arial;">Click <strong>Copy</strong> command button under <strong>Clipboard</strong> group</span></li><li><span style="font-family:arial;">Select cell to paste</span></li><li><span style="font-family:arial;">Click <strong>Paste</strong> command button under <strong>Clipboard</strong> group<br /><br /></span><span style="font-family:arial;"><a href="http://1.bp.blogspot.com/_lX611N_RlBg/SmROFG427qI/AAAAAAAAACU/GC1S4EsjULc/s1600-h/1.jpg"><img style="WIDTH: 320px; HEIGHT: 237px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360495306133139106" border="0" alt="" src="http://1.bp.blogspot.com/_lX611N_RlBg/SmROFG427qI/AAAAAAAAACU/GC1S4EsjULc/s320/1.jpg" /></a><br /></span><span style="font-family:arial;"><strong></strong></span></li></ol><p><span style="font-family:arial;"></span></p><p><span style="font-family:arial;">When you cut and paste formulas containing relative references, the references are not adjusted.<br /></p></span><br /><span style="font-family:arial;"><strong>Microsoft Office Excel 2003</strong><br /></span><br /><ol><li><span style="font-family:arial;">Select cell with formula</span></li><li><span style="font-family:arial;">Click <strong>Cut</strong> on the <strong>Edit</strong> menu</span></li><li><span style="font-family:arial;">Select cell to paste</span></li><li><span style="font-family:arial;">Click <strong>Paste</strong> on the <strong>Edit</strong> menu<br /></span></li></ol><p><span style="font-family:arial;"><strong>Microsoft Office Excel 2007</strong></span></p><ol><li><span style="font-family:arial;">Click <strong>Home</strong> tab</span></li><li><span style="font-family:arial;">Click <strong>Cut</strong> command button under <strong>Clipboard</strong> group</span></li><li><span style="font-family:arial;">Select cell to paste</span></li><li><span style="font-family:arial;">Click <strong>Paste</strong> command button under <strong>Clipboard</strong> group<br /><br /></span><a href="http://4.bp.blogspot.com/_lX611N_RlBg/SmROFhgPOOI/AAAAAAAAACc/PRBKChFkTiA/s1600-h/2.jpg"><img style="WIDTH: 320px; HEIGHT: 227px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360495313277630690" border="0" alt="" src="http://4.bp.blogspot.com/_lX611N_RlBg/SmROFhgPOOI/AAAAAAAAACc/PRBKChFkTiA/s320/2.jpg" /></a><br /><br /></li></ol><p><span style="font-family:arial;"><strong>- Siti Suriani</strong></span></p><br /><br /><br /><p><br /><span style="font-family:arial;"></span></p></span>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0tag:blogger.com,1999:blog-2026871939246194076.post-49615301101819762462009-07-20T01:42:00.001-07:002009-07-20T04:12:18.193-07:00Excel Tips - If Colored areas on your worksheet do not print well<span style="font-family:arial;"><em></em></span><span xmlns=""><strong><span style="font-family:arial;">Microsoft Office Excel 2003<br /></span></strong><ol><li><span style="font-family:arial;">Click <strong>Page Setup</strong> on the File menu</span></li><li><span style="font-family:arial;">Click the <strong>Sheet</strong> tab</span></li><li><span style="font-family:arial;">Select the <strong>Black and White</strong> check box under <strong>Print</strong> category<br /></span></li></ol><p><strong><span style="font-family:arial;">Microsoft Office Excel 2007<br /></span></strong></p><ol><li><span style="font-family:arial;">Click <strong>Page Layout</strong> tab</span></li><li><span style="font-family:arial;">Click <strong>Page Setup</strong> dialog box launcher button</span></li><li><span style="font-family:arial;">Click the <strong>Sheet</strong> tab</span></li><li><span style="font-family:arial;">Select the <strong>Black and White</strong> box under <strong>Print</strong> category<br /><br /></span><a href="http://2.bp.blogspot.com/_lX611N_RlBg/SmQwuMAfSII/AAAAAAAAACM/pzO-2ZG7jdw/s1600-h/1.jpg"><span style="font-family:arial;"><img style="WIDTH: 320px; HEIGHT: 250px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5360463026533124226" border="0" alt="" src="http://2.bp.blogspot.com/_lX611N_RlBg/SmQwuMAfSII/AAAAAAAAACM/pzO-2ZG7jdw/s320/1.jpg" /></span></a></li></ol><p><span style="font-family:arial;"><strong>- Siti Suriani</strong></span></p></span>MS Office Tips & Trickshttp://www.blogger.com/profile/15386809267141093229noreply@blogger.com0