Excel Intermediate e-learning

Excel Intermediate e-learning

Get more out of Excel! In our intermediate Excel e-learning material, we take a step up from the basics and show formulas and tricks in our instructional videos that will significantly ease your work. You can immediately try out the novelties in the practice exercises of the instructional material.

Összegzés
23 témakör
134 lap
23 önellenőrző teszt
93 kép
28 oktatóvideó
Letölthető gyakorló feladatok
Teljesítés feltétele és igazolása
A teljesítés feltétele az összes lap megtekintése
A tananyag teljesítését tanúsító Igazolás a rendszerből tölthető le

Excel Intermediate e-learning

The e-learning material builds on a basic knowledge of Excel and introduces more efficient and advanced ways of using the application. It helps learners deepen their understanding of formulas and functions, including nested functions, conditional calculations, and lookups using the VLOOKUP and XLOOKUP functions. The course also covers features that support everyday work, such as error handling, working with date, time and text data, advanced filtering and Paste Special, conditional formatting, and identifying duplicate values. It also introduces the use of charts and sparklines, the Table feature, and the creation of PivotTables.

Price: HUF 23,000. By clicking the DEMO button, you can view one of the lessons of the course material without registration.

Access duration: 365 days

Flexible learning: The e-learning course can be completed independently, according to your own schedule and at your own pace. The course material can be accessed anytime and from anywhere during the access period, allowing learning to be flexibly incorporated into your daily schedule. Completing the entire course is to take approximately 15 hours.

1. Introduction, Useful Tips and Tricks in Excel
2. Formatting Tables, Number Formats
3. Paste Special
4. Calculations in the Table - Repetition
5. Using Functions - Repetition
6. The IF function
7. Nesting Functions
8. The COUNTIFS Function
9. SUMIFS and AVERAGEIFS Functions
10. Searching with the VLOOKUP Function
11. Searching with the XLOOKUP Function
12. Error Handling
13. Rounding Numbers
14. Handling Date and Time Values in Excel
15. Text Handling in Excel
16. Text Functions
17. Other Functions Related to Formulas
18. Use of Advanced Filtering
19. Conditional Formatting
20. Filtering Duplicates
21. Charts and Sparklines
22. Table function
23. Creating a Pivot Table

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: