Excel I - Formulas, functions and data (EN)

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

Contents

• Rules for entering a formula into a cell
• Copying formulas
• Referencing in patterns between leaves

• Arithmetic operators
• The text operator was not an ampersand

• Relative addressing
• Absolute addressing
• Mixed addressing

• 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

• Simple rules
• Complex rules with functions

• Automatic creation of subtotals - summaries

• TODAY
• NOW
• WEEKNUM
• ISOWEEKNUM
• YEAR
• MONTH
• DAY
• DATE
• WORKDAY
• NETWORKDAYS

• LEFT
• RIGHT
• MID
• LEN
• FIND
• CONCAT
• CONCATENATE
• TRIM

Prerequisites

Study Materials

Followups