STEM

# Complete Beginner's Guide to Excel

216 CQ
56 Lessons
Previous...
• Playing
2 CQ
46. Creating Automated Errors in Excel
A lesson with Todd McLeod

In this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!

In this lesson, learn how to deploy conditional formatting to flag potential errors or discrepancies in your Microsoft Excel gradebook spreadsheet!

• Playing
3 CQ
47. Calculating Grades in Excel Gradebook
A lesson with Todd McLeod

In this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.

In this lesson, learn how to build formulas with absolute references to crunch students’ final grades quickly and easily in a Microsoft Excel gradebook.

• Playing
2 CQ
48. Vlookup Function in Excel Gradebook
A lesson with Todd McLeod

Learn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.

Learn how to set up the Vlookup function in MS Excel to calculate a final letter grade for each student in your Microsoft Excel gradebook spreadsheet.

• Playing
2 CQ
49. Freeze Panes & Sorting in Excel
A lesson with Todd McLeod

You’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.

You’ve made a Microsoft Excel gradebook spreadsheet to keep track of student performance. Now, learn how to insert freeze panes and change the sorting criteria.

• Playing
5 CQ
50. Moving Blackboard Grades to Excel
A lesson with Todd McLeod

In this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.

In this lesson, learn how to import a gradebook from Blackboard into Microsoft Excel, and format the spreadsheet for a more user-friendly layout.

More...
• Recommended Recommended
• History & In Progress History
• Browse Library
• Most Popular Library

### Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

You don't have any lessons in your history.
Just find something that looks interesting and start learning!

Comments
500 characters max