|
Format |
Length |
Certificate of Participation |
Introduction to Microsoft Excel is a non-credit online course that dives into the fundamentals of using Microsoft Excel from a practical use perspective. The course covers principles of data collection and analysis, building functional spreadsheets, Excel tools, and macros. Emphasis is placed on practicality; tutorials use the framework of a business case to illustrate the real-world application of course content.
- Individuals interested in advancing their knowledge of Microsoft Excel
- Professionals exploring data management options, particularly how to efficiently display and categorize data using tools such as pivot tables, may benefit from this course
Participants can expect to complete a combination of short assignments and activities during the course. Regular online participation is also required for successful completion. Upon completion, students will be awarded a grade of complete or incomplete.
Students will review the following topics throughout this course:
- Introduction/review of basic Excel functions
- Excel functions
- Organizing and presenting data
- Using Excel in the real world: classes and beyond
- Charts and pivot tables
- Introduction to macros
- Filters
- Coding macros from scratch
- Data Sorting
- Other Resources
Upon successful completion of this course, participants will be able to:
- Navigate Microsoft Excel and demonstrate a basic understanding of its functionality
- Determine what categories of data are relevant to a given business scenario, and present collected data in an organized, logical format
- Employ Microsoft Excel tools, in varying levels of complexity, to present and analyze business data (including calculated cells, logical statements and other functions, charts and pivot tables, and filtering)
- Understand basic syntax of Microsoft Visual Basic within the context of macro code
- Record macros and write simple code for macros
Upcoming Course Schedule
There are no scheduled sections of this course. Please join our interest list for more information about new programs & upcoming sections of this learning.
Format
Credential
Upon completion, you will receive a Certificate of Participation in “Introduction to Microsoft Excel”. Attending 85% of the class is required for a certificate.
Prerequisites:
English language proficiency
Technical Requirements
Access to a computer with high-speed internet.
All course details can be accessed through Brightspace LMS.
All current versions of modern browsers such as Chrome, Firefox, Edge and Safari are supported. You will be unable to access Brightspace when using Internet Explorer. Read all the Computer and Browser requirements.
Please activate your UWinID. Your UWinID and password are needed to access Brightspace. If you have any issues, please contact continue@uwindsor.ca.
For login instructions and additonal support, visit the University of Windsor's Brightspace page
Course Fees
Fee: $250 + HST
Full refund 7 days before the start of the course, minus a $25.00 administration fee. Please review our Registration and Refund Policies for more information.
Discounts
UWindsor staff, students, alumni, and Hire UWindsor partners are eligible for a discount. For leaders in their organization who wish to send their team, group rates are available. Email continue@uwindsor.ca for details.
Funding
OSAP-MC
- This program is eligible for the OSAP Micro-credential application (OSAPMC).
- Participants must be registered into the program prior to applying for OSAPMC.
- Participants are obligated to pay their fees in full, or decide to withdraw at least one week prior to the course start date should they not receive OSAPMC.
- If this is the case, email continue@uwindsor.ca immediately to withdraw and request a refund.
- Register for this program accordingly to allow ample time for your application to be processed. It takes approximately 10-15 business days for the OSAPMC application to be processed.
For more information, please visit our OSAP-MC website, or email our financial aid office.
Brandon Besant
Brandon Besant, a skilled Data Analyst and Computer Science professional, holds a BA in Computer Science from Bucknell University. Currently a Data Analyst Specialist at the University of Windsor, he adeptly develops cross-platform queries, maintains forecasting models, and advances reporting capabilities. With a background as a Controls & Systems Analyst at the City of Windsor, he automated employee scheduling, conducted data modeling, and ensured reporting integrity. Brandon's experience also includes roles at Applied Systems Canada as a Quality Assurance and Underwriting Analyst, showcasing his automation skills and problem-solving prowess. Proficient in Excel, Peoplesoft, Python, SQL, and more, Brandon's technical finesse is matched by his dedication to unraveling insights from complex data.
Hear From Our Students
This class was an eye-opener for me in terms of the capabilities of Excel and how this can be a super-efficient tool in the workplace as well as in personal life. The instructor did a wonderful job explaining concepts and slowed down when needed. I think it was great to work on mock-up store spreadsheets because it instantly causes you to realize how this is useful and practical. I am intrigued to explore Excel more whenever I get the chance and potentially make a career out of this opportunity!
I have never had anyone explain different [Excel] formulas to me. It helped a lot to hear [what each one was] and use [them] at the same time.
[I gained a] deeper understanding of Excel functionalities and valuable applications that I can use in my daily work tasks. Many "aha" moments!!
Other Learning Opportunities
Email us at continue@uwindsor.ca if you have questions - we are always happy to help.
Sign up on our Interest List to be notified about enrolment and receive updates from Continuing Education.