COURSE NAME – Basic Excel - Part I (Database Emphasis)
COURSE PREREQUISITES - Successful completion of a Windows class or comfortable navigating and using Windows directories. The ability to perform simple computer operations such as select, copy, cut, paste, and drag-and-drop are important skills which should be acquired before beginning this class.
COURSE DESCRIPTION – Three 75-minute classes over three days. This is a structured course designed to introduce the student to beginning principles of spreadsheets using Microsoft Excel program to create data tables or databases. A typical example of this is a membership database. The emphasis for this class will be text oriented with very little time spent on using Excel numeric functions. You should leave the class with a good understanding of how to create and maintain a membership database. Topics include:
- Spreadsheet concepts, layout and structure
- Defining Rows, Columns and Cells
- Entering data into cells
- Cell replication and duplication
- Table or database creation
- Formatting spreadsheet layout
- Sorting data
- Text manipulation using built-in Excel functions
- Saving & Printing
Students interested in learning Excel numeric functions, should also attend Basic Excel Part II (A Numeric Emphasis), which will be scheduled immediately following this class.
This course is not meant for experienced Excel users.
COURSE MATERIALS - The text used is “Microsoft Office Excel 2013 Plain & Simple” and is available at the classroom for approximately $20. The text may also be purchased from such places as Amazon.com.
Bring a personal Flash drive for transporting files between the classroom and home.
INSTRUCTOR – Dave Menser