Overview

Excel Mastery Intro

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.

Please email STTCE@fanshawec.ca or call 519-633-2030 to ensure your email is accurate to obtain access to this course.

Please note this is not a Fanshawe Certificate or course. Ensure your contact information is up to date on Web Advisor. This course runs asynchronously online and is offered in partnership with LERN and UGotClass. Once completed you will obtain a LERN certificate.

Themes:

Unit 1: Excel From the Ground Up

  • Why businesses use Excel for spreadsheet management
  • Technical requirements to use Excel (and all Office modules)
  • Launch Excel and create your first Excel worksheet
  • Discover how to protect and save your document
  • Set your document's Properties and Attributes including Subject, Title and Author

Unit 2: Excel Document Creation

  • Explore the different parts of the Excel worksheet and document navigation
  • Understand cells and their makeup
  • Learn how to populate, format and merge cells
  • Create multiple worksheet "workbooks"
  • Learn how to insert comments and check spelling

Unit 3: Advanced Features and Functionality

  • Create and manage formulas and functions
  • Filter and sort tables and data
  • Create "live" connections between multiple worksheets
  • Create effective and informative table and charts

Unit 4: Excel Management and Sharing

  • Create meaningful file names and understand filing systems to manage Excel documents
  • Organize your documents on your hard drive and learn how to copy and move documents
  • Manage track changes when co-authoring documents
  • Printing and PDF file creation including setting print areas
  • Learn how to export Excel tables and charts to PowerPoint presentations and Word documents
  • Use Outlook to send Excel worksheets and workbooks to other users

 

For each Unit, you will:

  • Read the print readings (about 20 pages a week)
  • Have the option of accessing the online readings
  • Listen to the audio presentation for the Unit and view the slides
  • Have the option of taking a self-quiz to see how much you have learned
  • Engage in written online discussion with your instructor and other participants

 

For best learning, you should make one or more comments at 2-3 different times each week.

The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

Course Code:
COMP-9728
Area of Interest:
Computers, Design, and Media

Course Offerings

Summer 2025

to
$280.00
Delivery:
Online
Location:
St. Thomas
Section Number:
65ST
Refund Policy:
7 days after course start date

Course Details

More details
No related programs.
Back to Continuing Education Courses