logo
ABD
LiveZilla Live Chat Software



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

Excel Bits & Bytes: VLOOKUP & Other 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.

Scheduled Classes

TOP
12/12/19 - VIR - Virtual Online Training - Virtual Instructor-Led

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.