Spreadsheets I

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