logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel VLOOKUP & Other "IF"y Statements: MegaBytes

SS Course: 3000648

Course Overview

TOP

During this two-hour live hands-on training, our top-rated instructor will teach how to use advanced Excel functions and formulas to help retrieve data quickly. These tips will help improve the accuracy of your workbooks while saving a ton of time and minimizing data entry errors. Students are encouraged to ask questions during this hands-on session.

                                                                  

Scheduled Classes

TOP
08/27/24 - HC1 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
11/13/24 - HC3 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During this hands-on training you will learn to:

  • Create & Use COUNTA functions
  • Create & Use SUMIF functions
  • Create & Use COUNTIF functions
  • Create & Use IF formulas
  • Use VLOOKUP

Outline

TOP
Viewing outline for:
  • Create & Use COUNTA functions
    • Counts cells that contain numbers, text, logical values and error values but not empty cells
  • Create & Use SUMIF functions
    • Function sums cells that meet certain criterion
  • Create & Use COUNTIF functions
    • Function counts cells that meet certain criterion
  • Create & Use IF formulas
    • Checks whether a condition is met
    • Returns differing values based upon the answer
  • Use VLOOKUP
    • Short for vertical lookup
    • Designed to work with data that is organized in columns
  • Prerequisites

    TOP
    Successful students will have completed Excel Part 1 training or have equivalent experience.

      Who Should Attend

      TOP

      Students who wish to learn about the Lookup and Logical functions in Excel. The training is categorized as intermediate-to-advanced.

      Next Step Courses

      TOP

      Other Bits & Bytes sessions and Microsoft Office courses.