Excel VLOOKUP & Other IF"y" Functions: Bits & Bytes|System Source

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.


12/18/24 - VIR - Live Virtual Demo w/ Q&A - Live Virtual Demo w/ Q&A	(click to enroll)
03/19/25 - VIR - Live Virtual Demo w/ Q&A - Live Virtual Demo w/ Q&A	(click to enroll)

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

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

None

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

Other Bits & Bytes sessions and Microsoft Office courses.

Excel VLOOKUP & Other IF"y" Functions: Bits & Bytes

Course Overview

Scheduled Classes

What You'll Learn

Outline

Prerequisites

Who Should Attend

Next Step Courses