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.
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
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