Advanced Microsoft Excel
CIS 162B
2-day workshop, $215 +tax
9:00 am-4:00 pm
Students
will get the most out of this course if they wish to learn the skills
and concepts necessary to work with advanced capabilities of Excel. Students
should have a basic knowledge of the concepts involved in using Windows
XP and Excel. For example, they should be familiar with data types (text
or numbers), copying or filling data, basic formulas and functions, and
opening and saving files. To ensure the students' success, we recommend
that they first take the Introduction to Microsoft Excel XP
workshop or have equivalent knowledge.
Skills learned in this course:
| Add sheets to a workbook | Set up criterion ranges |
| Annotate a worksheet using Drawing tools | Use Criteria to filter records |
| Apply conditional formatting | Use Data Forms |
| Attach a macro to a button on a worksheet | Use Data Validation |
| Convert workbook data to HTML format | Use Database functions, including DSUM, DCOUNT, and DMAX |
| Create a basic Web page using an Excel file | Use Excel's auditing features |
| Create and use PivotTables | Use Excel's macro recorder |
| Create and use styles (for format data) | Use lookup tables and the Vlookup function |
| Create formulas | Use manual and automatic recalculation |
| Create formulas containing 3-D cell references | Use Page Break Preview |
| Create formulas containing absolute or mixed cell references | Use Paste Special |
| Create formulas involving dates and times | Use the Advanced Filtering feature |
| Create linking formulas | Use the AutoFormat feature |
| Create natural-language formulas | Use the Format Painter |
| Create nested formulas containing more than one function | Use the future value (FV) function |
| Create simple formulas containing a single function | Use the Goal Seek feature |
| Enter data into more than one sheet at a time | Use the If function |
| Enter dates into a worksheet | Use the Outlining feature |
| Enter times into a worksheet | Use the payment (PMT) function |
| Freeze titles and headings | Use the Round function |
| Name cells | Use the Subtotal feature |
| Protect worksheet data | View and edit macro code |
| Save a file with a password |
 |
|
 |
|
 |
|