Become an Excel expert and acquire essential skills for the workplace in just one month! Learn advanced Excel formulas, concepts, and applications using larger and more professional worksheets using MS Excel. This accredited BCIT course will be hosted by the Whistler Institute and delivered over 6 mornings in-person in Whistler during October 2023.
Course Description
The primary focus of this course is to develop data manipulation skills to present and summarize information. In today’s online working environment it is a required skill for many workers. The course includes discussion of various sophisticated data tools to assist managers in making business decisions. This course covers advanced Excel formulas, concepts, and applications using larger and more professional worksheets using MS Excel. Topics include built-in functions, charts, dashboards, transferring data across applications, and using the built-in tools such as PivotTables, Sparklines, and Slicers.
Course Learning Outcomes/Competencies
Upon successful completion of this course, the student will be able to:
- Apply Relative, Absolute and Mixed cell references.
- Prepare, create and apply Templates and Styles in Charts and Tables.
- Use correct data modeling terminology.
- Apply data validation options.
- Create Digital Dashboards to present complex data.
- Organize data lists using filters and PivotTables.
- Develop effective "what if" statements in a spreadsheet to support business decisions.
- Present complex data in a digital format to effectively support business decisions.
- Develop a multi-sheet worksheet model.
- Analyze data using the Scenario Manager, Data Tables and Goal Seek.
- Apply Conditional Formatting to large sets of data.
- Solve financial/business problems using appropriate functions such as PMT, FV, NPER, IRR, NPV and RATE in assessing business cases.
Course Details
New students to BCIT will need to register for an A# in order to register (the same link can be used if you have forgotten your A#).
- CRN: 50659
- Fee: $325 for all participants regardless of immigration status. Fee does not include textbook. Registration closes 4pm Sept 28. Cancellation policy: non-refundable within 7 days of the course start.
- Instructor: Nicola Church
- Dates: Delivered over 6 mornings in October: 3, 10, 12, 17, 24, 26. Time: 9 AM-12 Noon.
- Format: In-person classes
-
Location: Oct 3, 10, 12, 24, 26: Board Room, Whistler Chamber Of Commerce Boardroom, 4230 Gate Way Dr #201, Whistler, BC V8E 0Z8
Oct 17: Multipurpose Room, Maury Young Arts Centre, 4335 Blackcomb Way. Whistler, BC, V8E 0X4 - Credits: 1.5
- Hours: 18