Course Description
This is a BCCampus online provincial course. This course provides you with a working knowledge of electronic spreadsheets using Microsoft Excel. You will learn how to design, create, modify, and present professional-looking spreadsheets for use in today’s workplace. Exercises include using formulas and built-in functions to solve mathematical problems. You will also learn how to illustrate and present spreadsheet data in graphic form.
Course Content
Unit 1 Getting started with Excel
- Introducing Excel
- Planning a workbook
- Entering text, numbers, and dates in cells
- Working with columns and rows
- Working with cells and cell ranges
- Working with formulas
- Working with worksheets
- Editing your work
- Previewing and printing a worksheet
Unit 2 Formatting a worksheet
- Formatting workbooks and text
- Working with color
- Formatting data and cells
- Copying and pasting formats
- Applying styles and working with themes
- Using conditional formats
- Formatting and hiding worksheet data
Unit 3A Working with formulas and functions
- Copy formulas
- Use relative and absolute cell references
- Working with functions
- Use Autofill
- Use IF function
- Use Date function
- Use PMT function
Unit 3B Using assumptions
- Use isolated area of worksheet to enter values that can be changed to perform analysis
- Use absolute cell addresses in formulas to reflect isolated area of worksheet
- Test worksheet for accuracy
- Perform analysis based on “what if” scenarios
Unit 4 Project 1
- Plan effective charts
- Identify chart elements
- Create embedded charts and charts in a chart sheet
- Move, size, edit, and enhance charts
- Create a chart using nonadjacent ranges
- Use various chart types
Unit 5 Working with charts and graphics
- Create and plan effective charts
- Identify chart elements
- Format charts
- Add a data series to an existing chart
- Use various chart types
- Create a chart sheet
Unit 6 Working with Excel tables
- Plan and create an Excel table
- Maintain an Excel table
- Sort and filter data
- Calculate summary statistics
- Insert subtotals
Unit 7 Project 2
Unit 8 Invigilated project/final exam
Learning Activities
Communication between instructor and students will be conducted online using the Desire2Learn (D2L) email, discussion and chat utilities. The instructor will guide the students through a series of learning objectives using motivation and online instruction.
Learning Outcomes
Upon successful completion of this course you will be able to:
- Plan, create, modify, and present spreadsheets
- Organize, edit, and enhance data in spreadsheets to achieve business standards
- Use formulas and built-in functions appropriately and correctly to solve problems and critically assess the results
- Design efficient spreadsheets capable of answering “what if” questions to solve business problems.
- Plan, organize, create and present spreadsheet data in graphic form
Textbook Materials
Textbooks and Materials to be Purchased by Students
Text: New Perspectives on Microsoft Office Excel, by J. Parsons, D. Oja, R. Ageloff, and P. Carey. Course Technology.
Software: Microsoft Excel 2007, Internet Explorer 6.0 or later, Windows XP with Service Pack (SP) 2, Windows Server 2003 with SP1 or later operating system.