Speak to an advisor602-266-6630

Microsoft Office Training

Microsoft Office Training (MOT) certification is the leading administrative certification in the world. More than 1 million MOT exams are taken every year in over 140 countries.

Demonstrate you have the knowledge, skills, and abilities to productively use Microsoft Office. MOT enables you to tap the full features and functionality of the Microsoft Office system, resulting in heightened levels of individual performance, confidence, and differentiation.

speak to an advisor
Add To Cart

About this Course

Microsoft Office Training with or without Certification

Students will have customized training in the use of Microsoft Word, Excel, PowerPoint, Outlook, and QuickBooks using the most current Microsoft Office Program.  It is a suggested goal of each graduate to type a minimum of 30 wpm with 95% accuracy, and perform 10-Key by touch at a minimum of 6,000 KPH with 95% accuracy, but is not a requirement.

You will have a full understanding of the computer software upon completion of the program.  You will complete your training in 150 hours of classroom time which may be extended for those who are in need of a slower pace.

All students will be trained according to the Certiport Microsoft Office certification standards. The Microsoft certification exams are optional and testing is proctored at the Phoenix campus only.

Completion Requirements:  150 hours of training and passing weekly assessment with an 80% or better.

Course Syllabus

 

Week One

Microsoft Office

Internet and Intro to MOT Word
• Orientation, introduction to terminology usage. Getting familiar with the Internet, creating an email account at Gmail.com, typing practice sites: Learn2type.com, Goodtyping.com and Mavis Beacon. Register with GMetrix for certification practice. Introduction to Microsoft Office Interface, understanding the tabs, ribbon and its commands. Sharing and maintaining documents; generating and properly saving documents; creating and saving templates and folders, and PDF files; arranging windows; importing files into Word. Study MOT terminology.

Formatting Contents
•Formatting the content of Word documents and applying font styles, sizes, and text effects. Arranging document content using bullets and numbering, paragraph spacing, tabs, and the Outline View. Modify styles for paragraphs and create new ones. Begin to write business letters as well as putting together labels and envelopes. Formatting a letter, proofreading an incorrect letter, correcting it, and emailing to instructor as an attachment.

Applying Page Layout and Reusable Content
•Create and format tables using formatting and design tools. Use these skills to design tables and understand the text flow and placement within table cells. Using and modifying formulas in tables. Insert document page and section breaks; insert page numbers, date and time, watermarks, page color and borders. Create and apply custom themes. Use Building Blocks to create Quick Part to add to a document.

Illustrations and Graphics in a Document
Inserting Illustrations and Graphics and using the ribbon commands for manipulating and formatting purposes. Inserting Shapes, SmartArt, WordArt, and Text Boxes as well as linking Text Boxes.

Week Two

Proofreading Documents
•Proofreading documents using Spell Check and AutoCorrect. Inserting Comments and printing documents. Review of the week using practice sheets and the training mode of GMetrix.

Applying References and Hyperlinks
•Apply References which include Captions, Hyperlinks, Footnotes, Table of Contents, Cover page, Bookmarks, Citations and Bibliographies, Indices, and Table of Authorities. Practice using Track Changes and recording and applying a Macro.

Performing Mail Merge Operations
•Create a database to perform mail merge operations including letters, labels, and envelopes.

Prepare for end of Microsoft Office Word
•Review and become more familiar with all tabs, groups, and icons. Continue with more review assignments.

Week Three

Review of Microsoft Office Word
•Terminology Assessment and Word Assessment.

Introduction to Microsoft Office Excel
•Getting familiar with Excel Interface. Understanding the ribbon commands. Introduction to Excel Terminology. Using rows and columns on a spreadsheet and applying data. Entering and moving data, deleting and clearing cells. Copying and moving data. Entering text and numbers; dates and times. Printing Worksheets. Applying protection to workbooks and worksheets.

Create Cell Data
•Creating cell data—cutting and pasting; inserting and deleting rows and columns; adjusting column width and row height; using Autofill and hyperlinks.

Formatting Cells and Worksheets
•Formatting Cells and Worksheets to include setting print titles, ordering data to appear in a cell, add a total row to a table, modify a theme, create a new cell style, conditional formatting, transpose, text to columns, and removing duplicate rows.

Week Four

Managing Worksheets and Workbooks
•Learning to manage worksheets and workbooks. Workbook views, embedding an object into a worksheet, creating an outline.

Applying Formulas and Usage of Functions
•Applying formulas and usage of functions. Hands-on practice using AutoSum, inserting functions including the IF Function, understanding relevant and absolute cell references, referencing cells in other worksheets, named ranges, formula auditing, the subtotal function, conditional summary functions, text functions, and data validation.

Presenting Data Visually
•Creating column charts and a pie chart using the chart ribbons for formatting. Creating Sparklines, using the Quick Analysis Tool; inserting Watermarks.

Sharing Worksheet Data
•Sharing worksheet data with other users regarding comments, importing and exporting data workbook properties, and sharing workbooks.

Week Five

Analyzing and Organizing Data
•Analyzing and organizing data. Creating a Macro in Excel. Creating a Half-year Budget of expenses based on true figures. Creating a spreadsheet with information gathered from the Internet to develop a business from the ground floor. Internet search price comparisons. Forming a Mailing List and sorting and filtering the data.

Analyzing and Organizing Data
•Using financial and Lookup Functions in Excel. Create checkbook, payroll, and bowling league spreadsheets.

Continued practice using added review sheets. Review of Microsoft Office Excel

•Using Excel Pivot Tables to manipulate and view data. Terminology Assessment and Excel Assessment.

Introduction to Microsoft Office Outlook
•Microsoft Office Outlook. Getting familiar with the Outlook Ribbon, Quick Access Toolbar, the Peeks and To Do Bar.

Learning to create and manage Email messages; stationery; email attachments; reading and forwarding messages. Managing the Calendar, Contacts, Tasks, and Notes.

Week Six

Continue with Outlook and Begin PowerPoint
•Scheduling Appointments and Tasks from a list onto the Outlook calendar. Beginning with PowerPoint and creating a PowerPoint Show using the small business assignment.

Inserting Illustrations into the PowerPoint
•Working with graphical elements in PowerPoint and applying Transitions and Animations. Preparing a PowerPoint Presentation as a Show.

MOT Final Assessment

Week Seven

GMetrix Practice
Prepare for Certification Testing

GMetrix Practice
Prepare for Certification Testing

GMetrix Practice
Prepare for Certification Testing

GMetrix Practice
Prepare for Certification Testing

Week Seven and a half

GMetrix Practice/Certification
Prepare for Certification Testing

Graduation
Create a final business letter. Distribution of Certificates of Completion.