This class is an intermediate Excel class. Topics covered include:
Week 1: The Countdown Project
•	Shade cells
•	Change font style and color
•	Adding a border around a cell range
•	Today formula
•	Subtraction formula

Week 2: The Dunder Mifflin Project
•	Data List (Drop Down)
•	Conditional Formatting
•	Create an Error Message
•	Freeze Rows
•	Concat Formula
•	Multiplication Formula
•	Year(Today) Formula
•	Subtraction Formula

Week 3: The Dice Project
•	If formula
•	Or formula
•	Randbetween formula
•	Macro button
•	Borders

Week 4: The Caesar Cipher Project
•	Vlookup Formula
•	Offset Formula
•	Define Cell Range
•	Cell Formatting
•	Label Worksheets

How is this class Taught?
This is a project-based learning class. 
On the first day of class:
•	Provide all 4 projects we will work on in class
•	Show the class where to find all the tutorial videos needed for class
Each week we will meet online for about 20 minutes. During our meeting, I will:
•	Show and explain the week’s project
•	Review the written project requirements
•	Show where to find all the resource tutorial videos
•	Explain anything that might challenge students on the project
•	Answer all student’s questions
Students will be given a week to complete the project and are welcome to email me if they have any questions. The completed project must be submitted to me at least one day before our next meeting. After reviewing the project, I will provide constructive feedback to encourage the students.

Why I do not show how to do the projects step-by-step?
Empowering students with the confidence to tackle any Excel-related problem is crucial. By presenting them with Excel tasks, students can develop their Excel skills and confidence and other important skills such as research, critical thinking, and problem-solving, which are helpful in both academic and real-life settings. Simply memorizing information is not an effective way to learn Excel or most other subjects. Instead, students should focus on learning how to locate and process information in order to create practical solutions.

Why do I have students add something extra to each project?
More than 1 billion people worldwide use a Microsoft Office product. Although many can discover online solutions for MS Office, creativity is what sets individuals apart. In today's world, being able to think beyond the conventional and develop innovative solutions is what separates one from the crowd.

Are there prerequisites?
This is an intermediate Excel class. Before starting class, students should know how to add data to a worksheet, do simple formulas (add, subtract, multiply), for format cells.