Excel I - Formulas, functions and data

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.

Basic work with PC and Excel. To fully utilize all features, we recommend accessing the full version of Excel.

To all Excel users. Suitable for beginners.

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

The course includes trainings materials and excersices.

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

Do I need any prior experience with Excel before the course?
Basic PC and Excel skills are enough — the course is designed for beginners and is also suitable for those who have only worked with Excel minimally so far.

Is Excel Online enough, or do I need the full version?
To make full use of all the functions covered in the course, we recommend access to the full desktop version of Excel — the online version may not include all the functions and tools covered.

Will I also learn to work with data exported from another system?
Yes, the course directly covers turning "raw" data into a clean, organized database table — you'll learn tools like text to columns, removing duplicates, finding and filling blank cells, and sorting and filtering records.

What do relative, absolute, and mixed referencing mean in formulas?
These are the ways Excel refers to cells when a formula is copied. Relative references shift when copied, absolute references stay fixed (locked with $), and mixed references combine both approaches — a fixed row or column. Understanding the difference is key to making sure formulas calculate correctly after being copied.

Which specific date and time functions are covered in the course?
The course covers functions like TODAY, NOW, YEAR, MONTH, DAY, DATE, WORKDAY, and NETWORKDAYS — tools for calculating deadlines, working days, and project durations.

What are text functions and what are they useful for?
Text functions like LEFT, RIGHT, MID, FIND, CONCAT, and TRIM are used to split, combine, and clean up text strings — typically useful when working with data imported from other systems, where you need to separate first and last names, remove extra spaces, or combine multiple columns into one.

How long does the course take and in what format is it delivered?
The course is one day long, runs from 9:00 AM to 5:00 PM, and can be taken in person in Prague or online via a virtual classroom.

Which course is it recommended to take after Excel I?
The recommended follow-up course is Excel II – Logical, Conditional, and Lookup Functions, which expands your knowledge with more advanced functions like VLOOKUP, IF, or nested conditions.