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 Bits & Bytes: VLOOKUP & Other "IF"y Functions

SS Course: 3000408

Course Overview

TOP

During this one-hour live webinar session, our top-rated instructor will demonstrate 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 in the chat window at any time during the demonstration.

This is a demonstration style webinar and Q&A Session only, no software/files required.

                                                                  

Scheduled Classes

TOP
04/02/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)
06/24/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)
09/26/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During this live demonstration 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

    None

      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.