Syllabus

Excel Basics

1. Navigating the Excel desktop

a. Menus, toolbars, worksheets, rows, columns, cells

2. Entering editing, and formatting data

a. Text, numbers, currency, dates/times, percentages, formulas

b. Cut, copy, paste, undo, autofill, validation

3. Useful tools

a. Printing, templates, locking, passwords

b. Screen controls:  zoom, freeze panes, screen splitting

Databases in Excel

1. Sorting, filtering, grouping, subtotals, pivot tables

2. Charting data

3. Designing databases in Excel - limitations

Formulas and functions

1. Arithmetic formulas and functions

a. Operator precedence

b. Relative and absolute addressing

2. Financial formulas and functions

3. Time and date formulas and functions

4. Text formulas and functions

5. Logical formulas and functions

a. Lookup, conditional formatting

[Note:  These topics are included in the class notes.  The pace at which the class is taught, and thus the depth and coverage, will depend on the needs and interests of the students.]