SkillPath Seminars
Call us: 1-866-222-6315

In Microsoft® Office 2007 Basic, participants will 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 crucial data records

This training course goes beyond the basics to boost productivity in all four of Office’s primary applications: Word, Access, PowerPoint and Excel. Participants will learn how to use Office’s features, functions and enhancements … and discover how to send work directly to the Web and a corporate intranet.




    SkillPath Training Information

    SkillPath Enterprise Solutions can bring the following topic to your company: Microsoft® Office 2007 Basic

    Click on the link below for more information. http://www.skillpath.com/index.cfm/on-site/training/topic/Microsoft-Office-Training-2007-Basic



    TRAINING AGENDA

    Click on a 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 a 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)
    • 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 Word documents

    +
    • An overview of all the options available for printing or sending documents
    • How to publish a document as a PDF format
    • How to prepare documents for publication on the Internet or an organization’s intranet

    Advanced features and functions in Word

    +
    • How to use the Mail Merge feature to personalize form letters and other documents
    • Taking advantage of macros to automate routine tasks
    • Using the free-form table drawing tool to create tables to 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 a new format can be used on all slides
    • How to change text alignment, line spacing and indents—and see 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 PowerPoint presentations 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 text and data with SmartArt® graphics
    • Adding pictures, charts, graphs—including how to rotate, resize and crop pictures
    • Adding sound and video to a 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 a 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 a presentation to print—and in which form
    • How to use the Package for CD feature to compress and save a presentation (including all linked and multimedia files) to take it on the road or to share it with others

    Advanced features and functions in PowerPoint

    +
    • How to insert Word tables, Excel worksheets and charts and create hyperlinks into a 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 a 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 a workbook back to a network file all at once
    • Creating custom views
    • The Trust Center: The latest in security to protect 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 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 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 the 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 a document

    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 a database design
    • Using the Table Templates to get started

    Creating Access forms and reports

    +
    • The fundamentals of form creation and using the Form Wizard to push form designs to the limit
    • Using controls to make forms user-friendly
    • The different methods for protecting 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 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 data with other applications using built-in OLE features and the Network OLE