Show all

Excel - Getting Started with Formulas and Functions

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. 
Level
Designed for participants without knowledge and experience
basic
Course length
3 hours
Language
 cz  eu
Course code
PU21070091
MS Excel
Category:
Do you want this tailor-made course to your company? Contact us
 

This offer is no longer valid, please choose another one from our offer.

If you are interested in a piece, try us contact

Course description

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.

Required knowledge

Basic work with PC.

Target audience

To all Excel users. Suitable for beginners.

Course content

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

Objectives

  • Entering formulas
  • Using operators in formulas
  • Addressing in samples

Do you want this tailor-made course for your company?

Contact us

News with the course

Náhledový obrázek novinky
Microsoft 365 7. 3. 2024
Microsoft 365 adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

Follow-up courses

Do you want this tailor-made course for your company?

Contact us

News with the course

Náhledový obrázek novinky
Microsoft 365 7. 3. 2024
Microsoft 365 adoption

Microsoft 365 adoption represents the process of a company's digital transformation. It assists employees in acclimating to new technology, establishing usage rules, and fostering collaboration. Mere tool installation is not sufficient.

Why with us