MS Excel Course Program

click here for MS Excel ADVANCED Program

Date:  April 19th, 2008, Saturday

Time: 9am – 4 pm

Course Contents:

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

·         Use basic features of a spreadsheet and identify the main interface and Help features of Excel 2003.

·         Create a workbook and navigate through the worksheets in it.

·         Save a new workbook and distinguish between the different file formats used to save workbooks in Excel 2003.

·         Edit data and filter cells in an Excel 2003 worksheet.

·         Copy and move a cell and a range of cells in Excel 2003.

·         Insert, edit, copy, and move worksheets.

·         Insert a worksheet, move data between worksheets, and copy a worksheet to another workbook.

2^nd Period(10am-11am)

·         Filter lists using the AutoFilter feature

·         Sort lists

·         Insert and modify formulas

·         Use statistical, date and time, financial, and logical functions

·         Create, modify, and position diagrams and charts based on worksheet data

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):

·         Apply and modify cell formats

·         Conditional Formatting

·         Apply and modify cell styles

·         Modify row and column formats

·         Format worksheets

·          Insert, view, and edit comments

5th Period(2pm-3pm):

·         Create new workbooks from templates

·         Insert, delete, and move cells

·         Create and modify hyperlinks

·         Organize worksheets

·         Preview data in other views

·         Customize window layout

·         Setup pages for printing

·         Print data

·         Organize workbooks using file folders

·         Save data in appropriate formats for different uses

6th Period(3pm-4pm):

·         Lab Practice

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