Excel Microsoft Level 2

Number of sessions: 2
Course Fee: $20

Prerequisites:

• Completion of Introduction to Excel or similar experience as described in the Level 1 objectives.

Objectives:

1. Learn advanced techniques for using the Clipboard (Copy/Paste).
2. Learn advanced techniques for formatting sheets/cells/text/numbers including conditional formatting.
3. Learn to use and format tables, including creating pivot tables.
4. Learn to use the Function Library and create more advanced formulas.
5. Learn to import data from text/csv and web tables.

Description:

Students will expand on techniques learned in Excel Level I to manipulate data within spreadsheets. 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.