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

Kurzem Vás provede Microsoft Office Specialist

The lecturers have over 10 years of experience in leading training and belong to the core team of MS Office. In addition to Office, HTML and Adobe…

Základní info

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

To all Excel users.

Contents

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
  • VALUE
  • LEFT
  • RIGHT
Creating a report
  • pivot table
Working with the database
  • data filtering

Prerequisites

Basic knowledge of PC and Excel.

Study Materials

The course includes trainings materials and excersices.

Followups

Excel III - Reporting a Interactive dashboards

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

Vybraný termín:

 ONLINE

Cena
2 490 Kč + 21% DPH

Termíny kurzu

ONLINE
Tento termín

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je jedna a tři ? Součet zapište číslicemi.