Office Skills

Microsoft Skills

Online Training

Which formula should I use? How do I create a chart using my data? Microsoft Excel is a popular spreadsheet program but the vast majority of its users aren’t able to utilize all of its functions.

In this online course, learners will develop a good foundation for using Excel’s many features, including: formulas, data tables, charts and how to format data.

To get the Office Skills Certificate, students will have to complete all fundamental courses plus electives accumulating at least 6 hours of training.

See below to learn about the office courses and certificates offered by NorthWest Skills Institute.

Prerequisites

Course ID
Course Title
Est. Time
STU-1001
Greatest Day Ever
0.6

These courses are a tremendous opportunity for you to learn skills that are needed for employment in growing industries across the country. Your participation in these courses is a unique opportunity for you to set a path for success on your career journey.

By the end of this course, you will be able to

  • Understand the value of this educational opportunity
  • Define the three steps to greatness
  • Explain the importance of certifications

STU-1002
How to Take a Course
0.8

The first page of a course is always the objectives page. The objectives page introduces the course and lists the learning objectives of the course.

This course explains how a course is structured and how you can interact with the course.

By the end of this course, you will be able to

  • Describe the different sections of the screen in a course
  • Understand how to navigate through a course
  • Explain how to use a knowledge check
  • Describe how to use a drag and drop activity
  • Describe how to use an input box activity

STU-1003
How to Navigate the LMS
1

The learning management system (LMS) allows you to easily navigate your online education. Using the LMS, you can access learning paths, study guides, and assessments.

By the end of this course, you will be able to

  • Understand how to use the LMS
  • Explain how to launch a course
  • Describe how to take an assessment

STU-1004
Tips for Succeeding in Online Learning
0.8

An online course is a great way to learn, but it is different from taking a class in a classroom. This course provides tips to help you succeed in an online learning environment.

By the end of this course, you will be able to

  • Set a study schedule
  • List tips for retaining the information you have studied
  • List tips for taking quizzes


Foundational Courses

Course ID
Course Title
Est. Time
MSO-1001
Getting Started with Excel
1.3

Excel is a powerful software tool for organizing and analyzing data. It is widely used by businesses to work with financial data. Before using Excel, you must understand some terminology and the different areas of the Excel screen.

By the end of this course, you will be able to

  • Understand the uses of Excel
  • Define workbook and worksheet
  • Describe the different areas of the Excel screen
  • Define cell and range
  • Identify cell and range addresses
  • List methods for selecting cells and ranges

MSO-1002
Entering Text and Values
1.5

Creating a worksheet begins with entering text and values. The text and values can be any type of data, such as students’ grades, a family budget, customer addresses, sales data, and other financial data.

By the end of this course, you will be able to

  • Explain the difference between text and values
  • List the data entry process
  • Describe how Excel handles leading and trailing zeros
  • Edit data
  • Delete data
  • Explain how to use Undo and Redo
  • Move data
  • Copy data
  • List common keyboard shortcuts
  • Describe how to use Flash Fill, AutoComplete, and AutoFill to enter data

MSO-1003
Formatting Data
1.8

Various formatting commands built into Excel enable you to change the look of your worksheet and make important data stand out. Formatting can be applied to single cells or to a range of cells either before or after you enter your data.

By the end of this course, you will be able to

  • Define formatting
  • Describe the process for formatting text and values
  • Change the column width or row height
  • Explain the purpose of specific formatting options
  • Describe what happens to cells when data is deleted
  • Discuss how to clear formatting
  • Define cell styles and themes
  • Explain what happens when you use Format Painter and F4


Fundamental Courses

Course ID
Course Title
Est. Time
MSO-1004
Formulas and Functions
1.7

Formulas and functions enable you to perform calculations on a worksheet. Excel can perform simple calculations, such as summing a column of numbers, or very complex calculations such as calculating financial, statistical or engineering information.

By the end of this course, you will be able to

  • Define formula and function
  • List the mathematical operators used in Excel
  • Explain how references to cells or ranges are used in formulas and functions
  • Use the Sum and Average functions
  • Use the AutoSum command
  • Understand how to copy formulas and functions
  • Explain relative and absolute cell references
  • Understand how to move formulas and functions
  • Describe methods for troubleshooting formulas and functions

MSO-1006
Working with Data Tables
1.3

Excel enables you to enter dates and times on your worksheet, format them, and use them in calculations like other values. However, there are some rules and limitations you must be aware of so that any calculation using dates and times is accurate.

By the end of this course, you will be able to

  • List uses for dates and times in a worksheet
  • Explain the serial numbers Excel uses to create dates and times
  • Enter dates and times in valid formats
  • Explain how to use the Today and Now functions
  • Use keyboard shortcuts to enter the current date and current time
  • Format dates and times using predefined formats and custom formats
  • Use dates and times in formulas

MSO-1005
Working with Dates and Times
1.6

Excel includes commands designed to make it faster and easier to work with data that is arranged in a table. If your data is arranged in a table, you will find the Excel’s Table Tools very beneficial.

By the end of this course, you will be able to

  • Describe a table
  • Insert a table
  • Change the table style and the worksheet theme
  • Insert a total row and then insert functions
  • Describe how to resize the table
  • Insert a calculated column
  • Sort and filter data
  • Remove duplicate records from the table
  • Convert a table to a range

MSO-1007
Displaying Data in Charts
1.4

There is an old saying that a picture is worth a thousand words. Excel’s chart tools enable you to present complex data in an easy to understand visual format.

By the end of this course, you will be able to

  • Create a chart based on Excel data
  • Define common chart elements
  • Describe how to change the chart layout, colors, style, or other options
  • Explain how to reposition or resize a chart
  • Create and edit Sparklines

MSO-1008
Printing a Worksheet
1

The printing process enables you to print physical copies of your worksheet. Excel provides many options to specify what is included on the printout and how it should look.

By the end of this course, you will be able to

  • Explain the printing process
  • Describe the print window and print preview
  • Switch between different document views
  • Change the margins, orientation, and paper size
  • Select a print area
  • Understand manual and automatic page breaks
  • Change the scale of the document
  • Insert headers and footer


Program Fee

$259.95Price quoted is per person and does not include GST. Subject to change without notice.

Course Sidebar

Contact Us Today!

Our advisors are available to address your questions.

Register NOW

Telephone:

(604)900-1980 x136

Email:

registrar@nwskills.org

Course Delivery

Online Training