Microsoft® Office®

 

We specialize in the most popular and widely used applications in today's work place. Our certified instructors’ help clients get the most out of their software investment through hands-on, instructor led training. A complete mastery of your applications as they relate to vital business needs will lay the foundation of efficiency and productivity necessary to keep your organization growing and profitable for years to come.

Our trainers will help you discover the many new useful features in Microsoft Office.  You will learn topics such as:

Finding and using the features you need with ease. The new and more intuitive look and feel of Office Professional helps you use the software features you need easier and faster. Task-based menus and toolbars are automatically displayed based on the feature you are using.

Microsoft Office Excel:  Analyze your information to make better decisions.  Microsoft Office Excel includes tools that help you more effectively filter, sort, graph, and visualize your business information. The new collection of predefined styles, Microsoft Office art, and integrated graphics in Office Excel help you quickly apply a consistently professional look to your spreadsheets. For more advanced analysis, improved PivotTable and PivotChart views are now much easier to create.

Microsoft Office Outlook: Locating, managing, prioritizing, and act on an increasing volume of e-mail.  The new category coloring feature in Microsoft Office Outlook helps you more easily sort and manage e-mail messages. Advanced Instant Search capabilities speed your search for critical information. Improved junk mail and anti-phishing technologies help you filter out unwanted e-mail and manage the messages that matter.

Microsoft Office Project:  Microsoft Project Professional delivers a project management system with powerful, visually enhanced ways to effectively manage a wide range of projects and programs. From meeting crucial deadlines to selecting the right resources and empowering your teams, Project Professional helps project management professionals by offering easier and more intuitive experiences to be more productive and realize amazing results.

Microsoft Office PowerPoint: In Microsoft Office PowerPoint, an extensive library of customizable slide layouts and new tools help you create powerful charts, diagrams, and tables. We will teach you how to quickly preview changes to create more dynamic presentations faster. New style capabilities in the Microsoft Office help to ensure a consistent appearance between documents you create in Office Word, Office PowerPoint, and the Microsoft Office

Microsoft Office Publisher:  We will show you how to create, publish, and manage designer-quality publications in-house. Microsoft Office Publisher helps you establish a visual brand identity for your business. You can then easily share design and content elements across all types of projects.  Our trainers walk you through the process of creating and publishing materials for print, e-mail, and Web sites.  We will teach you the new tools and how they work with other Microsoft Office system products to help you distribute your marketing and communications materials.

Microsoft Office Word: Create professional-looking documents and presentations in less time. New Office Word tools, including the new QuickFormats and Live Preview features, help you create more professional Word documents by making it easier to reuse content, apply professional formats, and quickly preview changes.

Microsoft Office Access:  Simplify database creation and reporting.  Microsoft Office Access helps you create new databases easily.  A library of predefined database applications help you track important business information, including assets, expense reports, and customer orders. You will learn to create reports with a single click, and use improved tools to filter, sort, group, and subtotal data.

Exercise Files

Microsoft® Office® Access™

Microsoft® Office® Access™ Level 1

Access 2003 pdf Access 2007 word iconpdf Access 2010 word iconpdf

Course Objective: In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ relational database application.

Target Student: The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

 

Microsoft® Office® Access™ Level 2

Access 2003 pdf Access 2007 word iconpdf Access 2010 word iconpdf

Course Objective: You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ with other applications.

Target Student: The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access can also take this course.

 

Microsoft® Office® Access™ Level 3

Access 2003 pdf Access 2007 word iconpdf Access 2010 word iconpdf

Course Objective: You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance.

Target Student: This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access™, and it is a prerequisite to take more advanced courses in Microsoft® Office Access™

 

Microsoft® Office® Access™ 2007 Level 4

Access 2003 pdf Access 2007 word iconpdf Access 2010 word iconpdf

Course Objective: You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Target Student: This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access™ application, and are interested in learning introductory level administrator skill sets. The course is also for the student who may be working in a web-based environment and may need to adapt Access applications to the environment.

Microsoft® Office® Excel™

Microsoft® Office® Excel™ Level 1

Excel 2003 pdf Excel 2007 word iconpdf Excel 2010 word iconpdf

Course Objective: You will create and edit basic Microsoft® Office Excel® worksheets and workbooks.

Target Student: This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel worksheets.

 

Microsoft® Office® Excel™ Level 2

Excel 2003 pdf Excel 2007 word iconpdf Excel 2010 word iconpdf

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

 

Microsoft® Office® Excel™ Level 3

Excel 2003 pdf Excel 2007 word iconpdf Excel 2010 word iconpdf

Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel®, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

 

Microsoft® Office® Excel™ VBA

Excel 2003 pdf Excel 2007 word iconpdf Excel 2010 word iconpdf

Course Objective: You will use VBA to create macros for automating repetitive tasks in Excel.

Target Student: Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

 

Microsoft® Office® Excel™ New Features

Excel 2007 word iconpdf Excel 2010 word iconpdf

Course Objective: You will be introduced to the new features in Microsoft Office Excel.

Target Student: This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel and who have upgraded.

 

Microsoft® Office®

Microsoft® Office 2010: Transition from Office 2003 word iconpdf

Course Objective: You will work with the new and updated features of Microsoft Office 2010.

Target Student: Users with prior experience of previous versions of the Microsoft Office suite, who are looking to transition to 2010 and want to know what the new features of Office 2010 are.

Microsoft® Office® Outlook®

Microsoft® Office® Outlook® Level 1

Outlook 2003 pdf Outlook 2007 word iconpdf Outlook 2010 word iconpdf

Course Objective: You will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.

Target Student: This course is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft® Office Outlook® to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. In addition, this course helps prepare students who desire to take the Microsoft Certified Applications Specialist certification for Outlook.

 

Microsoft® Office® Outlook® Level 2

Outlook 2003 pdf Outlook 2007 word iconpdf Outlook 2010 word iconpdf

Course Objective: You will customize your environment, Calendar, and mail messages to meet your specific needs as well as track, share, assign, and quickly locate various Outlook items.

Target Student: This course is designed for experienced Outlook users who need to customize their environment, Calendar, and email messages to meet their specific requirements and who wish to track, share, assign, and locate various Outlook items.

 

Microsoft® Office® Outlook® Level 3

Outlook 2003 pdf Outlook 2007 word iconpdf Outlook 2010 word iconpdf

Course Objective: You will work with the advanced features of Outlook.

Target Student: This course is for persons with an intermediate understanding of Outlook and who need to use Outlook to personalize and organize their email, Outlook items, manage Outlook data files, share and link contacts, create forms, and work offline and remotely.

 

Microsoft® Office® Outlook® New Features

Outlook 2007 word iconpdf Outlook 2010 word iconpdf

Course Objective: You will identify and use the new and enhanced features of Microsoft® Outlook®.

Target Student: The course is for experienced Outlook users familiar with the 2003 version of the application, and who need to learn about the new features that Outlook has to offer.

 

Microsoft® Office® PowerPoint™

Microsoft® Office® PowerPoint™ Level 1

PowerPoint 2003 pdf PowerPoint 2007 word iconpdf PowerPoint 2010 word iconpdf

Course Objective: You will explore the PowerPoint environment and create a new presentation. You will format text on slides to enhance clarity. In order to enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it.

Target Student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft® Office PowerPoint. This course is also intended for students interested in pursuing Microsoft Office Specialist certification in Microsoft® Office PowerPoint

 

Microsoft® Office® PowerPoint™ Level 2

PowerPoint 2003 pdf PowerPoint 2007 word iconpdf PowerPoint 2010 word iconpdf

Course Objective: You will enhance your presentation with features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use the new and enhanced features to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it to authenticate its validity.

Target Student: This course is designed for students who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. This course also assists in the preparation for the Microsoft Office Specialist exam in Microsoft® Office PowerPoint. It is for students who already have knowledge of the basics of PowerPoint, including slide formatting and working with tables, charts, images, objects, and presentation preparation.

 

Microsoft® Office® PowerPoint™ New Features

PowerPoint 2007 word iconpdf PowerPoint 2010 word iconpdf

Course Objective: You will explore the components of the results-oriented interface of the PowerPoint environment and customize the interface to suit your requirements. You will identify and use the new and enhanced features of PowerPoint to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it with a digital signature to authenticate its validity.

Target Student: This course is designed for experienced PowerPoint users who have worked with earlier versions of Microsoft Office PowerPoint and who have upgraded.

 

Microsoft® Office® Project™

Microsoft® Office® Project™ Level 1

Project 2003 pdf Project 2007 word iconpdf Project 2010 word iconpdf

Course Objective: You will create a project plan containing tasks, organize these tasks in a work breakdown structure containing task relationships, create and assign resources, and finalize the project to implement the project plan.

Target Student: This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.

 

Microsoft® Office® Project™ Level 2

Project 2003 pdf Project 2007 word iconpdf Project 2010 word iconpdf

Course Objective: You will exchange project plan data with other applications, update project plans, create visual reports, and reuse project plan information.

Target Student: This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.

 

Microsoft® Office® Publisher™

Microsoft® Office® Publisher™ Level 1

Publisher 2003word icon pdf Publisher 2007 word iconpdf Publisher 2010 word iconpdf

Course Objective: You will create, manage, revise, and distribute publications.

Target Student: This course was designed for persons with a basic understanding of Microsoft Windows and Microsoft Word who need to learn how to use Microsoft® Publisher to create, layout, and edit publications.

 

Microsoft® Office® Visio™

Microsoft® Office® Visio™ Level 1

Visio 2003 pdf Visio 2007 word iconpdf Visio 2010 word iconpdf

Course Objective: You will design and manage basic diagrams, workflows, and flowcharts.

Target Student: This course is designed for persons who have an understanding of basic workflows and the concept of end-to-end flowcharting.

 

Microsoft® Office® Visio™ Level 2

Visio 2003 pdf Visio 2007 word iconpdf Visio 2010 word iconpdf

Course Objective: You will create custom elements and a custom template, represent external data as a drawing, and share your work with others.

Target Student: This course is designed for individuals who have an understanding of the basic workflow and the concept of end-to-end flowcharting.

 

Microsoft® Office® Word™

Microsoft® Office® Word™ Level 1

Word 2003 pdf Word 2007 word iconpdf Word 2010 word iconpdf

Course Objective: You will create, edit, and enhance standard business documents using Microsoft® Office Word.

Target Student: This course is intended for individuals who want to gain basic knowledge of working on Word. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Word can also take this course.

 

Microsoft® Office® Word™ Level 2

Word 2003 pdf Word 2007 word iconpdf Word 2010 word iconpdf

Course Objective: You will create complex documents in Microsoft® Office Word documents and build personalized efficiency tools in Microsoft Word.

Target Student: This course was designed for persons who can create and modify standard business documents in Microsoft Word, and who need to learn how to use Microsoft Word to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft Word.

 

Microsoft® Office® Word™ Level 3

Word 2003 pdf Word 2007 word iconpdf Word 2010 word iconpdf

Course Objective: You will create, manage, revise, and distribute long documents.

Target Student: This course is designed for persons who want to gain skills necessary to manage long documents, collaborate with others, and secure documents. In addition, it will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft® Office Word.

 

Microsoft® Office® Word™ New Features

Word 2007 word iconpdf Word 2010 word iconpdf

Course Objective: You will explore the components of the results-oriented interface of the Word environment and customize the interface to suit your requirements. You will then use the tools available in Word to create documents that look professional and also visually appealing. You will then compare different versions of a document, in addition to finalizing and securing your document before it reaches its target audience.

Target Student: This course is designed for experienced Word users who have worked with earlier versions of Microsoft Office Word and who have upgraded.