Introduction to Microsoft Excel dives right into the fundamentals of using Microsoft Excel and provides practical lessons for daily use. The course covers principles of data collection and analysis, building functional spreadsheets, Excel tools, and macros. Emphasis is placed on practicality by employing tutorials and using the framework of a business case to illustrate the real-world application of course content.
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
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.
Schedule: August 16, 17, 18, 19 & 20, 2021. 9:30am to 12:30pm
Format: Online, synchronous/live instruction and applied practice. Continuing Education will provide access to Microsoft Excel.
Prerequisites: English language proficiency
Requirements: Access to a computer with high-speed internet.
Course Fee & Discounts: $175+HST. UWindsor Alumni, staff and students are entitled to discounts. Contact continue@uwindsor.ca for more information.
Instructor:
Connor Hasegawa is a partner at Futurelab, a Windsor-based consulting firm; in this role, he advises clients in both the public and private sectors, across a wide range of industries, on a variety of issues related to strategy and innovation. Connor completed a Bachelor of Commerce (Honours with Thesis) at the Odette School of Business at the University of Windsor, and conducted research on leadership and organizational behaviour within innovative teams throughout the course of his degree. He has participated in substantial Excel-related course redesign at the Odette School of Business, and has developed and taught Excel tutorials there for several years.