Path Overview

Who needs Microsoft Office? EVERYONE! PowerPoint is the industry standard for presentations, Excel is the standard for spreadsheet data, and there are a billion Word users worldwide!

Proficiency in Microsoft Office increases the odds of gaining employment in an office environment and increases salary potential by 22% according to the Bureau of Labor Statistics. And the best way to prove your proficiency is to earn a nationally recognized certification!

Our Microsoft Office courses use the 2013 interface, but they are designed to fully prep you for certifications in Microsoft Office 2013 through Microsoft Office 2019. The differences between the 2013, 2016, and 2019 versions of Microsoft Office are negligible for certification purposes.

In 2020, we will update all of our Microsoft Office courses using the Office 365 interface, but for now be assured that our existing courses will get you ready for certification regardless which version you are using.

Lesson Images

Course Information

CERTIFICATION PATHS

Microsoft Northstar Certifications
  • Microsoft Word (Module 1)
  • Certification: Northstar Word
  • Microsoft PowerPoint (Module 1)
  • Certification: Northstar PowerPoint
  • Microsoft Excel (Module 1)
  • Certification: Northstar Excel
Microsoft Office Specialist (MOS)
  • Microsoft Word (Module 1)
  • Microsoft Word (Module 2)
  • Microsoft Word (Module 3)
  • Cert: Microsoft Office Specialist in Word
  • Microsoft PowerPoint (Module 1)
  • Microsoft PowerPoint (Module 2)
  • Microsoft PowerPoint (Module 3)
  • Cert: Microsoft Office Specialist in PowerPoint
  • Microsoft Excel (Module 1)
  • Microsoft Excel (Module 2)
  • Microsoft Excel (Module 3)
  • Cert: Microsoft Office Specialist in Excel

CERTIFICATION INSTRUCTIONS

Northstar Microsoft Certifications

Once you complete the first module of Word, PowerPoint, or Excel, you will need to practice all of the skills covered in the module until you feel proficient at each skill. Once you feel proficient, you will be ready to earn a Northstar Microsoft certification. All Northstar digital assessments are free. You can take the assessment at one of our labs, or you can click the link below to access the Northstar assessments online.

Northstar Digital Literacy Assessments 

Microsoft Office Specialist (MOS)

The MOS certification is a higher level credential. We will teach you every skill you need to pass the MOS certification exam, but you won’t be ready to take the exam until you have spent a bit of time practicing those skills in the software. You can access a free trial of each Microsoft Office program by visiting the link below.

Office.com

We strongly suggest you purchase a companion book from the MOS Study Guide Series so that you have a second bank of exercises to practice the skills covered in this course.

Once you feel you are proficient in all of the skills covered in all three modules, you will be ready to earn a Microsoft Office Specialist (MOS) certification at one of our labs or another Certiport testing center. You can find the testing center nearest you and purchase practice exams and exam vouchers on the Certiport website. Exam fees are paid directly to Certiport. Click the link below to explore the site.

Certiport.pearsonvue.com

LESSON TITLES

Microsoft Word – Module 1
  • Lesson 1: Getting Started
  • Lesson 2: Your First Document
  • Lesson 3: Customizing the Interface
  • Lesson 4: Formatting Text, Part 1
  • Lesson 5: Formatting Test, Part 2
  • Lesson 6: Working with Paragraphs
  • Lesson 7: Formatting Page
  • Lesson 8: Inserting Art & Objects, Part 1
  • Lesson 9: Inserting Art & Objects, Part 2
  • Lesson 10: The Finishing Touches
  • Lesson 11: Viewing Your Document
  • Lesson 12: Printing & Sharing Your Document
Microsoft Word – Module 2
  • Lesson 1: Creating Templates
  • Lesson 2: Working with Styles
  • Lesson 3: Commenting on Documents
  • Lesson 4: Reviewing Documents
  • Lesson 5: Reviewer Settings
  • Lesson 6: Multiple Documents
  • Lesson 7: Using Mail Merge
  • Lesson 8: Creating Outlines
  • Lesson 9: Table of Contents
  • Lesson 10: Creating an Index
  • Lesson 11: Creating References
  • Lesson 12: Using Macros
Microsoft Word – Module 3
  • Lesson 1: Creating a Bibliography
  • Lesson 2: Linking to Other Documents
  • Lesson 3: Creating XML Forms
  • Lesson 4: Blogging with Word
  • Lesson 5: Embedding Objects
  • Lesson 6: Working with Sections
  • Lesson 7: Building Blocks & Quick Parts
  • Lesson 8: Changing Your Styles
  • Lesson 9: Doing More with Styles
  • Lesson 10: Working with SmartArt
  • Lesson 11: Working with Equations
  • Lesson 12: Advanced Macro Tasks
Microsoft PowerPoint – Module 1
  • Lesson 1: PowerPoint Basics
  • Lesson 2: Your First Presentation
  • Lesson 3: Creating Slides
  • Lesson 4: Formatting Text
  • Lesson 5: Working with Text
  • Lesson 6: Formatting the Presentation
  • Lesson 7: Inserting Art & Objects Part 1
  • Lesson 8: Inserting Art & Objects Part 2
  • Lesson 9: Animations & Transitions
  • Lesson 10: Viewing & Printing Your Presentation
  • Lesson 11: Saving & Sharing Your Presentation
  • Lesson 12: Customizing the Interface
Microsoft PowerPoint – Module 2
  • Lesson 1: Using Master Slides Part 1
  • Lesson 2: Using Master Slides Part 2
  • Lesson 3: Working with Templates
  • Lesson 4: Using Handout Masters
  • Lesson 5: Using Notes Masters
  • Lesson 6: Working with Comments
  • Lesson 7: Reviewing a Presentation
  • Lesson 8: Advanced Animation Techniques 1
  • Lesson 9: Advanced Animation Techniques 2
  • Lesson 10: Advanced Presentation Techniques
  • Lesson 11: Creating a Custom Show
  • Lesson 12: Managing PowerPoint Files
Microsoft PowerPoint – Module 3
  • Lesson 1: Doing More with Shapes
  • Lesson 2: Embedding Objects
  • Lesson 3: Linking Objects
  • Lesson 4: Action Buttons I
  • Lesson 5: Action Buttons 2
  • Lesson 6: Inserting & Editing Videos
  • Lesson 7: Playing Video Files
  • Lesson 8: Protecting Presentations
  • Lesson 9: Checking Compatibility
  • Lesson 10: Setting Up Your Show
  • Lesson 11: Creating Macros
  • Lesson 12: Managing Add-Ins
Microsoft Excel – Module 1
  • Lesson 1: Excel 2013 Basics
  • Lesson 2: Your First Workbook
  • Lesson 3: Working with Data
  • Lesson 4: Customizing the Interface
  • Lesson 5: Using Basic Excel Tools
  • Lesson 6: Using Timesaving Tools
  • Lesson 7: Formatting Text
  • Lesson 8: Formatting Data
  • Lesson 9: Formatting the Workbook
  • Lesson 10: Inserting Art & Objects
  • Lesson 11: Charting Data
  • Lesson 12: View, Print, & Share Workbooks
Microsoft Excel – Module 2
  • Lesson 1: Advanced Formula Tasks
  • Lesson 2: Working with Named Ranges
  • Lesson 3: Using Advanced Functions
  • Lesson 4: Resolving Formula Errors
  • Lesson 5: Managing Data
  • Lesson 6: Outlining & Grouping Data
  • Lesson 7: Working with Scenarios
  • Lesson 8: Using Solver
  • Lesson 9: Analyzing Data
  • Lesson 10: Advanced PivotTable Features
  • Lesson 11: Using PowerPoint
  • Lesson 12: Using Macros
Microsoft Excel – Module 3
  • Lesson 1: Conditional Formatting
  • Lesson 2: Working with Slicers
  • Lesson 3: Using the Inquire Add-In
  • Lesson 4: Working with Tables
  • Lesson 5: Records & Fields
  • Lesson 6: Using Excel as a Database
  • Lesson 7: Using Custom AutoFill Lists
  • Lesson 8: Using Comments
  • Lesson 9: Tracking Changes
  • Lesson 10: Combining Data

 

This site uses cookies in order to improve your experience and to provide content tailored specifically to you. Detailed information on the use of cookies on this site is provided in our Cookie Policy. You can also manage your preferences there. By using this site, you consent to the use of cookies.