Excel II - Logical, conditional and search functions (EN)

Description

Logical and conditional functions in Excel are often a big problem for end users. 
We will introduce you popular search functions in Excel.
We will help you prepare for the practical part of the job interview, where the Excel test awaits you.

We will explain, for example, the WHEN/IFS logical function, including its nested variant. Among other logical functions, we can include the logical connection AND, OR.
We will also advise how to solve conditional sums, numbers, averages. We'll show you how the function can match data exactly, but also about the approximate match in case we need to match numbers into intervals.
Next, we will introduce you to the top 6 search functions. All search functions should be handled by the IFERROR function in case the function returns an error condition.
We know from experience that the practical part of the interview in Excel tests "traditional" Excel tools, which we will guide you through so that you are well prepared for the interview.

Goals

• Know Logical Functions
• Know Conditional Functions
• Know the TOP 6 search functions in Excel and be able to use them.
• Know the traditional tools and functions of Excel.

Target

Contents

• IF including nesting
• IFS
• AND
• OR
• IFERROR

• SUMIF and SUMIFS
• COUNTIF and COUNTIFS
• AVERAGEIF - AVERAGEIFS
• MAXIFS
• MINIFS

• VLOOKUP
• HLOOKUP
• INDEX
• MATCH
• INDIRECT
• XLOOKUP

• VALUE
• LEFT
• RIGHT

• pivot table

• data filtering

Prerequisites

Study Materials

Followups