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 Office
  • Microsoft Word (Module 1)
  • Certification: Northstar Word
  • Microsoft PowerPoint (Module 1)
  • Certification: Northstar PowerPoint
  • Microsoft Excel (Module 1)
  • Certification: Northstar Excel
  • 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

Once you complete the first module of Word, PowerPoint, or Excel, you will be ready to earn an online Northstar certification. All Northstar digital assessments are free. Click the link below to access the Northstar assessments.

Northstar Digital Literacy Assessments 

Once you complete all three modules of a Microsoft Course, you will be ready to earn a Microsoft Office Specialist (MOS) certification at a Certiport test site. The exam fee is paid to the test provider. Click the link below to find a Certiport testing center near you.

Certiport Test Site Locator

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.