Excel Microsoft For Windows / Mac -Part 3

Number of sessions: 2
Course Fee: $20

Prerequisites:

• This course assumes that you have learned the basic skills necessary to create a spreadsheet and work with other aspects of the program as detailed in the Parts 1 and 2 objectives.

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. Create multi-dimensional spread pivot tables.
5. As time permits: Explore What-if analysis, validation tables, student-specific requests

Description:

Students will expand on techniques learned in Excel Part 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 10 and 11 and Mac Operating Systems even though the class will be taught on Windows 11 computers.

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