Excel 2010 | Intermediate

187 CQ
27 Lessons
Course Info
Previous...
  • Playing
    6 CQ
    6. The Nested IF Function Excel 2010
    A lesson with Motion Training
    View lesson

    This Microsoft Excel 2010 lesson will help you to understand and apply Nested IF Functions to a spreadsheet, which create more options for automation.

    The Nested IF Function Excel 2010
    with Motion Training

    This Microsoft Excel 2010 lesson will help you to understand and apply Nested IF Functions to a spreadsheet, which create more options for automation.

  • Playing
    5 CQ
    7. COUNTIF & SUMIF Functions in Excel 2010
    A lesson with Motion Training
    View lesson

    Sorting through lists and creating formulas in Excel 2010 is more efficient when you use functions like COUNTIF and SUMIF. Learn about these Excel functions!

    COUNTIF & SUMIF Functions in Excel 2010
    with Motion Training

    Sorting through lists and creating formulas in Excel 2010 is more efficient when you use functions like COUNTIF and SUMIF. Learn about these Excel functions!

  • Playing
    9 CQ
    8. The VLOOKUP Function in Excel
    A lesson with Motion Training
    View lesson

    Learn how to use the VLOOKUP function in Microsoft Excel 210—a great way to automate data entry in spreadsheets, save time, and avoid errors.

    The VLOOKUP Function in Excel
    with Motion Training

    Learn how to use the VLOOKUP function in Microsoft Excel 210—a great way to automate data entry in spreadsheets, save time, and avoid errors.

  • Playing
    7 CQ
    9. Using Multiple Worksheets in Excel
    A lesson with Motion Training
    View lesson

    In this Microsoft Excel lesson learn how to set up a multiple worksheet workbook, add worksheets, and create calculations that take values from other sheets.

    Using Multiple Worksheets in Excel
    with Motion Training

    In this Microsoft Excel lesson learn how to set up a multiple worksheet workbook, add worksheets, and create calculations that take values from other sheets.

  • Playing
    4 CQ
    10. Calculating Across Excel Worksheets
    A lesson with Motion Training
    View lesson

    Now that you are familiar with working in multiple Microsoft Excel worksheets, learn how to calculate using values from other worksheets in this lesson!

    Calculating Across Excel Worksheets
    with Motion Training

    Now that you are familiar with working in multiple Microsoft Excel worksheets, learn how to calculate using values from other worksheets in this lesson!

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.

Start Interview

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

    2 Comments
    500 characters max

    Deirdre B
    Well explained - thank you
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    conrad g
    nice lesson, very valuable functions we must know well !
    appreciate appreciated
     –  reply
     –  delete
    500 characters max