Course description
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.
Required knowledge
Basic knowledge of PC and Excel.
Course content
Logic functions
- IF including nesting
- IFS
- AND
- OR
- IFERROR
Conditional functions
- SUMIF and SUMIFS
- COUNTIF and COUNTIFS
- AVERAGEIF - AVERAGEIFS
- MAXIFS
- MINIFS
Search function
- VLOOKUP
- HLOOKUP
- INDEX
- MATCH
- INDIRECT
- XLOOKUP
Inserting formulas and functions
Creating a report
Working with the database
Materials
The course includes trainings materials and excersices.