0:00 / 2:24
 
 
 

Complete Beginner's Guide to Excel

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

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

    Creating Automated Errors in Excel
    with Todd McLeod

    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
    View lesson

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

    Calculating Grades in Excel Gradebook
    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.

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

    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.

    Vlookup Function in Excel Gradebook
    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.

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

    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.

    Freeze Panes & Sorting in Excel
    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.

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

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

    Moving Blackboard Grades to Excel
    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.

More...