Beginning Excel - Week 5: Charts!

If you haven't checked out my syllabus for my 5-week Beginning Excel class, you can find it here. 

If you missed Week 1 - The Basics, you can find that here.

If you missed Week 2 - The Worksheet, you can find it here.

If you missed Week 3 - Formulas, you can find it here.

If you missed Week 4 - Formatting, you can find it here.

If you are looking to purchase the book I use for this course, you can find it used and fairly inexpensive here. There may be some new or hardcover, but I generally use spiral bound.

Charts are fun! And my students always enjoy doing Charts on the last day of our 5-week course.

Charting is easy when you have a plan. Normally, I have my students track sales. Most of them enter my class with a general understanding of how businesses operate. So, we track sales.

Most of my charts look a little something like this:

I have my students put these into their worksheet. And then the real FUN begins. 

The Charts icon is located at the Insert tab. 

A chart will then appear. You will most likely have to readjust the chart. This is a great exercise to help your students learn the odds and ends of formatting charts. 

Before: 

After:

I try to cover as much as I can when dealing with charts in a 2-hour period. Sometimes we get through a lot; sometimes we get stuck on little things. Whatever the case, my students always walk away able to make a chart using data from a select group of data. 

And when their future job requirements include Excel presentations with fancy graphs, they will be successful.

If you have any questions, please feel free to leave them in the comments.

Looking for a book to teach your Beginning Excel class? Check out MY STORE for all Excel books used to develop my lesson plans.

Happy Teaching! 

Jessica