Show all
Log in
0
Basket
0,00 €
Log in
0
Basket
0,00 €
Pumpedu Microsoft for users MS Excel Excel I - Formulas, functions and data

Excel I - Formulas, functions and data

Would you like your tables to be able to count? Need to clean and organize your data?
Do you export data from your system to Excel and need to modify them? Need to quickly calculate how long a project lasts? We'll show you how.
Level
Designed for participants without knowledge and experience
basic
Course length
1 day
Language
cz eu
Course code
KT22070061
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
24. 2. 2025 09:00 - 17:00
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT22070061-0022
Price without VAT
2 490 Kč
Order
2. 4. 2025 09:00 - 17:00
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: KT22070061-0019
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: KT22070061-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: KT22070061-0002
Price without VAT
2 490 Kč
Order

Expressions of participants

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 Látal
Glenmark Pharmacuticals Distribution s.r.o.
"The lecturer is very good at explaining and passionate about the subject. She explains very well."
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."
Jana M.
"I have no negative comments, the course and the teacher are absolutely great. The online form is perfectly suitable for this topic."
ilustrační obrázek Sylvie Z.
Sylvie Z.
"I really enjoyed doing the course. The lecturer responded perfectly to questions, professionalism at the maximum level."
Monika V.
"Greatly organized training and I learned a lot beyond expectations. "
More

Course description

We will introduce you to the basic rules for entering and functioning of formulas. We will show you tools that will help clean up and organize data into a database. This is a tool for text into columns, removing duplicates, finding empty cells and filling them. We will guide you through the most frequent functions DATE, TIME and text functions.

Required knowledge

Basic work with PC and Excel.

Target audience

To all Excel users. Suitable for beginners.

Course content

Entering formulas
  • Rules for entering a formula into a cell
  • Copying formulas
  • Referencing in patterns between leaves
Using operators in formulas
  • Arithmetic operators
  • The text operator was not an ampersand
Addressing in samples
  • Relative addressing
  • Absolute addressing
  • Mixed addressing
Editing a table into a database form
  • Text in columns
  • Remove duplicates
  • Find empty cells
  • Data filtering
  • Setting of partitions
  • Set up drop-down lists in cells
  • Sort records in a table
  • Header and footer
  • Print larger tables
  • Database table
Data visualization - conditional formatting
  • Simple rules
  • Complex rules with functions
Subtotals in tables
  • Automatic creation of subtotals - summaries
Date and time functions
  • TODAY
  • NOW
  • WEEKNUM
  • ISOWEEKNUM
  • YEAR
  • MONTH
  • DAY
  • DATE
  • WORKDAY
  • NETWORKDAYS
Text functions
  • LEFT
  • RIGHT
  • MID
  • LEN
  • FIND
  • CONCAT
  • CONCATENATE
  • TRIM

Materials

The course includes trainings materials and excersices.

Objectives

  • Entering formulas
  • Using operators in formulas
  • Addressing in samples
  • Editing a table into a database form
  • Data visualization - conditional formatting
  • Subtotals in tables
  • Know the functions DATE, TIME.
  • Know TEXT functions.

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

Follow-up courses

Expressions of participants

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 Látal
Glenmark Pharmacuticals Distribution s.r.o.
"The lecturer is very good at explaining and passionate about the subject. She explains very well."
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."
Jana M.
"I have no negative comments, the course and the teacher are absolutely great. The online form is perfectly suitable for this topic."
ilustrační obrázek Sylvie Z.
Sylvie Z.
"I really enjoyed doing the course. The lecturer responded perfectly to questions, professionalism at the maximum level."
Monika V.
"Greatly organized training and I learned a lot beyond expectations. "
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