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

Excel - Getting Started with Formulas and Functions (EN)

e-kurz

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

Bližší popis na stránkách dodavatele