Official Course Description: MCCCD Approval: 10/22/91
BPC114AE 19876-19925	L+L	1 Credit(s)	2 Period(s)
Excel Spreadsheet
Excel spreadsheet skills for solving calculations, forecasting, and projection problems. Prerequisites: None.
Cross-References: CIS114AE

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:
BPC114AE   19876-19925	Excel Spreadsheet

1.	Load and set up the electronic spreadsheet program. (I)
2.	Create a properly formatted worksheet file. (II)
3.	Build an electronic template using labels, numbers, and formulas. ( III)
4.	Enter, delete, and alter electronic spreadsheet data. (IV)
5.	Save on disk and retrieve from disk an electronic spreadsheet. (V)
6.	Print an electronic spreadsheet on the printer and on disk. (VI)
7.	Sort an electronic spreadsheet in a variety of ways. (VII)

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:
BPC114AE   19876-19925	Excel Spreadsheet

I. Spreadsheet concepts A. Loading B. Terminology C. Set up II. Creating a worksheet file A. Using proper keys B. Aligning data within cells C. Reformatting data within cells III. Building an electronic spreadsheet template A. Entering formulas B. Using proper symbols C. Algebraic hierarchy D. Using the spreadsheet's built-in functions IV. Entering, deleting, and altering data A. Entering new data B. Deleting existing data C. Modifying existing data V. Saving and retrieving files A. Saving a spreadsheet file on disk B. Updating and correctig a spreadsheet file C. Reserving a spreadsheet VI. Printing a spreadsheet A. Controlling margins and options B. Printing on the printer C. Printing on the disk VII. Sorting a spreadsheet A. Sorting in ascending order on rows or columns B. Sorting in descending order on rows or columns

Go to Description    Go to top of Competencies    Go to top of Outline