Excel Microsoft Level 3

Number of sessions: 2
Course Fee: $20

Prerequisites:

• This course builds on the foundation of spreadsheet creation and program skills learned in Levels 1 and 2 (refer to those objectives for details).

Objectives:

1. Learn to use more complex formulas for lookups, financial calculations, and if-then statements.
2. Learn to validate and audit formulas on spreadsheets.
3. Import and manipulate a data flat file (cvs, txt); correct data errors using formulas and find/replace tricks.
4. As time permits: Explore What-if analysis, validation tables, student-specific requests.

Description:

Students will expand on techniques learned in Excel Level 2 to manipulate data within spreadsheets to produce reports. The focus will be on using the Formulas, Data, and Review Menu functions. Students will develop practical spreadsheets.

This course is taught for Windows and Mac Operating Systems even though the class will be demonstrated using a Windows computer. MAC computers are available for students.

The course will be taught on Office 365, but differences between earlier versions will be addressed.