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

Předpoklady

Basic work with PC.

Návaznosti

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

Cena
900 Kč + 21 % DPH

Termíny kurzu

Kontaktovat dodavatele


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