Microsoft Excel - INT762

Course Equivalency

Online Only

Course Description

This course introduces students to Microsoft Excel. Knowledge of this fundamental spreadsheet software has proven to boost career and employment prospects. Excel skills can boost productivity as a student and are useful in daily life, such as managing personal finances. Through an engaging and scaffolded approach, students advance from absolute basics like formatting and navigation, to performing complex tasks like data manipulation, macros, and PivotTables.

Certification

This course prepares students for the Microsoft Office Specialist Excel Certification.

Major Concepts

• Module 1: Introduction to Microsoft Excel
• Module 2: Managing Workbook Options and Settings
• Module 3: Managing and Formatting Data
• Module 4: Applying Advanced Conditional Formatting and Filtering
• Module 5: Looking Up Data by Using Functions Part I
• Module 6: Looking Up Data by Using Functions Part II
• Module 7: Creating and Modifying Simple Macros and Advanced Charts
• Module 8: Creating and Modifying PivotTables
• Module 9: Creating and Modifying PivotCharts

Grade Level

• 7-12

Materials

• Microsoft Excel

Duration

• 1 semester/0.5 credit