Počítačové kurzy, manažérske kurzy, obchodné školenia a kurzy rozvoja osobnosti. Renomované školiace centrum v Bratislave
02/55 410 308

Hodnotenia kurzov

Kurz IT Training - Microsoft Excel for advanced

Kurz IT Training - Microsoft Excel for advanced

The course is designed for Excel users who have experience with Excel spreadsheets and want to supplement or enrich it with new opportunities.

Minimálne vstupné vedomosti: Routinely control of PC, experience with Excel: setting cell format, copy the content and format, the absolute and relative links, work with functions, filtering and sorting table, charting, printing output settings.

Termíny kurzov IT Training - Microsoft Excel for advanced:
Denné kurzy (2 dni): 9:00 - 15:00
14.12.2017
- 15.12.2017

22.02.2018
- 23.02.2018

19.04.2018
- 20.04.2018

14.06.2018
- 15.06.2018

09.08.2018
- 10.08.2018

04.10.2018
- 05.10.2018

Večerné kurzy (3 dni): 16:30 - 19:30
04.12.2017
- 06.12.2017

08.01.2018
- 10.01.2018

12.02.2018
- 14.02.2018

19.03.2018
- 21.03.2018

23.04.2018
- 25.04.2018

Víkendové kurzy (2 dni): 8:30 - 13:30
16.12.2017
- 17.12.2017

27.01.2018
- 28.01.2018

03.03.2018
- 04.03.2018

07.04.2018
- 08.04.2018

12.05.2018
- 13.05.2018

Cena kurzu: 230.00 / 276.00 EUR s DPH

Osnova školenia IT Training - Microsoft Excel for advanced

  • Resume of work with formulas and functions in Excel, the syntax of functions, features and nesting
  • table - making spreadsheet calculations
  • creation of forms, controls, and adjusting their format
  • data validation: validation criteria, input message and error message
  • options to lock cell, sheet, workbook and the file
  • paste special function and its use in practice
  • setting the name of areas with formulas
  • matrix formulas: their use, one- and two-dimensional matrix
  • search functions: LOOKUP, VLOOKUP, HLOOKUP, CHOOSE, MATCH, INDEX
  • logical functions: IF, IF immersion, AND, OR
  • text functions: CONCATENATE, FIND, SEARCH, LEFT, RIGHT, MID, SUBSTITUTE
  • Working with automatic and advanced filter: limit of automatic filter, filter with difficult conditions, use wildcard characters in the text criteria
  • creation of simple and nested subtotals
  • tool for merging multiple ranges
  • pivot tables: arrays of rows, columns, pages and data area, field settings, features of an entire table, grouping
  • the Solver add-in: optimization problems, input conditions
  • Discussion

Výstupné vedomosti: Mastering the use of Excel as a comprehensive tool to planning, making decisions and evaluation. Creating a professional application designed for automatic data processing, including control mechanisms.

Zobraziť všetky kurzy z kategórie Kurzy Excel

Neváhajte nás kontaktovať ohľadom ďalších informácií a požiadaviek na kurz IT Training - Microsoft Excel for advanced:

Kontaktujte nás

Meno:
E-mail:
Predmet správy:

Správa:

Hodnotenia kurzu IT Training - Microsoft Excel for advanced

Zasielanie noviniek

Garancia vedomostí
Možnosť zopakovania si
kurzu pre absolventov

Video z kurzu

Pečať finančnej stability

TOPlist
Pečať finančnej stability
Website Chat na Počítačové kurzy