In Getting the Most From Microsoft® Office, you'll learn...
- Formatting documents using Word as a personal desktop publisher
- How to create and design a sophisticated PowerPoint® presentation
- Secrets to calculating and charting data in Microsoft® Excel®—never before has spreadsheet creation been so easy
- How to use Microsoft Access® to store, manage and retrieve your crucial data records
- And much more
This workshop goes beyond the basics to boost your productivity in all four of Office’s primary applications: Word, Access, PowerPoint and Excel. Learn how to use Office’s features, functions and enhancements … and discover how to send your work directly to the Web and your corporate intranet.
WORKSHOP AGENDA
Click on a session title to view details
Microsoft® Word essentials+
- The fundamentals of operating Word
- A complete guided tour of the elements of the Word screen
- What’s new with the Ribbon Interface
- How to create your own customized Quick Access Toolbar
- Using Quick Styles and Document Themes to create and format paragraphs
- Navigating through dialog box options
Editing features and techniques in Word+
- How to use the Merge Document feature to incorporate reviewers’ comments into the original document in a single step
- Using the Reviewing options to track and review changes
- How to use multiple versioning to keep an automated history of a document’s changes—who made them and when
- How to customize Microsoft Word using the Word Options button
Working with Word documents+
- How to navigate through long documents by using the Outline, Draft and Web Layout views
- Using the OLE enhancements
- How to create Comments (Office’s version of sticky notes) for yourself or other readers
- Understanding hyperlinks and hyperlinked cross-references
- How to prevent changes by making the document read-only and using the Mark as Final command
Formatting documents using Word as a personal desktop publisher+
- An overview of formatting fundamentals: Italics, boldface, indents, tabs, line spacing and more
- Applying border styles and placing headers and footers within border areas
- Using bulleted and numbered lists for more reader-friendly documents
- Capitalizing on Word’s array of sophisticated drawing and multimedia tools to create stunning text and graphics
Outputting your Word documents+
- An overview of all the options available for printing or sending your documents
- How to publish a document as a PDF format
- How to prepare your documents for publication on the Internet or your organization’s intranet
Advanced features and functions in Word+
- How to use the Mail Merge feature to personalize your form letters and other documents
- Taking advantage of macros to automate routine tasks
- Using the free-form table drawing tool to create tables to your exact specifications
Microsoft® PowerPoint® essentials+
- An overview of the fundamental features that make PowerPoint go
- 3 ways to begin a new presentation
- Becoming familiar with the PowerPoint screen elements, including the ribbons and menu options
- How to quickly switch among various slide views using keystrokes
- Using the templates to provide a starting point using PowerPoint’s predesigned content
- Design template options with animation already built in
PowerPoint editing techniques+
- Editing fundamentals: Backspace, delete, copy and paste and beyond
- How to create, select and move a text box to add text to a slide
- The steps for editing the Slide Master so you can copy your new format into each of your slides
- How to change text alignment, line spacing and indents—and see your changes in Live Preview
- Adding Comments without changing the content of the slide itself
- How to edit speaker notes while in the Slide and Outline views
Working with PowerPoint slides+
- Putting PowerPoint’s powerful slide management features to work
- How to use the Reuse Slide command to preview and add slides from other presentations
- How to rearrange the order of slides … select, cut, copy and paste slides … hide and delete slides … and more
- Creating customized offshoot presentations from an original
Formatting techniques that give your PowerPoint presentation a professional look+
- How to use design templates and Quick Styles
- Formatting basics: Creating columns, choosing bullet types, copying text formats, changing the font color and changing the color and weight of lines and borders
- Choosing color schemes and background designs
- How to add color, shape and emphasis to your text and data with SmartArt® graphics
- Adding pictures, charts, graphs—including how to rotate, resize and crop pictures
- Adding sound and video to your presentation—and setting the timing of audio and video clips
- How to add voice narration so a narrator doesn’t have to be present during audience viewing
Viewing and outputting your PowerPoint presentation+
- How to view an on-screen slide show
- Adding action buttons to slides and changing Slide Setup
- Printing presentations, notes and handouts, including designating which part of your presentation to print—and in which form
- 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
Advanced features and functions in PowerPoint+
- How to insert Word tables, Excel® worksheets and charts and create hyperlinks in your presentation
- How to keep Ink Annotations to record the activities and key points of meetings
- How to integrate Web site graphics and presentation sounds into your local PowerPoint presentation
Microsoft® Excel® essentials+
- The quickest way to integrate Excel’s four independent elements—cells, ranges, sheets and workbooks
- How to cut through clunky mouse clicks and movements and use CTRL, SHIFT and the space bar instead
- How to save your workbook back to a network file all at once
- Creating custom views
- The Trust Center: The latest in security to protect your documents
Editing and formula building in Excel+
- An overview of Excel’s mathematical formulas
- 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
- Using the power of Format Painter to carry out your custom formats everywhere with just a couple of clicks
- 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
- Uncovering the secrets of AutoComplete, AutoCorrect, AutoFill, AutoFilter and Auto Outline
Working with Excel workbooks and templates+
- How to use templates to get started quickly
- How to move through workbook creation—and jump between workbooks and applications—using powerful combinations of keystrokes and mouse clicks
- How to use URLs and UNCs to open workbooks across the Web
- Connecting OLE elements from Word and PowerPoint®
- Integrating Access® information into a workbook and integrating workbook information into Access
Excel formatting techniques that give your financial presentations flair+
- Excel’s enhancements such as sound, color, multiple fonts and formats within a text string
- How to indent text within a cell
- How to adjust row and column heights to match presentation needs
- Changing the orientation and alignment of text with the click of a button
Excel outputting features abound+
- How to use Page Layout View to speed up your layout and printing process
- Outputting Excel to a Web page using the Save As HTML command
- The steps to follow to install the PDF add-in and to save a file as a PDF
Advanced Excel features+
- How to use many of Excel’s advanced features like creating a Data Entry Form, timed updates and personal views of shared workbooks
- How to create sequential commenting when building shared workbooks
- Shorthand tricks using Excel’s AutoCorrect
- How to determine if others have made changes to your documents
Microsoft® Access® database design and creation+
- The quick steps for creating the right database designs the first time
- How to quickly undo and modify a database in just a couple of keystrokes
- RDBS design—how to use multiple tables to expedite your database design
- Using the Table Templates to get started when you’re staring at a blank screen
Creating Access forms and reports+
- The fundamentals of form creation and using the Form Wizard to push your form designs to the limit
- Using controls to make your forms user-friendly
- The different methods for protecting your forms from a novice or inexperienced user
- How to produce reports using the built-in Reports Wizard
Exporting and importing information in Access+
- The essential steps you need for exporting to Word, Excel or the Web
- The tricks that make database conversion and integration from an SQL server a snap
- A demonstration of the multiple export and import options available in Access
- How Access’s tight integration with Excel allows you to send data back and forth between the programs with just a couple of mouse clicks
Advanced Access features+
- The different ways HTML can be manipulated using the Import HTML and Link HTML Wizards
- How to export a database object to and from an FTP server on the Internet
- How to attach hyperlinks to forms and reports
- Integrating your data with other applications using built-in OLE features and the Network OLE
