Description
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.
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.
Goals
- 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.
Target
To all Excel users. Suitable for beginners.Contents
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
Prerequisites
Basic work with PC and Excel. To fully utilize all features, we recommend accessing the full version of Excel.Study Materials
The course includes trainings materials and excersices.Followups
Excel II - Logical, conditional and search functions
