EEI Communications

Microsoft Office 2007 Training

Find the right Microsoft Office 2007 Class for you!

 

Whether you are a beginner and new to the Microsoft Office suite, or a proficient user who would like to upgrade your skills to the latest version of the software, EEI Training can help you accomplish your goals. We teach the latest skills, techniques, and software applications. Our instructors are all experts in the fields they teach and are always on the leading edge of new product updates and releases.

 

 

 

Register Now

Which class best suits you?

Word 2007 I

Learn the basic skills necessary to create simple Word documents in this compact, hands-on course. Topics include:

  • Opening and modifying an existing Word file
  • Formatting fonts and paragraphs
  • Creating tables
  • Working with bullets and numbers
  • Changing the appearance of a page (including margins, headers, and footers)
  • Adding pictures to a document

Word 2007 II

In this course, you will learn to be more efficient and proficient with Word, the great workhorse word processing program. Topics include:

  • Creating styles and sections
  • Using newspaper-style layouts
  • Working with charts
  • Creating form letters
  • Adding drop caps and clip art images

Word 2007 III

You will learn to push Word to the edge in this class. At the end of the day, you will know how to –

  • Record, edit, and run macros
  • Create custom toolbars
  • Create online forms
  • Work with master documents and long documents
  • Create a table of contents and index
  • Create cross-references, bookmarks, and footnotes

Excel 2007 I

In this class, you will learn how to create, edit, format, and print basic worksheets in Excel that include absolute and relative formulas. You’ll also learn how to format cells and cell ranges, control pages, work with multiple sheets, and even create charts with professional flair. Topics include:

  • Creating a basic worksheet by entering text and values
  • Working with cells and cell data
  • Performing calculations by using formulas
  • Creating templates
  • Working with multiple worksheets by formatting, repositioning, copying and moving, and adding and deleting worksheets within a workbook
  • Creating and modifying charts
  • Using Excel and user-defined templates
  • Techniques for sorting and filtering data
  • Importing data from Access and exporting to Word

Excel 2007 II

With the skills of Excel I as the foundation, you can now work with more advanced features of Excel and learn how to –

  • Use function and auditing features to create advanced formulas and audit worksheets
  • Use pivot tables and other analysis tools to analyze data
  • Use comments to collaborate with others
  • Customize your workbook by applying conditional formatting, adding data validation criteria, customizing menus and toolbars, creating and editing macros, and grouping and outlining structured data
  • Work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export Excel data into XML, import XML data into Excel, and create a Web query
  • Use multiple graphic objects to enhance your worksheet

PowerPoint 2007 I

If you need to create slides or electronic presentations but have little or no training in PowerPoint, this is the place to start. Topics include:

  • Creating a slide presentation
  • Using an outline file to create presentations
  • Selecting a template, creating a slide master, and saving presentations as templates
  • Creating charts and tables and importing information from other MS Office programs
  • Using the shape tools and other drawing aids
  • Incorporating custom animations into a presentation
  • Arranging slides with the slide sorter
  • Reviewing a slide show and adding comments
  • Saving a slide show as a Web presentation

PowerPoint 2007 II

This is the next logical step if you work with PowerPoint and want to learn more tips and tricks to make this presentation program work even more effectively for you. Topics include:

  • Working with the slide master
  • Editing color schemes of MS templates
  • Fine-tuning alignment of objects
  • Keyboard shortcuts for everyday commands in PowerPoint
  • Customizing graphs in MS Graph
  • Ungrouping and recoloring clip art images
  • Working with images, how to compress, crop, and adjust contrast
  • Techniques to reduce file size of presentations
  • Working with the format painter
  • Comparing and merging presentations
  • Fine-tuning organization charts, AutoShapes, and WordArt objects

Access 2007 I

If you need to learn to perform at least the basic operations of Microsoft Access as part of your day-to-day responsibilities, you should start with this class. You will learn how valuable a relational database program can be in many business applications. Topics include:

  • Database concepts
  • Data management
  • Establishing table relationships
  • Querying the database
  • Designing forms
  • Producing simple reports
  • Planning a database structure
  • Controlling data entry
  • Finding and joining data

Access 2007 II

This course covers intermediate-level operations of Access, such as modifying existing databases and designing complex database structures. Topics include:

  • Improving existing forms
  • Customizing reports
  • Expanding the reach of your data
  • Structuring existing data
  • Writing advanced queries
  • Creating and using macros
  • Adding interaction with macros
  • Making forms more effective
  • Creating a switchboard and setting start-up options
  • Distributing and securing the database

Access 2007 III

Experienced Access users will explore advanced subjects, including:

  • Making your data available on the Web
  • Remote database management
  • Automating business procedures with VBA code
  • Developing a data access page in design view
  • Importing XML data into your database
  • Exporting data in XML format
  • Automating business processes with VBA

Register Now



7240 Parkway Drive, Ste 250
Hanover, MD 21076
Phone: 410-309-8200
Fax: 410-630-3980


Client Locations: Huntsville, AL • Phoenix, AZ • Scottsdale, AZ • Los Angeles, CA • Sacramento, CA • San Diego, CA • San Francisco, CA • San Jose, CA • Boulder, CO • Colorado Springs, CO • Denver, CO • Hartford, CT • Stamford, CT • Washington, DC • Wilmington, DE • Boca Raton, FL • Jacksonville, FL • Miami, FL • Orlando, FL • Tampa, FL • Atlanta, GA • Honolulu, HI • Boise, ID • Chicago, IL • Springfield, IL • Indianapolis, IN • Louisville, KY • New Orleans, LA • Boston, MA • Cambridge, MA • Annapolis, MD • Baltimore, MD • Bethesda, MD • Bowie, MD • Frederick, MD • Germantown, MD • Hunt Valley, MD • Rockville, MD • Silver Spring, MD • Towson, MD • Ann Arbor, MI • Detroit, MI • Minneapolis, MN • Charlotte, NC • Newark, NJ • Princeton, NJ • Trenton, NJ • Albuquerque, NM • Las Vegas, NV • Albany, NY • Buffalo, NY • New York City, NY • Rochester, NY • Syracuse, NY • Cincinnati, OH • Cleveland, OH • Columbus, OH • Philadelphia, PA • Pittsburgh, PA • York, PA • Rapid City, SD • Memphis, TN • Nashville, TN • Austin, TX • Dallas, TX • Fort Worth, TX • Houston, TX • San Antonio, TX • Alexandria, VA • Arlington, VA • Dulles, VA • Fairfax, VA • Herndon, VA • Reston, VA • Richmond, VA • Virginia Beach, VA • Seattle, WA • Milwaukee, WI