Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

Excel I - Formulas, functions and data (EN)

Kurzem Vás provede 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…

Základní info

Popis kurzu

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.

Cíle kurzu


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

Určeno pro

To all Excel users. Suitable for beginners.

Obsah kurzu

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

Předpoklady

Basic work with PC and Excel.

Studijní materiály

The course includes trainings materials and excersices.

Návaznosti

Excel II - Logical, conditional and search functions

Excel I - Formulas, functions and data (EN)

Vybraný termín:

8.12.2022  ONLINE

Cena
1 900 Kč + 21% DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je šest a tři ? Součet zapište číslicemi.