GETTING THE MOST FROM MICROSOFT® OFFICE

In this seminar you'll learn...

The latest version of this popular word processing powerhouse comes feature-loaded and with even more enhancements for generating professionally rendered business documents and collaborating on projects with others. In this workshop, you´ll discover built-in shortcuts for taking advantage of Word´s document-centric approach, so you can focus on producing your projects instead of the "how-to´s" of the program. You´ll learn how to put such power-laden features as the Ribbon User Interface, table drawing tools, text options, Internet hyperlinks, AutoShapes, multiple versioning and page borders to work for you.
This session gets you up and running on the fundamentals of operating Word. You´ll get a complete guided tour of the elements of the Word screen and learn what´s new with the Ribbon Interface. We´ll show you how to create your own customized Quick Access Toolbar. You´ll also learn how to create and format paragraphs using Quick Styles and Document Themes ... and navigate through dialog box options.
Microsoft Word comes with several powerful enhancements for making text changes and automatically incorporating the comments and edits of others who review your documents. Learn how to use the Merge Document feature to incorporate reviewers´ comments into the original document in a single step ... learn how to use the Reviewing options to track and review changes ... use multiple versioning to keep an automated history of a document´s changes, who made them and when ... and find out how to customize Microsoft Word using the Word Options button from the Microsoft Office button.
This session steps you through fundamental document management techniques, such as options for opening, saving and renaming, but also focuses on Word´s advances in document navigation and interconnectivity. You´ll learn how to use the Outline, Draft and Web Layout views to navigate through long documents ... browse by document elements ... use the OLE enhancements ... create Comments (Office´s version of sticky notes) for yourself or other readers ... add hyperlinks that take you directly to other documents and sites on the Web ... use hyperlinked cross-references ... and make the document read-only to prevent changes using the Mark as Final command.
No longer just a word processing tool, Word continues the program´s evolution into a full-featured desktop publisher. In this session, you´ll start out with an overview of formatting fundamentals like applying italics and boldface and setting indents, tabs and line spacing. From there, you´ll move on
Outputting a document used to mean sending it to your local printer. Integrated technology has changed all that—and Word takes full advantage with options for sending your documents to recipients via a variety of methods. In this session, you´ll not only learn all the options available for printing, but also how to publish a document as a PDF format and how to prepare your documents for publication on the Internet or your organization´s intranet.
In this session, you´ll learn how to use many of Word´s advanced features to customize your work. Discover how to use the Mail Merge feature to personalize your form letters and other documents ... how to take advantage of macros to automate routine tasks ... use the free-form table drawing tool to create tables to your exact specifications ... and more.
PowerPoint presentations now pack more of a professional punch than ever, thanks to the even more powerful enhancements built into the latest version. In this workshop, you´ll not only learn PowerPoint´s basic functions, but also how to take advantage of features like voice narration, soundtracks, background styles, special text formatting and other tools for preparing and designing masterful presentations.
In this session, you´ll jump right into an overview of the fundamental features that make PowerPoint go. You´ll learn three ways to begin a new presentation ... become familiar with the PowerPoint screen elements ... learn how to work with the program´s ribbons and menu options ... how to quickly switch among various slide views using keystrokes ... how to save, close and open presentations ... how to use the templates to provide a starting point using PowerPoint´s predesigned content ... and how to choose design templates with animation already built in.
Microsoft Office programs take editing well beyond backspace, delete, copy and paste. In this session, you´ll quickly review editing fundamentals and then advance to more sophisticated techniques. You´ll learn how to create a text box to add text to a slide ... how to select and move text boxes ... learn the steps for editing the Slide Master so you can copy your new format into each of your slides ... change text alignment, line spacing and indents ... see your changes in Live Preview as you move the mouse over a font or color scheme ... add Comments (Office´s version of sticky notes) for other users to read without changing the content of the slide itself ... and how to edit speaker notes while in the Slide and Outline views.
Creating, managing and organizing your presentation´s slides has never been so easy. In this session, you´ll discover how to put PowerPoint´s powerful slide management features to work so you can focus on your presentation. You´ll learn how to use the Reuse Slide command to preview and add slides from other presentations (including those on your organization´s intranet) ... rearrange the order of slides ... select, cut, copy and paste slides ... hide and delete slides ... and create customized offshoot presentations from an original in order to appeal to a variety of audiences.
Today´s multimedia-indulged audiences expect nothing less than "spectacular" from a presentation. In this session, you´ll learn how to pull out all the stops to capture and keep your viewers´ attention. You´ll learn how to use design templates and Quick Styles ... create columns ... choose bullet types ... copy text formats ... change the font color ... add voice narration so a narrator doesn´t have to be present during audience viewing ... add pictures, charts, graphs, sound and video to your presentation ... set the timing of audio and video clips ... rotate and resize objects ... crop pictures ... change the color and weight of lines and borders ... add color, shape and emphasis to your text and data with SmartArt graphics ... choose color schemes and background designs ... and benefit from many more new and enhanced drawing, graphics and multimedia features.
PowerPoint provides multiple options for viewing and outputting your presentation—both during and after its creation. In this session, you´ll get tips for viewing an on-screen slide show ... adding action buttons to slides ... printing presentations, notes and handouts ... changing Slide Setup ... designating which part of your presentation to print—and in which form ... and how to use the Package for CD feature to compress and save your presentation (including all linked and multimedia files) so you can take it on the road or share it with others.
In this session, you´ll learn how to insert Word tables, Excel worksheets and charts and create hyperlinks in your presentation. You´ll also find out how to keep Ink Annotations to record the activities and key points of meetings. In short, you´ll learn numerous techniques for turning your local PowerPoint presentation into a network gala with integrated Web site graphics and presentation sounds.
Microsoft Excel starts where most spreadsheet programs leave off. With its on-the-fly customizability, you can tailor your opening screen to look and feel like your own special version of the program. Excel comes loaded with statistical tools, expanded formula options and integrated graphics for creating financial presentations that include everything from sound and clip art to tilted letters, bubble charts and regional data summarized on maps. You can calculate and chart data in 3-D and embed text and graphics right next to your data. The latest version of Excel pushes the limit on interconnectivity by allowing you to build formulas and merge data from documents on your hard drive, on the Local Area Network and on the Internet. This workshop takes you well past the simple points and clicks of formula manipulation and teaches you need-to-know concepts such as arrays, pivot tables, building databases and more.
Learn the quickest way to integrate Excel´s four independent elements—cells, ranges, sheets and workbooks ... discover how to cut through clunky mouse clicks and movements and use CTRL, SHIFT and the space bar instead ... learn about Excel´s expanded row features—there´s almost no limit: One million rows and 16,000 columns ... find out how to save your workbook back to a network file all at once ... how to create custom views ... and the latest in security to protect your documents using the Trust Center.
The heart of Excel is mathematical formulas ... discover how to create relative, absolute and mixed references ... a powerful shortcut to formula association that allows you to copy a formula without adjusting the relative reference ... how to make multiple selections across several sheets ... the power of Format Painter in carrying out your custom formats everywhere with just a couple of clicks ... indent features that have for the first time been included in Excel ... powerful Cut and Paste features that allow you to move large amounts of data at will ... the 16-step Undo—you´re no longer tied to just four. In addition, uncover the secrets of AutoComplete, AutoCorrect, AutoFill, AutoFilter and Auto Outline ... never before has spreadsheet creation been so easy.
Excel starts at one of two places—New and Open. Learn how to use templates to get started quickly and discover how to move through workbook creation using powerful combinations of keystrokes and mouse clicks. Workbooks are no longer tied just to your computer—they can be integrated throughout an intranet or the Internet. Discover how to use URLs and UNCs to open workbooks across the Web ... the steps to take in connecting OLE elements from Word and PowerPoint® ... integrating Access information into a workbook and integrating workbook information into Access. In addition, you´ll learn how to jump between workbooks and applications using keyboard shortcuts and quick keystroke combinations.
Gone are the days of simple font manipulation and the addition of borders and shading. Excel now offers enhancements such as sound, color, multiple fonts and formats within a text string. Explore Excel´s feature for indenting text within a cell ... learn how to adjust row and column heights to match presentation needs ... change the orientation and alignment of text with the click of a button ... and more.
Everything you create in Excel ends up on a printed page, but that page could ultimately end up on a Web site or elsewhere. Find out how to use Page Layout View to speed up your layout and printing process ... discover the steps to follow when outputting Excel to a Web page using the Save As HTML command ... follow the steps you would use to install the PDF add-in and to save a file as a PDF.
And if what you´ve seen so far isn´t enough, you´ll learn how to use many of Excel´s advanced features like creating a Data Entry Form when the button doesn´t appear on the ribbon, timed updates and personal views of shared workbooks. You´ll also learn how to create sequential commenting when building shared workbooks, discover shorthand tricks using Excel´s AutoCorrect and learn how to determine what changes have been made to a document by others on your team.
Just like every other application in Microsoft Office, Access has been improved and expanded to be even more powerful than before. In this workshop, you´ll venture beyond the basics of tables, queries, forms and reports and explore the custom features you can use to make your Access form HTML-ready and completely compatible with an SQL server database. Access is also designed to serve as a front-end and reporting system to your LAN or mainframe database—learn how to take that million-record Relational Data Base System (RDBS) you have and tap its power to produce the reports you want, when you want them.
Learn quick steps for creating the right database designs the first time—and if you do make a mistake, we´ll show you how to quickly undo and modify a database in just a couple of keystrokes. Save time by learning how to apply the reports and queries from the example Microsoft created for you to your own work. Get underneath the RDBS design and learn how to use multiple tables to expedite your database design. And discover how to use the Table Templates to get started when you´re staring at a blank screen.
In this session, you´ll walk through the fundamentals of form creation and then learn how to use Form Wizard to push your form designs to the limit. Learn the key steps for using controls to make your forms user-friendly. Uncover several methods for protecting your forms from a novice or inexperienced user, including putting form buttons inside of forms. Creating reports is similar to creating forms. This session will show you how to produce reports using the built-in Reports Wizard.
Like most database applications, Access has the ability to both export and import between outside database programs. Get the essential steps you need for exporting to Word, Excel or the Web. Find out the tricks that make database conversion and integration from an SQL server a snap. You´ll also see a demonstration of the multiple export and import options available in Access, including using an HTML page as either a data collection or a data dissemination point. Learn about Access´s tight integration with Excel and how it allows you to send data back and forth between the programs with just a couple of mouse clicks.
In this session, you´ll learn the different ways HTML can be manipulated using the Import HTML and Link HTML Wizards and the steps to follow when exporting a database object to and from an FTP server on the Internet. Find out how to attach hyperlinks to forms and reports and discover how to more closely integrate your data with other applications using built-in OLE features and the Network OLE.

CEU Credits: 1
CPE Credits: 12
Field of Study: Computer Science
NASBA#: 107719