CIS 2011 - Spreadsheets
Clock Hours: 70
Delivery Mode on-ground
Prerequisites: PC Operator Certificate
Industry Certifications Microsoft Office User Specialist
Course Description: This course is designed to teach the student how to create number-intensive documents such as payroll records and sales analysis. Spreadsheets simplify what-if analysis, chart creation, and multiple worksheet analysis, and simple database functions. The students will learn to create and format spreadsheets and charts, to develop problem-solving skills through the development of formulas mandatory in spreadsheets, and to understand the flat file database feature of a spreadsheet.
Student Learning Outcomes:
- Start Excel and open a new workbook.
- Use insert, delete, copy and move cells.
- Use the fill handle.
- Add a chart to a spreadsheet.
- Enter and edit cell data including text, numbers, and formulas.
- Create workbooks using templates.
- Use editing tools such as spelling and find and replace.
- Apply and modify cell formats including font styles, number formats, decimal places, autoformat, borders, shading, merge, rotate, indents, and conditional formats.
- Modify row and column settings and formats including insert, delete, size, hide, unhide, freeze, unfreeze, and alignment.
- Define, apply, and remove styles.
- Use automated tools to format worksheets.
- Create and revise formulas including absolute and relative references.
- Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX).
- Use the range finder.
- Use statistical, date and time, financial, and logical functions in formulas.
- Use what-if analysis.
- Create, modify, position, and print charts.
- Create, modify, and position graphics.
- Create, sort, filter, and query a table.
- Create a lookup table.
- Create hyperlinks.
- View and edit comments.
- Modify page setup options including page orientation, page breaks, scaling, margins, centering, print area, headers, footers, print titles, and other options.
- Preview and print a selection, worksheets, and workbooks.
- Insert, delete, rename, move, and copy worksheets.
- Link worksheets and consolidate data using 3-D references.
- Convert worksheets into web pages.
- Manage workbook files and folders.
- Save workbooks using different name and file formats.
|