Excel Advanced e-learning course

Would you like to become a true Excel pro? Our e-learning course includes all the functions that can make your work easier. To help you learn efficiently, our instructors demonstrate how to use formulas—and many other super useful Excel tricks—through easy-to-follow videos. You can also practice what you've learned with exercises integrated into the course. And the best part? You decide when and where to study, because our course is available online.

Unfamiliar with the e-learning form of learning? Try it out through our free, registration-required Excel bacis E-learning course to decide if it's right for you.

See what this material has in store for you!

Összegzés
241 lap
19 teszt
212 kép
60 videó, film
Publikálva: 2025.07.21
Teljesítés feltétele
Ö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 25,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.

1. Using Nested Functions in Formulas
2. Logical Functions
3. Using VLOOKUP for Range Lookups, Search by Multiple Criteria
4. Look Up Values with INDEX and MATCH functions
5. Using Array Formulas
6. Searching with the XLOOKUP function
7. Date Functions
8. Combining Texts
9. Statistical Functions
10. Financial Functions
11. Database Functions
12. Other Special Formulas and Functions
13. Using Conditional Formatting
14. Protection
15. Data Validation I.
16. Sharing Workbooks
17. Charts
18. PivotTable (Advanced Options), Consolidate feature
19. Other Useful Features

Köszönjük értékelését!

Ha szeretne szöveges értékelést is megadni, kérjük írja le véleményét:

Tananyagok

rendezés:
Sajnos nincs találat.