Excel intermediate e-learning course

Összegzés
137 lap
23 teszt
93 kép
28 videó, film
Publikálva: 2025.05.23
Teljesítés feltétele
Összes lap megtekintése

Excel intermediate e-learning course The intermediate online course is recommended for those who are already familiar with the basics of spreadsheet management and would like to advance further. The knowledge of each topic is primarily contained in the videos included in the lessons. The introduction provides information on what the specific video will cover and also allows downloading the spreadsheet used in the video. 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 12 hours of study. The main topics of the intermediate course include: Using custom formats, Paste special, Using more complex formulas, other functions, Advanced filtering, Conditional formatting, Advanced settings for charts, Creating a pivot table.


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: