| 241 lap | |
| 19 teszt | |
| 212 kép | |
| 60 videó, film | |
| Publikálva: 2026.06.04 |
| Összes lap megtekintése |
Excel advanced e-learning course The advanced online course is recommended for those who already use Excel regularly and want to deepen their understanding of specific functions and formulas. Each topic is primarily covered through lesson videos. The content presented in the videos is also summarized in written form on the following slides. The files used in the exercises can be downloaded by clicking the link below each video. Price: HUF 35,000. By clicking the DEMO button, you can view one of the lessons of the course material without registration. Access duration: 180 days Progress: The e-learning format allows for independent learning according to the user's own schedule and pace. The material can be used at any time during the access period. Completing the online training requires a total of about 20 hours of study. The main topics of the advanced course include: nesting functions and creating complex formulas, logical functions, lookup functions (VLOOKUP, XLOOKUP, INDEX, MATCH), date functions, text functions, array formulas and array functions, financial functions, database functions, other specialized functions, conditional formatting with formulas, workbook protection and shared use, data validation, advanced charts, advanced PivotTable settings and summary functions other useful features.