Descriptive and Diagnostic Data Analytics in Energy with Excel
Overview
Professionals in the energy sector rely on data to understand production, consumption, efficiency, and operational performance. Microsoft Excel is commonly used to organize, clean, analyze, and visualize this information in a practical and accessible way. In this course, learners will perform basic descriptive and diagnostic data analysis using Microsoft Excel to identify anomalies and better understand energy-related datasets. Learners will clean data, calculate central tendencies, create basic visualizations, and apply correlation and regression analysis to help resolve a data problem within an energy company. Suggested prerequisite experience: Learners should have basic computer literacy, including navigating websites and downloading and saving files.
The time commitment for course completion is approximately 5 to 7 hours.
Who should attend
This program is designed for professionals in the energy sector or related fields who want to build foundational data analytics skills.
This program is ideal for:
- Mid-career energy professionals
- Professionals working with production, consumption, efficiency, or operational data
- Staff moving into reporting, analytics, informatics, or data-informed roles
- Professionals who use Excel and want to expand into dashboards, Power BI, or Python
- Individuals looking to strengthen practical data skills without needing advanced analytics experience
What you'll learn
Learners will develop practical skills in using Microsoft Excel to prepare, analyze, and interpret energy-related data. By the end of the course, learners will be able to clean and organize datasets, calculate key summary statistics, create basic visualizations, and use correlation and regression analysis to identify relationships, trends, and anomalies.
Learners will also apply these skills to a realistic energy-sector data problem, helping them turn raw data into meaningful insights that can support operational decisions and problem-solving.
Course information
- Schedule
- Course structure
- Fees, discounts and registration
- Online delivery
- Policies
- Continuing Education Units
Fall 2026
| Descriptive and Diagnostic Data Analytics in Energy with Excel | Monday, September 14, 2026 to Monday, September 13, 2027 |
|---|
Online
This offering includes assessment support from a Marker-Grader who reviews submitted assessments and provides feedback. Learners may have the opportunity to revise and resubmit assessments based on the feedback received, in accordance with course requirements.
Marker-Grader support
This offering is supported by a facilitator who is available to answer learner inquiries and provide feedback on assessments. Learners will have two chances to successfully complete each assessment by the specified deadline(s), after receiving feedback from the facilitator.
Fall 2026
| Registration fee | Registration status |
|---|---|
| $149 CAD + HST |
|
Discounts
The Alumni/Staff Discount applies to registration in this program/course.
If you are alumni or staff, contact continuouslearning@ontariotechu.ca with your Student/Banner ID before registering for details about how to apply this discount.
Registration
You can register for this course through the secure online registration form. All course fees must be paid at the time of registration.
Online delivery
This offering may include, but is not limited to:
- Content presentations and/or videos;
- Case discussions;
- Individual work (assignments/quizzes);
- Concept and topic discussions;
- Topic reflections;
This is an open enrolment offering.
Those completing Ontario Tech University Continuous Learning open enrolment offerings (e.g. certificate programs, courses, workshops, microcertifications, etc.) are subject to the policies of Ontario Tech University and Continuous Learning. Ontario Tech policies can be found in the Policy library. Continuous Learning policies can be found in the Regulations section of the Continuous Learning website. Specifically, those completing open enrolment offerings are expected to adhere to the General and Open enrolment regulations.
Ontario Tech University – Continuous Learning assigns Continuing Education Units (CEUs) to eligible offerings. CEUs are awarded under the Ontario Tech University – Continuous Learning (CL) Framework for Awarding Continuing Education Units (CEUs) and Professional Development Hours Reference Standards.
CEUs are provided to support professional development reporting. They do not constitute accreditation or certification by an external licensing or regulatory body. Recognition and acceptance of CEUs are determined solely by the policies of individual employers, professional associations, or professional regulatory organizations.
Requirements
To successfully complete the course, you must:
- Register and make full payment for the course; and
- Successfully complete all components of the course by the specified due date(s).
Learners will receive a digital badge for individual course completion.
Please note: While late registration is available, learners must complete the course by the listed course end date, regardless of the date they registered.
Technology requirements
Online learning requirements:
- Computer or device with internet access
- Stable internet or data connection
- Audio device (examples: speakers, headphones/earbuds, headset)
Material requirements
There are no additional materials required.
A micro-credential is a digitally-recorded recognition of a specific skill. It is a portable communication tool that represents evidence of your skills for employers, educators, and peers. Micro-credentials are created with industry, so you can be assured that the skills you are learning are in demand and current.
Learn more about micro-credentials and digital badges on the Learning Innovation website.