Sign In   |   View Cart   |     |   Help
Course Catalog
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Computers > Microsoft Office 2016

Excel Formula Favorites Class: 2013/2016    NEW!

Do you find yourself wanting to go beyond the typical basic Excel formulas like Sum, Average, Min/Max, and Count?
This one-day class will show you how to do just that! You will be able to take your “raw data” in Excel and summarize it even more efficiently by using the following concepts and tools.

You will expand your Excel functions knowledge to include:

  • Logical Functions: If, If error, Sum/Average/Count If
  • Reference Functions: VLOOKUP, Match, Index
  • Text Functions: Concatenate, Large/Small, Left/Right, Upper/Proper/Lower
  • Date Functions: Today, Now

    Performance Objectives:

    Upon completion of this course, participants should be able to:

  • Nested Functions, utilizing a combination of the above formulas for very effective results
  • Text to Columns to split a single column of data into multiple columns
  • Data Validation to expedite the use and application of the above function formulas
  • Subtotals to quickly calculate rows of related data
  • Range names to simplify building function formulas
  • Recognizing and handling typical formula errors

    Competencies covered in this course: Functions and formulas to be used in working with large amounts of data.

    Intended Audience: Anyone who works with large amounts of data in Excel

    Prerequisites: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you have a good understanding of Excel.


    Excel Formula Favorites Class: 2013/2016 NEW!

    Item: C389 Debbie Lonborg
    8:00 AM - 4:30 PM ONLINE
    Sessions: 1 Th Location: ONLINE
    , WA
    3/10/2022 - 3/10/2022 Fee: $275.00

    This class is offered online using Zoom and Excel 2013/2016.

    Zoom Requirements:

    • Access to a computer with speakers & microphone (or the ability to call in via phone).
    • A web camera (suggested but not required).
    • Access to high-speed internet.

    Zoom link will be sent prior to the start of class. You must have Excel 2013/2016 installed on your computer to participate in the class.

    Refund Policy: Cancellations must be received five business days prior to the first day of class in order to receive a full refund.