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

Excel - Getting Started with Formulas and Functions (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? In the course we will show you how easy it is to calculate in Excel. 

We will introduce you to the basic rules for entering formulas and how to easily copy formulas to the entire table. We will clearly show the operation of formulas when copied to a table and explain the principle of relative and absolute addressing in formulas.

Cíle kurzu

  • Entering formulas

  • Using operators in formulas

  • Addressing in samples

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


Basic work with PC.


Excel - Large amount of data and visualization, Excel - Functions for working with text and calendar dates, Excel - Logical and conditional functions, Excel - Top 6 search functions, Excel - Introduction to reporting with contingency table, Excel - Advanced reporting, Excel - Interactive dashboards, Excel macros - Easy uploading, Excel: macros - Don't be afraid of code or an introduction to understanding VBA

Excel - Getting Started with Formulas and Functions (EN)

Vybraný termín:

29.11.2021  Online

900 Kč + 21 % DPH

Termíny kurzu

Kontaktovat dodavatele

Kontrola proti spamu. Kolik je devět a pět ? Součet zapište číslicemi.