MS Excel Advanced Course Program

Date:  April 26th, 2008, Saturday

Time: 9am – 4 pm

Course Contents:

1^st Period (9am- 10am):

·         Use subtotals

·         Define and apply advanced filters

·         Group and outline data

·         Use data validation

·         Create and modify list ranges

·         Add, show, close, edit, merge, and summarize scenarios

·         Perform data analysis using automated tools

·         Create PivotTable and PivotChart reports

2^nd Period(10am-11am)

·         Use Lookup and Reference functions

·         Use Database function

·         Trace formula precedents, dependents, and errors

·         Locate invalid data and formulas

·         Watch and evaluate formulas

·         Define, modify, and use named ranges

·         Structure workbooks using XML

3rd Period(11am-12pm):

·         Lab Practice

·         Each student work on assigned project and instructor work with them individually

LUNCH BREAK(12pm-1pm)

4th Period(1pm-2pm):

·         Create and modify custom data formats

·         Use conditional formatting

·         Format and resize graphics

·         Format charts and diagrams

·         Protect cells, worksheets, and workbooks

·         Apply workbook security settings

5th Period(2pm-3pm):

·         Share workbooks

·         Merge workbooks

·         Track, accept, and reject changes to workbooks

·         Import data to Excel

·         Export data from Excel

·         Publish and edit Web worksheets and workbooks

·         Create and edit templates

·         Create, edit, and run macros

·         Modify Excel default settings

6th Period(3pm-4pm):

·         Lab Practice

·         Each student work on assigned project and instructor work with them individually