Facebook

This course can be applied toward a program:

Online: Self-paced

Start Anytime

Microsoft Excel is used by organizations all over the world for financial, numeric, and general data management, yet it is widely underutilized. If you want to harness all that Excel has to offer, this is an ideal place to start.

In this course, you learn layout options and how to work with data, then go on to learn how to set up print options for reports. You'll also discover tips for viewing your Excel data, and find out how to get your worksheets ‘talking’ to each other.

This course will supercharge your Excel skills and take them to the next level, no matter where you're starting from.

Average weekly commitment: 3+ hours. Total course commitment: 12+ hours.

Start anytime within indicated date range. You have 90 days from the date you register to complete the course.

Learning Outcomes

At the end of this course, you will be able to:

  • Change the worksheet layout and modify columns, cells, and rows
  • Hide and unhide rows and columns
  • Find and replace data
  • Lay out an Excel worksheet for printing
  • Create meaningful charts to display Excel numbers and other information
  • Change the worksheet view to make it easier to view Excel data

Modules

Module 1: Formatting

Module 2: Adjusting Worksheet Layout and Data

Module 3: Sorting and Special Functions

Module 4: Introduction to Charting

Module 5: Printing

Module 6: Multiple Worksheets and Workbooks

Evaluation Method

Pass/Fail

Prerequisites

  • MS Excel Basics (or equivalent skills)
  • Basic keyboarding capability
  • Basic internet navigation skills
  • Basic file management knowledge

Required Materials

  • Windows or Mac computer (desktop or laptop).
  • MS Excel 2013, 2016 or Office 365.
  • High-speed internet (at least 25 Mbps download speed) – Find out your internet connectivity speed.

Registration

2 sittings of this course are listed below. Add a course to your cart to register.

Open all Close all

Course Reference Number (CRN) 91056

Instructor Julie Clarke

$309

Sorry, this course is closed for registration at this time. NOTIFY ME WHEN REGISTRATION OPENS

Course Reference Number (CRN) 93013

Instructor (CSEE Contract) MindEdge

Contact

Have a question for Continuing Studies?

Continuing Studies

CapU Lonsdale
250-125 Victory Ship Way
North Vancouver, British Columbia
Canada V7L 0G5
604 984 4901
cs@capilanou.ca

0

Your cart: 0

Subtotal

$0

Checkout

Your cart is empty