1. MS Excel 2023 Introduction
2. FEATURES OF MS EXCEL
3. Linking Workbooks
4. Working with Shortcuts
5. Working with Sorting and Filtering
6. Working with range names
7. Sub Totals
8. Create a table
9. Formatting a table
10. Working with Sort and filter by names and color
11. Filter with slicers
12. Working with Calculate with table
13. Removing errors
14. Working with Export and refresh converting tables
15. Conditional formatting
16. Highlighting cells top and bottom
17. Database, icons sets, color scaler
18. Using custom fonts and colors
19. Using Conditional formatting
20. Modifying or removing conditional formatting
21. Working with Creating charts
22. Understand the chart elements
23. Modifying chart elements
24. Changing and moving charts
25. Formatting charts
26. Adjusting numbering
27. Creating dual axis chart with example
28. Forecasting with trend lines
29. Creating chart templates
30. Displaying trends with sparkling tools
31. Wrap Text
32. What is pivot table
33. Pivot table field panes
34. Data organisation and analysis with pivot table
35. Formatting pivot chart
36. Creating pivot charts
37. Slicers
38. Formatting slicers
39. Pivot Chart wizard
40. Adding a calculated field
41. Creating filter pages for a pivot
42. Working with Power pivot
