Courses with lecturer

Term

Language

Place

Form

Price without VAT

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT22070061-0001

Price without VAT

2 490 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT22070061-0002

Price without VAT

2 490 Kč

Order

Expressions of participants

Lucie Řejhová

"
The lecturer's presentation was very pleasant, without any monotony, so I was able to maintain my attention and concentration throughout the entire course. I learned a great deal. Simply put, 5 out of 5 stars. :-)
"

Lenka Marčínyová

"Lecturer Mr. Hess is captivating from start to finish. The training was great. Thank you very much for it. I got a lot out of it."

E. Kočárková
FIEGE s.r.o.

"The lecturer was able to cope with the diverse composition of the groups and with his patient, pleasant and human approach he won over even staunch opponents of Excel. His preparedness, understandable materials, flexibility and punctuality are just another pleasant bonus."

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

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

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

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?

News with the course

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

Excel II - Logical, conditional and search functions