Complete MS Excel Training from ZERO to HERO with CHAT GPT

Welcome to most updated MS Excel learning sessions. Which includes all controls along with real-time scenarios. Discussed all formulas along with examples.

This training sessions covers below the details –

1. Fundamentals on MS Excel
2. Field by Field discussion on all control which we have under TABS
3. Clipboard, Font management, Alignment, Number setup,
4. Conditional formatting
5. Format as table
6. Cell style
7. Insert, delete & format the cell, rows & columns
8. SUM, Fill, clear the data in MS Excel
9. Add in and how to convert excel to PDF
10. Pivot Tables
11. Advanced Pivot Tables
12. Recommended PIVOT tables & tables
13. How to insert PICTURES, SHAPES, ICON & 3D MODELS
14. How to insert MAP in excel
15. Text Function
16. Sparklines
17. How to add hyperlinks in MS Excel
18. Filter the data
19. Advanced filter
20. Timeline
21. Insert comments, delete comments & Edit comments
22. Insert notes, delete notes & Edit notes
23. Text functionalities
24. How to insert symbols
25. Drawing tools
26. Ink to Shape
27. Ink to Math
28. Ink replay
29. Theme effects
30. Page setup for printout
31. How to increase height, weight & scale setup
32. Sheet option
33. Text alignment
34. Arrangement in MS Excel
35. Formulas
36. How to transform the data in MS Excel from text/CSV. INTERNET, XML, JSON & PDF
37. Proofing
38. Check accessibility
39. How to translate the data in different languages
40. Insert comments, display comments
41. Insert notes, display notes
42. How to protect the excel sheet with password
43. Hide link
44. Sheet view
45. How to break up the preview
46. Page layout setting for printout
47. Customer view for printout
48. How to hide & display gridlines, formula bar & Headings
49. ZOOM
50. How to freeze panes
51. How to switch the windows
52. MACRO recording
53. Use relative reference
54. Data entry from basic to advance level
55. VLOOKUP
56. HLOOKUP
57. XLOOKUP
58. CHAT GPT
59. Dashboard