Microsoft Office Specialist Certificate

Excel, Introduction

Learn how to create effective and efficient worksheets using formulas, common functions, formatting and printing.

Excel, Intermediate

Learn specialized functions, like IF, COUNTIF, and DSUM and how to effectively analyze, sort, filter data, create outlines, subtotals, range names, and work with tables. Display data more visually in charts, Pivot tables and charts and work with slicers and templates.

Word, Introduction

Learn everything you need to get started creating and editing documents, formatting, proofing, controlling page setup, and more.

Word, Intermediate

Enhance your proficiency with Word using tables, styles, templates, section breaks, and columns. Long document features such as table of contents, indexes, and mail merge are also covered in this course.

Word, Advanced

Create top-notch documents using forms, sharing documents, and document revisions. Work with custom graphic elements, bookmarks, footnotes, and macros.

Excel, Advanced

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends.

PowerPoint, Introduction

Your presentations can be showstopping. Create slide shows using PowerPoint's most commonly used features.

PowerPoint, Advanced

Import from other applications, create photo albums, share presentations, and create templates. Use multimedia effects including sound and video to produce professional, effective presentations.

Access, Introduction

Take away the mystery of database design in Access by creating, designing, and editing tables. Learn to create simple queries and filters and develop the skills to design simple forms and reports.

Access, Intermediate

Learn about database normalization, relationships, referential integrity, and analyzing tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and finding unmatched or duplicate records. Learn to create advanced reports with calculated fields and enhanced control formatting and data bars.

Access, Advanced

Learn more advanced form design with sub-forms, tab pages, and navigation forms. Import, export, and link external data and perform a Word mail merge with Access data. Learn how to have a more turnkey database with macros, VBA programming, and switchboards. Learn about database management topics like dependencies, documenting, compacting, repairing, splitting, security, and converting into ACCDE.

Outlook, Introduction

Make the most of your email communications. Learn to work with contacts and distribution lists. Find out how Outlook tasks can help with organization, and use the Outlook calendar to keep up with your busy schedule.

Outlook, Advanced

Take your Outlook skills to the next level. Learn how to customize Outlook, automate commonly used actions, work with folders, organize Outlook components, and use the Rules Wizard.