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

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
04.05.2017
- 05.05.2017

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

Infolinka na počítačové kurzy a manažérske školenia

Infolinka:

02/ 55 410 308

0948 88 41 88

0948 88 40 88

0903 28 68 48

 

Zasielanie noviniek

 

Nákupný košík

 
Školiace centrum Macrosoft - pocitacove-taboryŠkoliace centrum Macrosoft - obchodne-skolenia
Školiace centrum Macrosoft - asertivna-komunikaciaŠkoliace centrum Macrosoft - kurzy-pre-asistentkyŠkoliace centrum Macrosoft - efektivna-komunikacia

Prihlásenie

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