IT Module 3 - Microsoft Excel

Excel Course - Curriculum

Class 1:            Introduction (professor, students, course)

                        Introduction to Excel (what it is, various uses, etc)

                        Environment (GUI) of Excel

Menus, toolbars, work area (cells, rows, columns)

Two modes: select and insert

                        Data introduction

Entering data first time

Editing data

                        Auto fill-in

Basic formatting (font, size, B/I/U, alignment, color)

Selecting cells, rows, columns

Class 2:            Changing column width and row height

Cell formatting (data type, alignment, font)

Inserting rows and columns

                        Deleting rows and columns

Class 3:            Borders

                        Merge and center

Class 4:            Drawing borders (freehand)

Changing the name of sheets, deleting and inserting sheets

                        Header and footer

Class 5:            Copy and move cells

                        Copy and move cells to another sheet

Class 6:            Automatic formatting

                        Ordering data

Class 7:            Simple formulas (addition, subtraction, multiplication, division, exponent, percentage)

                                   Formulas with cell addresses

Class 8:            Auto-completing formulas (click and drag)

Class 9:            Functions

Class 10:          Graphs

Also attached is a zip file with all the lesson plans, exercises, notes, tests, etc.