Course Overview
This course concentrates on using complex formulas, charts and graphs, database lists and the consolidation of worksheet data within Excel to solve spreadsheet management tasks, and to manage data and lists. Specifically, it focuses on developing excellent marketing analysis and spreadsheet management skills. Students will be able to create and manipulate complex spreadsheets used to assist in problem-solving. Students will convert large amounts of data into meaningful information for decision-making, create, build and edit complex formulas and functions, and create visually appealing and meaningful charts and graphs. Lectures are designed to build a solid foundation of the fundamentals. Labs are geared toward hands-on practical application of the concepts.
Prerequisite(s)
- 50% in BSYS 2070
- Completion of second-level Marketing Management courses
Credits
3.0
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Demonstrate an understanding through the application of key tools and functions of Excel, including, but not limited to:
- Designing spreadsheets that allow for forecasting and advanced what-if analysis.
- Building and entering financial, statistical, logical and look-up functions.
- Building and managing databases.
- Building meaningful reports within Excel.
- Sorting, subtotalling and filtering large amounts of data.
- Evaluating large datasets to extrapolate meaningful information to facilitate decision making.
- Managing and consolidating multiple worksheets and workbooks.
- Creating, formatting and exporting charts and graphs.
- Integrating Excel with other Microsoft Office and Web applications.
- Apply the above tools in the context of business and marketing applications.
Effective as of Fall 2021
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.