Course

Excel for Business

Faculty
Commerce and Business Administration
Department
Computing Studies & Information Systems
Course code
CSIS 1190
Credits
3.00
Semester length
15 Weeks
Max class size
35
Method(s) of instruction
Lecture
Seminar
Course designation
None
Industry designation
None
Typically offered
To be determined

Overview

Course description
This course covers essential features of Microsoft Excel software. Topics include workbooks and worksheets, functions and formulas, charts, datasets and data tables, pivot tables, what-if analyses, date and time functions, logic functions, statistical functions and data analysis, multi-sheet workbooks, data import and transformation, templates and MACROs.
Course content
  1. Excel workbooks, worksheets, and cell references 
  2. Data entry, data formats, function entry, and formulas  
  3. Charts and data representation 
  4. Data sets, data tables, and pivot tables 
  5. What-if-analyses, one- and two-variable tables and goal seeking 
  6. Logic functions, count and evaluate under multiple conditions 
  7. Statistical and financial functions, data analysis and analysis of variance (ANOVA) 
  8. Multisheet workbooks, 3D referencing, and data consolidation 
  9. External data import and transformation 
  10. Worksheet templates, annotation and inspection 
  11. Repetitive and reusable editing steps and MACROs 
  12. Applications of Excel in solving real-world business problems 
  13. Use and apply applications of AI tools in Excel 
Learning activities

Lecture, seminar, demonstration, and hands-on exercises.

Means of assessment

Evaluation will be carried out in accordance with the Douglas College Evaluation Policy.

Assignments/Labs (min 3)  10-30%
Term Tests (min 3) (combination of theory and hands-on tests)  30-45%
Final Examination* 30-40%
Total 100%

* Practical hands-on computer exam

In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).

Learning outcomes

At the end of this course, the successful student will be able to: 

  1. Describe the main features and functions of Excel
  2. Create data in Excel or import data to Excel  
  3. Use built-in statistical, financial and logic functions effectively
  4. Build and use data tables and pivot tables 
  5. Employ different charts to visualize data from different perspectives
  6. Carry out a what-if analyses 
  7. Create and manage multisheet workbooks 
  8. Create MACROs to improve productivity 
  9. Use Excel to solve real-world problems 
  10. Use and apply AI tools in Excel to solve complex real-world problems 
Textbook materials

Poatsy, Mulbery, Davidson & Grauer,?Exploring Microsoft Excel, latest edition, Pearson Educational 

or other similar textbooks as approved by the department. 

Requisites

Prerequisites

Pre-Calculus 11 (minimum of C) or Foundations of Math 11 (minimum of C) or MATU 0410 (minimum of C) or FINC 1231 (minimum of C) or approved substitution OR currently active in one of the following:

PBD Advanced Human Resource Management
PBD Finance
PBD Project Management
PDD Financial Planning
PDD International Business Management
PDD Project Management

Corequisites

None

Equivalencies

CSIS 1110

CSIS 1140

Course Guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.

(Current)

Course Transfers to Other Institutions

Below are current transfer agreements from Douglas College to other institutions for the current course guidelines only. For a full list of transfer details and archived courses, please see the BC Transfer Guide.

Institution Transfer details for CSIS 1190
Athabasca University (AU) AU CMIS 2XX (3)
Camosun College (CAMO) CAMO BUS 140 (3)
Capilano University (CAPU) CAPU BCPT 123 (3) or CAPU TOUR 149 (3)
College of New Caledonia (CNC) No credit
College of the Rockies (COTR) COTR OFAD 181 (1.5)
Kwantlen Polytechnic University (KPU) No credit
Langara College (LANG) LANG BCAP 1XXX (3)
Nicola Valley Institute of Technology (NVIT) NVIT BUSM 1XX (3)
North Island College (NIC) NIC BUS 170 (3)
Okanagan College (OC) No credit
Simon Fraser University (SFU) No credit
Thompson Rivers University (TRU) No credit
University Canada West (UCW) UCW CPSC 1XX (3)
University of British Columbia - Okanagan (UBCO) No credit
University of British Columbia - Vancouver (UBCV) No credit
University of Northern BC (UNBC) No credit
University of the Fraser Valley (UFV) UFV CIS 1XX (3)
University of Victoria (UVIC) UVIC CSC 1XX (1.5)
Vancouver Community College (VCC) VCC OADM 1106 (2.5)
Vancouver Island University (VIU) VIU QUME 185 (3)

Course Offerings

Summer 2026

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N6109
Times:
Start Time
15:30
-
End Time
18:20
Section notes

CSIS 1190 003 - Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N6107
Times:
Start Time
15:30
-
End Time
18:20
Section notes

CSIS 1190 008 - Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N6109
Times:
Start Time
15:30
-
End Time
18:20
Section notes

CSIS 1190 005 - Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N5111
Times:
Start Time
9:00
-
End Time
11:50
Section notes

CSIS 1190 070 - This section is a Saturdays.

Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N6107
Times:
Start Time
8:30
-
End Time
11:20
Section notes

CSIS 1190 009 - Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N6107
Times:
Start Time
8:30
-
End Time
11:20
Section notes

CSIS 1190 010 - Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.

CRN Days Instructor Status
Maximum seats
35
Currently enrolled
0
Remaining seats:
35
On waitlist
0
Building
New Westminster - North Bldg.
Room
N6107
Times:
Start Time
9:30
-
End Time
12:20
Section notes

CSIS 1190 011 - Students in ACCT, BUSN, FINC, MARK, and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.

Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. Contact the Chair / Program Coordinator of the Department of Computing Studies and Information Systems if you have any questions.

CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK, and HOSP credentials.