For work, office, private business. The course includes eleven different type of functions, most common used in HR department, personal assistant, accountancy.
You will understand the most used type functions – date, logical. text. You will also know the difference between search and find and how to get together data from several cell into one.
You also will know how to calculate the days off of employees or to calculate passed days to current date.
They are presented Pivot tables, data base, creation of links to external sources and advantages of external sources using.
It is also explained what stands for mistakes in EXCEL, logical operators and how to handle them.
You will ding how to do extend formatting, how to create Pivot table.
You will learn how to sort data, how hide information.
How to work with SUBTOTAL function and what does it means.
SUMIF, SUMIFS, COUNTIF, COUNTIFS, TRIM, VLOOKUP, XLOOKUP.
conditional formatting, iferror, INDIRECT, PMT,
Curriculum
- 2 Sections
- 1 Lesson
- 10 Weeks
- ЛЕКЦИИ1
- ТЕСТ0
Requirements
- Basic knowledge in excel
Features
- Different types functions, pivot tables, handle big data base.
Target audiences
- Students, teachers, employees in business structures or public institutions.