(in Polish) Kurs komputerowy-zaawansowany Excel 0800-KK-ZEXEL

1. Introduction to Excel
2. Operations on cells, cell areas and sheets
3. Formulas and functions
a. Date and time
Formulas that facilitate work on the text
c. Creating formulas that count and sum up
d. Creating formulas that search for values
e. Creating formulas for financial applications
f. Database functions
g. Introduction to table formulas
h. Conditional formatting
4. Table and scope of data
5. Sorting and filtering data
a. Advanced filters
6. Data analysis
a. What-if analysis
b. Scenarios
c. Data analysis using the Search result and Solver function
d. Data table
e. Data analysis using pivot tables
7. Consolidation of sheets
8. Data protection
9. Techniques for creating charts
10. Programming in VBA
a. Basic information about VBA macros
i. Sub Procedures of VBA
ii. VBA language functions
b. Creating dialog boxes
i. InputBox and MsgBox function
ii. Working with UserForm forms
c. Adding controls
d. Application in dialogs control dialogs
e. Working with Excel events