Excel Certification
Lower Dauphin School District
Curriculum Guide
| Course Title: Excel Certification |
Subject: Business | Grade Level(s): 9-12 |
Synopsis of Curriculum
This course will provide students with a solid understanding of how to use Excel to create documents used by business professionals as well as a strong foundation of using Excel in post high school business programs. This course is a hands-on class that will give students a comprehensive study of Microsoft Excel. Excel topics will range from basic applications to advanced features such as linking files and worksheets, creating charts, working with formulas and functions, and using data and pivot tables. Microsoft Certified Application Specialist text and software will be used throughout the course.
Units of Study Titles
Creating a Worksheet and a Chart
Formulas, Functions, and Formatting
Working with Large Worksheets, Charting, and What-If Analysis
Financial Functions, Data Tables, and Amortization Schedules
Working with Multiple Worksheets and Workbooks
Creating, Sorting, and Querying a Table
Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots
Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers