| PROJECT |
SKILL SETS |
LECTURE DEMONSTRATIONS - IN THE LABS |
| 1 |
Creating a Worksheet and an Embedded Chart - Copy with the fill handle -
Format a worksheet - Use AutoCalculate - Use Excel Help system |
Lecture demonstrating the business use of these skills |
| 2 |
Formulas, Functions, Formatting, and Web Queries - Verify with Range
Finder - Check Spelling - Print Preview - Display/Print formulas - Use a
Web query - Rename Sheets |
Lecture demonstrating the business use of these skillsPart1
Part2 |
| 3 |
What-If Analysis, Charting, and Working with Large Worksheets - Rotate
text - Freeze and unfreeze titles - Absolute cell references - IF
function - Goal Seek |
Lecture demonstrating the business use of these skills |
| 4 |
Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks
- Control thickness and color of borders - Assign names to cells - PMT
and FV functions - Use formula checking - Hyperlinks - Protect and
Unprotect cells |
Lecture demonstrating the business use of these skills |
| 5 |
Creating, Sorting, and Querying a List - Use a data form to display,
add, and delete records - Display automatic subtotals - Use Group and
Outline features to hide and unhide data - Query a List - SUMIF and
COUNTIF functions - Save to different file formats |
Lecture demonstrating the business use of these skills |
| 6 |
Creating Templates and Working with Multiple Worksheets and Workbooks -
ROUND function - Using Styles - WordArt - Comments - Headers, Footers,
and Page Breaks - Create and use a Workspace file - Consolidate data by
linking workbooks |
Lecture demonstrating the business use of these skills - Not
Available |
| 7 |
Using Macros and Visual Basic for Applications (VBA) with Excel - Macro
Recorder - Customize a toolbar and menu - Add controls (command buttons,
scroll bars, check boxes, spin buttons) - Use VBA to write a procedure -
Do-While and If-Then-Else statements - Test and validate incoming data |
Lecture demonstrating the business use of these skills - Not
Available |
| 8 |
Formula Auditing, Data Validation, and Complex Problem Solving - Watch
Window - Trace Precedents and Dependents - Data Validation Rules -
Excel's Solver and Scenario Manager - Create a Scenario PivotTable -
Attach a custom toolbar to a workbook |
Lecture demonstrating the business use of these skills |
| 9 |
Importing
Data, Working with XML, PivotCharts, PivotTables, and Trendlines -
Compare and merge workbooks - Share workbooks |
Lecture demonstrating the business use of these skills |
| Web |
Web Feature - Creating Static and Dynamic Web Pages Using Excel |
|