Lifelong Learning - Courses and Registration

Throw away your calculator! Learn to crunch numbers with Excel. Learn the basics of this powerful program to create gradebooks and lesson plans: formatting data, using formulas and functions, moving and copying data, and customizing and printing options. Work with multiple sheets and create graphs. Some experience with Windows and mouse required. Hands-on, instructor-led class. Text and data disk provided. (CEU=1.0)

Syllabus for Excel Introduction

Provider: Julie Randolph of Computer Tutors
Course Run Time: 10 hours

Course Description:
Throw away your calculator! Learn to crunch numbers with this powerful program and create financial worksheets and budgets: entering and editing data, formatting data, using formulas and functions, moving and copying data, customizing and printing options. Also learn to link multiple sheets and create graphs. Some experience with Windows and mouse required. Hands-on, instructor-led class. Text and floppy data disk provided. (CEU=1)

Order of Instruction:
• An overview of electronic spreadsheets
• Cell address box, formula box, status line command
• Selecting menu and toolbar commands
• Page setup
o Margins
o Paper orientation
o Header/footer options
o Sheet options
• Using Help
• Creating and editing worksheet entries
o Cancel, typeover, editing techniques
o Selecting cells for wrapping around typed entries
o Formatting ranges of data
• Copying entries with the fill feature
• Working with formulas and functions
• Use of operators in simple formulas
• Order of operations
• Parts of SUM function
• Copying
• Relative and absolute cell references
• Inserting and deleting rows and columns
• Changing Excel defaults
o View
o Edit
o General options
• Using fill for a series and customizing a series
• Sorting data, splitting and freezing windows
• Using the function wizard
o Sum
o Average
o Minimum
o Maximum
o Date
o If, pmt, and fv functions
• Formatting fonts, alignment and borders
• Multiple sheet references
• Creating a graph from a worksheet
• Importing and exporting worksheets

Note: Every effort has been made to provide a complete and accurate syllabus; however, specific changes may be made as needed. The instructor reserves the right to make exceptions or amend course requirements and syllabus as deemed necessary.

The individual attention of being in a small class was great! Carolyn Cobb

Very helpful for classroom use! Kathy Dean