IS-171: Computing with Spreadsheets
Welcome to IS-171, Computing With Spreadsheets,
at Calvin College.
Students successfully completing this course will demonstrate their ability to:
Create a useful Excel worksheet which includes all of the available formatting
Enter formulas and basic functions and properly use relative, absolute and mixed cell
Create charts, chart shapes, sparklines and use OLE to include data and charts in Word
Pass data between Excel worksheets within an Excel workbook using 3-D formulas.
Use conditional formatting, data validation, cell names in formulas and hide rows
Create, sort, and filter Excel tables, and use PivotTables, PivotCharts and
Use advanced functions such as IF, VLOOKUP, PMT,
FV, IFERROR, COUNTIFS and AVERAGEIFS.
Record and edit macros and associate them with buttons on a worksheet.
Get external data from other sources and include the data on a worksheet.
See Calvin's Moodle for other course materials.