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.