Course Overview
Microsoft Excel is a powerful tool that can be used to analyse, communicate and manage information. Students with no prior spreadsheet experience are shown the fundamental principles of spreadsheets. This Instructor lead, hands-on course provides students with the ability to create, edit, format and print spreadsheets. Topics include: entering and editing data, using Excel components and options, modifying worksheets, creating formulas and using functions, charting and sorting and filtering. Participants acquire practical skills to be able produce professional looking, well formatted Excel worksheets in only 6-weeks and they are prepared to move on to more advanced Excel material. Those who plan to take COMP 2362, Microsoft Excel Advanced in the same term should instead register for the complete 12 week course COMP 2364, Microsoft Excel, which covers both fundamental and advanced topics.COMP 1362 is currently not offered.
Prerequisite(s)
- COMP 1002 or equivalent knowledge of MS Windows and File Management plus Grade 12 Math or Business Math or equivalent.
Credits
1.5
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Identify the MS Excel user interface components.
- Create, save, open, close and print workbooks.
- Demonstrate entering, editing, saving and modifying data in a worksheet.
- Demonstrate formatting and improving the appearance of a worksheet.
- Apply Relative, Absolute and Mixed cell references.
- Apply Basic Formulae and Functions.
- Apply Date and Time Functions.
- Apply Decision Making Functions.
- Apply Financial Functions.
- Demonstrate creating, modifying and formatting charts.
- Demonstrate the use of sorting, filtering and editing lists.
- Apply protection to workbooks, worksheets and ranges.
- Analyze data using the Subtotalling tool
- Create and summarize data with Pivot Tables and Pivot Charts.
- Move on to Microsoft Excel Advanced COMP 2362.
Effective as of Fall 2020
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.