Image
Overview
Excel Mastery Inter
This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.
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: Organizing Worksheet and Table Data
- Introduction to tables
- Formatting tables using table styles
- Using formulas in tables
- Sorting and Filtering table data
Unit 2: Understanding Popular Excel Functions
- Understanding Named Ranges
- Applying business functions
- Creating functions that handle text
- Performing basic lookup functions
- Creating functions that work with dates and times
Unit 3: Improving Worksheet Appearance
- Formatting cells in worksheets
- Correcting common function errors
- Creating and using templates
- Customizing Excel toolbar
Unit 4: Analyzing Data Using Data Validation and Pivot Tables
- Understanding how to convert text to columns
- Understanding how to analyze spreadsheet data
- Understanding the basic pivot table layout and key terms
- Creating and formatting simple pivot tables
For each Unit, you will:
- Access the online readings
- Listen to the audio presentation for the Unit and view the slides
- Take 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 day.
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-9729
Area of Interest:
Computers, Design, and Media
Prerequisites:
Credential:
Course Offerings
Summer 2025
to
$280.00
Delivery:
Online
Location:
St. Thomas
Days & Times:
Section Number:
65ST
Refund Policy:
7 days after course start date
Course Details
More details
Download the Part-time Studies Guide
What's included:
- How to assess if part-time learning is right for you
- Part-time learning options and the differences between each
- How to pay for your part-time education
- Part-time options within your area of interest
- How to sign up for part-time studies and where to get help