Microsoft Excel – Advanced

Course Syllabus and Lesson Planner

Course Info: Download PDF  

This course is written for grade levels 6-12. In this class you will learn more about the features available to you in Excel. There will be vidoes and test to tech you new skills and then to be tested on those skills.


In this course there are 5 modules that cover tables, formatting, and macros.

  • Module 1 covers Functions
  • Module 2 covers Tables
  • Module 3 covers Pivot Table Reports
  • Module 4 covers Conditional Formatting
  • Module 5 covers Macros

Course Length:   

As an elective course, we recommend one or two modules / week. Therefore, we feel that this course should take approximately 5 weeks to complete all modules/quizzes, and leave time to study, and take, the final exam. (See Lesson Plan below)

Course Prerequisites (if applicable):


Course Requirements:    

    Computer– Students must have access to a computer with internet access and an internet browser.  Simply STEM has been successfully tested using Internet Explorer, Firefox, Chrome, and Safari.  In addition, we have tested many versions of smart phone/tablet browsers as well.

    Internet Access – Although results may vary, based on connection type and speeds, we have tested our online videos on DSL, Satellite, Cable, and cellular connections.  Our courses cannot be download and require internet access to view them.

Course Grading:  

Grading will be based on quizzes, project uploads, and teacher requirements.

Lesson Plan:
Module 1 – Introduction Week 1
Module 1 – Functions   Week 1
Module 2 – Learning the Tools (part 1)   Week 2
Module 2 – Tables   Week 2
Module 3 – Pivot Table Reports   Week 3
Module 3 – Quiz   Week 3
Module 4 – Conditional Formatting   Week 4
Module 4 – Quiz   Week 5
Module 5 – Macros Week 5
Module 5 – Quiz   Week 5
Study for Final Exam   Week 6
Final Exam Week 6