MSE100: Microsoft Excel- Guided Workshop

In this class, students will learn how to use some of the essential functions and features of Microsoft Excel. Some lessons give the students exact step-by-step directions on how to complete each project. Some lessons have the students start with a beginning file and perform individual formatting tasks. I will include an example of their finished project in the welcome packet I send out.

The following are some of the topics we will cover during our 16-week course:

  • Microsoft Excel Vocab Quiz and Word List
  • Vocabulary Definitions Slideshow
  • Vocabulary Quiz and Word List
  • Pixel Art
  • Formatting Cells
  • Dates, Alignment, Pictures, Cell Styles
  • Working with Tables
  • Wedding Playlist SmartArt
  • Hyperlinks and Images
  • Working with Charts
  • Basic Functions and Formulas
  • Text and Math Functions
  • Conditional Formatting
  • IF Functions and Formulas (IF, SUMIF, COUNTIF, AVERAGEIF)
  • Intermediate Functions and Formulas (AND, OR, RIGHT, LEFT)
  • Defining Range Names
  • Cell References
  • Importing External Data
  • VLOOKUP Functions and Formulas
  • Nested IF THEN Functions and Formulas

OBJECTIVE

This course aims to help students learn the basic functionalities of Microsoft Excel and strengthen their skills in following written and visual instructions.

GRADES

6th-12th

REQUIRED MATERIAL

You will need to access your student portal every week to complete the assignments and engage in the weekly Zoom discussions. All reading material will be provided to you in your lesson tab. This class involves outside research.

I will provide students with instructions for Microsoft Excel for Windows (2016) and Microsoft Excel for Windows (2019). However, during our Zoom lessons, I will be using Microsoft Excel for Mac Version 16.59. If a student uses any other version, I will teach them how to locate features in the application to help themselves find solutions regardless of the version they use.

EARNING POTENTIAL UPON COMPLETION

513 points

FIRST COURSE DATE & TIME

September 14, 2022, from 12:30 pm to 1:25 pm PST

LAST COURSE DATE & TIME

January 18, 2022, from 12:30 pm to 1:25 pm PST

CHARTER FUNDS

This instructor accepts charter school funds.

MSE100: Lesson 1

1
MSE100: Lesson 1
2
MSE100: Lesson 1 Quiz

MSE100: Lesson 2

1
MSE100: Lesson 2
2
MSE100: Lesson 2 Quiz

MSE100: Lesson 3

1
MSE100: Lesson 3
2
MSE100: Lesson 3 Quiz

MSE100: Lesson 4

1
MSE100: Lesson 4
2
MSE100: Lesson 4 Quiz

MSE100: Lesson 5

1
MSE100: Lesson 5
2
MSE100: Lesson 5 Quiz

MSE100: Lesson 6

1
MSE100: Lesson 6
2
MSE100: Lesson 6 Quiz

MSE100: Lesson 7

1
MSE100: Lesson 7
2
MSE100: Lesson 7 Quiz

MSE100: Lesson 8

1
MSE100: Lesson 8
2
MSE100: Lesson 8 Quiz

MSE100: Lesson 9

1
MSE100: Lesson 9
2
MSE100: Lesson 9 Quiz

MSE100: Lesson 10

1
MSE100: Lesson 10
2
MSE100: Lesson 10 Quiz

MSE100: Lesson 11

1
MSE100: Lesson 11
2
MSE100: Lesson 11 Quiz

MSE100: Lesson 12

1
MSE100: Lesson 12
2
MSE100: Lesson 12 Quiz

MSE100: Lesson 13

1
MSE100: Lesson 13
2
MSE100: Lesson 13 Quiz

MSE100: Lesson 14

1
MSE100: Lesson 14
2
MSE100: Lesson 14 Quiz

MSE100: Lesson 15

1
MSE100: Lesson 15
2
MSE100: Lesson 15 Quiz

MSE100: Lesson 16

1
MSE100: Lesson 16
2
MSE100: Lesson 16 Quiz
Yes, there will be exams every week.
No, there will be no assignments in this class.

EXPECTATIONS

Respect each other. The most important rule for our class is to respect one another. You do not need to agree with someone to communicate respectfully. Let’s keep this in mind when we interact with one another.

Be prepared for each lesson. Students must complete the assigned work and research for each week to earn points. It will help you get the most benefit out of this course if you take the activities seriously and put in the effort to learn. Additionally, you are encouraged to reach out to your instructor for additional guidance.

Basic research skills. This course is for students who have a basic working knowledge of online research. You should know how to employ proper online search techniques to conduct effective research.

Enjoy the class. Being prepared is essential, but you should never forget to enjoy your experiences. This class will help you achieve your goals by introducing you to valuable tools and resources and presenting information you can continue to utilize throughout your life.

INSTRUCTIONS

I will provide students with instructions for Microsoft Excel for Windows (2016) and Microsoft Excel for Windows (2019). However, during our Zoom lessons, I will be using Microsoft Excel for Mac Version 16.59. If a student uses any other version, I will teach them how to locate features in the application to help themselves find solutions regardless of the version they use. 


Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Get course
Enrolled: 0 students
Duration: 16 Weeks
Lectures: 16
Video: 55 minutes
Level: Beginner

Archive

Working hours

Monday 9:00 a.m. - 4:30 p.m.
Tuesday 9:00 a.m. - 4:30 p.m.
Wednesday 9:00 a.m. - 4:30 p.m.
Thursday 9:00 a.m. - 4:30 p.m.
Friday 9:00 a.m. - 4:30 p.m.
Saturday Closed
Sunday Closed
MSE100: Microsoft Excel- Guided Workshop
Price:
$295 $255