Program start date | Application deadline |
2024-08-14 | - |
2024-11-13 | - |
Program Overview
This advanced Microsoft Excel course equips students with expertise in data analysis and summarization using VLOOKUP, Pivot Tables, and other advanced skills. It prepares learners for the Excel Expert MOS certification and offers an assessment-first approach to cater to individual learning needs. Learners are expected to have prior experience with Excel or complete a foundational course before enrollment.
Program Outline
Degree Overview:
This course is designed to help students become experts in Microsoft Excel. It covers advanced-level skills such as VLOOKUP and Pivot Tables, which are essential for analyzing and summarizing data.
Outline:
- Manage advanced workbook options and settings
- Format workbooks with advanced tools
- Generate formulas using conditional functions, logical operations, and data look up functions
- Troubleshoot formulas using advanced error checking tools
- Create charts with advanced functionality
- Manage and define named tables and ranges
- Perform what-if analysis using the Goal Seek tool
- Create and manage pivot tables and pivot charts with advanced functionality
- Enable and create macros
Assessment:
The course follows an assessment-first approach. Students will be assessed at the beginning of the course and then receive an individualized learning plan.
Other:
- It is recommended that learners take COMP9302 Microsoft Excel - Core or have equivalent experience prior to taking this course.
- The cost of Jasperactive and G-Metrix software is included in the course.
- A printable eBook and links to video tutorials are provided in Desire2Learn (D2L), the learning management system.
- Registration usually closes 24 – 48 hours before the course starts. Register early to secure your seat.
Bow Valley College
Overview:
Bow Valley College is a public post-secondary institution located in Calgary, Alberta, Canada. It offers a wide range of programs and services to students, including diploma programs, certificates, apprenticeships, and continuing education courses. The college is known for its commitment to applied learning and its focus on preparing students for successful careers.
Services Offered:
Bow Valley College provides a comprehensive range of services to support student success, including:
Academic Services:
Academic advising, tutoring, writing support, and other resources to help students succeed in their studies.Financial Services:
Information and assistance with student loans, bursaries, and scholarships.New Student Orientation:
Programs and events to help new students transition to college life.Office of the Registrar:
Services related to registration, transcripts, and graduation.Learner Success Services:
Support for students with disabilities, mental health services, and other personal and academic support.Student Association:
A student-run organization that provides social and advocacy services.RGO Library and Learning Commons:
Access to a wide range of resources, including books, journals, computers, and study spaces.Intercultural Centre:
Programs and services to support international students and students from diverse backgrounds.Iniikokaan Centre:
Services and resources for Indigenous students.Bookstore:
Textbooks, supplies, and other merchandise.Student Life and Campus Experience:
Bow Valley College offers a vibrant campus experience with opportunities for student engagement, social activities, and community involvement. Students can participate in clubs, sports teams, and other extracurricular activities. The college also has a strong focus on student support and provides a variety of resources to help students succeed.
Key Reasons to Study There:
Job-Ready Programs:
Bow Valley College's programs are designed to prepare students for in-demand careers.Applied Learning:
The college emphasizes hands-on learning and practical experience.Experienced Faculty:
Bow Valley College has a dedicated and experienced faculty who are committed to student success.Supportive Environment:
The college provides a welcoming and supportive environment for students from all backgrounds.Regional Campuses:
Students can access programs and services at regional campuses in Airdrie, Cochrane, and Okotoks.Academic Programs:
Bow Valley College offers a wide range of academic programs in various fields, including:
Entertainment Arts
Business
Technology
Community Studies
Health and Wellness
Careers in Immigrant Advancement
Continuing Education
Academic Upgrading
English Language Learning
Open Studies
Other:
Bow Valley College is recognized as one of the top 50 Research Colleges in Canada. The college's Research and Innovation department focuses on applied research, teaching excellence, curriculum design, and workforce development.