Microsoft Excel Level 3

Microsoft Excel Level 3

Instructional Design & Instructing (In-Class): Advanced Microsoft Excel

ICT417-035 Microsoft Excel Level 3 | Peak Ed Design Instructional Design Portfolio

Project Summary

I was asked by the Continuing Education Department of the University of Calgary to build a 14-hour, 5-week in-class advanced course on Microsoft Excel. I was given a textbook to use, broke it down into slides and assessments to meet the intended course outcomes and instruct ICT417: Microsoft Excel Level 3.

Course Outcomes included:
  • Use advanced formatting features
  • Use table names
  • Use advanced functions in Excel
  • Check for errors in formulas
  • Use the data validation feature
  • Use pivot tables and pivot charts
  • Use Power Pivot to extend pivot tables and charts into databases
  • Enable workbooks to work with other workbooks and users
  • Protect worksheets and workbooks from changes
  • Use advanced features with charts and functions
  • Use advanced functions
  • Perform a What-If analysis
  • Used structured references
  • Use advanced Excel features to filter data
  • Extend a data series by filling
  • Use form controls
  • Record and copy macros