Click on Download to open the workbook
Workbook Excel advanced deel 1
Workbook Excel Advanced Part 1 Digital with Realistic Exercises and Examples.
You will learn to work with tables, data analysis, and presenting numbers. Various formulas and functions will also be covered.
Different search methods, Conditional Formatting, and charts will not be forgotten either.
Table of contents of Excel for advanced users Part 1:
1. Carry out using the FILL HANDLE
2. Import custom lists for the fill handle
3. Enter dates and TRANSPOSE (for planners)
4. Text, Indicators, Formatting, and Objects (instructions for use)
5. Merge texts into columns and formulas (reduce database)
6. Merge texts into 1 column and then separate again into 2 columns
7. Text functions
8. Swap columns by sorting – quickly move data (e.g. VLOOKUP).
9. Lock titles – Keeping an overview in large data while scrolling.
10. Text settings & formatting
11. Cell properties
12. Detect duplicate values
13. Creating and organizing graphs
14. “Organizing and formatting graphs”
15. Function SUM.IF
16. Function SUMIFS
17. Function COUNTIF and COUNTIFS
18. Formulas with absolute references
19. Function IF nested and absolute reference
20. Function As, OR, and AND
21. Function SUBTOTALS
22. Time functions Integer, Remainder, HOUR and MIN
23. IF.DATEANDTIME
24. Function LOOKUP
25. Function HLOOKUP
26. Conditional formatting
27. Secure workbook, lock cells, and hide formulas
28. Validation combinedCarry out using the FILL HANDLE