Advanced Excel for Administrative Professionals

Issued by Upstate Medical University

Advanced Microsoft Excel for Administrative Professionals will help administrative professionals reduce errors, save hours of time, reduce redundant work, minimize manual data entry, and display data in graphs and charts. This microcredential will do so by teaching how to use Excel’s built-in tools, commands, formulas, functions, and graphs. This microcredential will also teach administrative professionals how to create customized formulas to fit their needs.

Type Learning
Level Advanced
Time Weeks

Skills

Earning Criteria

LEARNING OUTCOME: Manage Workbooks to include data in cells and ranges; tables and table data; perform calculations using formulas and functions; and creating charts.
LEARNING OUTCOME: Prepare for collaboration to work together to protect data by setting parameters for consistency in the workbook; add co-authors; manage comments.
LEARNING OUTCOME: Create visual heatmaps and 3-D maps using location data on an excel spreadsheet; display demographic data based on zip codes.
LEARNING OUTCOME: Create advanced formulas and macros. Create pivot tables and pivot charts
ASSESSMENT METHODS: Students are given a workbook with data at the beginning of each workshop and expected to work along with the instructor in order to achieve proficiency and self-assess their understanding of the skills taught. Once students complete the 10 workshops, the instructor will email the final project. This will be a workbook with multiple tabs that represents the skills taught within the MC. Students must successfully complete tasks within the workbook in order to measure com