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.
Kurz je možné absolvovať bezplatne cez program Kompas+.
- 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
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.
Neváhajte nás kontaktovať ohľadom ďalších informácií a požiadaviek na kurz IT Training - Microsoft Excel for advanced:
Hodnotenia kurzu IT Training - Microsoft Excel for advanced