Microsoft Office Certifications

Microsoft Office
This course covers the key differences between Office and earlier versions of Office. The most obvious change, from menu bars and tool bars to the new Ribbon concept, is presented first so participants become accustomed to the new interface. Emphasis is placed on backward and forward compatibility with previous versions of Office. Feature changes to the Office system as a whole are covered next, focusing on new features present in most of the individual programs in the Office Suite. Finally, each major program (Word, Excel, PowerPoint, Access, and Outlook) is featured with coverage in three main areas: what's new, what's changed, and coping with what's been removed.


ACCESS

Microsoft Access Level 1
Learn how Microsoft's powerful and award-winning database can help you manage, store, search, analyze, and display important information you've collected about your business, home, community, or any other entity. In this practical and project oriented hands-on workshop, you'll learn how to create tables filled with fields and records. You'll build relationships between the tables to eliminate redundancies and slash data entry time. You'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. You'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros.


EXCEL

Microsoft Excel Level 1
Introduction to Excel focuses on basis concepts. You will create and edit spreadsheets by entering data, formatting the data, and using formulas to do automatic calculations. You will also learn to enhance your spreadsheets with charting tools to present the data in line graphs, pie charts, bar charts, and more. The workshop assumes participants understand how to use a mouse and drop-down menus, save files to some type of storage media, and perform other basic skills required to run Windows programs.

Microsoft Excel Level 2
Design and format more effective worksheets. Save time with your regular tasks by creating efficient workbooks with links between worksheets and files. You will learn how to format, use Office templates and create custom templates, worksheet protection, and use linked formulas. You will also create hyperlinks to areas within the workbook and to other documents. Textbook is included.

Microsoft Excel Level 1 and 2
This course is designed to provide information to prepare students for the Microsoft Certified Application Specialist Excel exam.

Microsoft Excel Level 3
The primary objective of this course is to broaden a user's knowledge of Microsoft Office Excel. Key skills learned in this course will be performing advanced tasks, such as creating nested functions, working with data tables, exporting and importing data, performing what-if analysis, and recording macros.


POWERPOINT & OUTLOOK

PowerPoint and Outlook
Provides hands-on experience and familiarizes students with specific design and layout techniques and practical applications of business presentations along with experience working with Outlook menus and toolbars.


PROJECT

Microsoft Project Level 1
Discover how to effectively plan, implement, and control projects using Microsoft Project. In this hands-on course, you'll learn how to apply the world's most popular project management software to your needs.

  1. Creation of scheduling
  2. Project sharing
  3. Increased software skills of employees

WORD

Microsoft Word Level 1
A must for computer beginners looking to update skills for the modern workplace. Create, edit, and print documents such as letters or reports using the newest version of this popular word processing program. Participants will learn important terms, editing functions, formatting, special text options, and mail merge. The course also covers spell checking, underlining, bolding, centering text, copying and pasting text, and printing documents. Textbook is included.

Microsoft Word Level 2
Microsoft Word is a powerful and popular program, yet most people use only a fraction of its features. In this course, you'll learn Microsoft Word's more advanced features, which can make writing easier, faster, and more fun. You'll improve your creativity and efficiency at the same time! In the first part of the course, you'll see how to perform a mail merge, and we'll explore macros, styles, and templates. Macros let you type repetitive words and phrases quickly and accurately at the touch of a button. Styles let you save text formatting.

Templates let you create documents that contain predefined formatting and text, making it a snap to create documents that look right every time. In the second part of the course, we'll cover how to use Word as a simple desktop publishing program to create signs, flyers, menus, brochures, and even newsletters. You'll learn how to insert different types of graphics in a document including digital photographs from your own camera, clip art images provided by Microsoft, and different types of charts such as bar, line, or pie charts. Next, you'll find out how to wrap text around graphic images and divide a page into columns and text boxes. Both columns and text boxes give you different ways to display text beyond the traditional appearance of text that fills an entire page.

Finally, in the last part of this course, you'll learn about printing labels, making form letters, and creating an index, table of contents, and list of figures automatically. If you need to create long documents, you'll appreciate Word's ability to keep track of page numbers for your chapter headings or index entries. Whether you need to produce a short letter, flyer, report, or book-length manuscript, this course will teach you how to get the most out of Microsoft Word.

[an error occurred while processing this directive]

[an error occurred while processing this directive]