Show all
Log in
0
Basket
0,00 €
Log in
0
Basket
0,00 €
Pumpedu Microsoft for users MS Excel Excel II - Logical, conditional and search functions

Excel II - Logical, conditional and search functions

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.
Level
Designed for participants with basic knowledge and experience
intermediate
Course length
1 day
Language
cz eu
Course code
PU22070062
Order 
MS Excel
Category:
Microsoft for users MS Excel
Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
27. 1. 2025 09:00 - 17:00
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: PU22070062-0024
Price without VAT
2 490 Kč
Order
19. 2. 2025 09:00 - 17:00
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: PU22070062-0027
Price without VAT
2 490 Kč
Order
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: PU22070062-0001
Price without VAT
2 490 Kč
Order
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: PU22070062-0002
Price without VAT
2 490 Kč
Order

Expressions of participants

Zdeňka Matulová
"Nicely done and understandable presentation of the course by the lecturer, balanced topics, well-chosen examples and practical demonstrations."
Kristýna Tůmová
Glenmark Pharmacuticals Distribution s.r.o.
"To the point, practical, entertaining, informative, emphasis on the practical part, which I really appreciate.
The lecturer was educated, empathetic, funny."
Zuzana B.
"Great energy. The lecturer manages to keep your attention from the beginning of the training to the end."
Petr Klusák
Glenmark Pharmacuticals Distribution s.r.o.
"It was amazing, very practical, the lecturer was absolutely fantastic!"
Petr Látal
Glenmark Pharmacuticals Distribution s.r.o.
"The lecturer is very good at explaining and passionate about the subject. She explains very well."
Petra Houdová
DNS a.s.
"Once again, thank you very much for the excellent training on excel and learning the xlookup function, which I will use in practice."
Lucie S.
ČD - Telematika
"An amazing lecturer who knows what she is doing and can pass on her knowledge. Great satisfaction."
Zuzana Fousková
DNS
"Absolutely great, Jana is a pro. She excels in Excel, and on top of that, the energy, liveliness and humor. BRAVO."
ilustrační obrázek Jana P.
Jana P.
Activity agency s.r.o.
"I am extremely satisfied, the course was excellent in all respects. The course was conducted very well by the lecturer. I liked the content. I will definitely use the new information in practice.
The pace of the interpretation was just right. The lecturer always responded flexibly to questions and explained clearly."
Ivan H.
ČD - Telematika
"Excellent lecturer, the course was very beneficial."
More

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.

Target audience

To all Excel users.

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

Materials

The course includes trainings materials and excersices.

Objectives

  • 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.

Lecturers

Microsoft Office Specialist
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 training, they also create websites, templates, graphic designs and more. They always adapt each training to the customer's needs. Customers are often sought after for their distinctive style and professional approach.

Certification holders:

  • Microsoft Certified Trainer
  • Microsoft Office Specialist
  • Microsoft Office Expert

Do you want this tailor-made course for your company?

Contact us

News with the course

Náhledový obrázek novinky
Microsoft 365 7. 3. 2024
Microsoft 365 Adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

More news

Previous courses

Follow-up courses

Expressions of participants

Zdeňka Matulová
"Nicely done and understandable presentation of the course by the lecturer, balanced topics, well-chosen examples and practical demonstrations."
Kristýna Tůmová
Glenmark Pharmacuticals Distribution s.r.o.
"To the point, practical, entertaining, informative, emphasis on the practical part, which I really appreciate.
The lecturer was educated, empathetic, funny."
Zuzana B.
"Great energy. The lecturer manages to keep your attention from the beginning of the training to the end."
Petr Klusák
Glenmark Pharmacuticals Distribution s.r.o.
"It was amazing, very practical, the lecturer was absolutely fantastic!"
Petr Látal
Glenmark Pharmacuticals Distribution s.r.o.
"The lecturer is very good at explaining and passionate about the subject. She explains very well."
Petra Houdová
DNS a.s.
"Once again, thank you very much for the excellent training on excel and learning the xlookup function, which I will use in practice."
Lucie S.
ČD - Telematika
"An amazing lecturer who knows what she is doing and can pass on her knowledge. Great satisfaction."
Zuzana Fousková
DNS
"Absolutely great, Jana is a pro. She excels in Excel, and on top of that, the energy, liveliness and humor. BRAVO."
ilustrační obrázek Jana P.
Jana P.
Activity agency s.r.o.
"I am extremely satisfied, the course was excellent in all respects. The course was conducted very well by the lecturer. I liked the content. I will definitely use the new information in practice.
The pace of the interpretation was just right. The lecturer always responded flexibly to questions and explained clearly."
Ivan H.
ČD - Telematika
"Excellent lecturer, the course was very beneficial."
More

Do you want this tailor-made course for your company?

Contact us

News with the course

Náhledový obrázek novinky
Microsoft 365 7. 3. 2024
Microsoft 365 Adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

More news

Why with us

Online training, classroom courses, e-Learning, webinars, etc.
We create custom courses that you won't buy anywhere else
Experienced team of experts
Course and staff management tool