MS Excel
1. Introduction
2. Insert Page Breaks
3. Set Background
4. Freeze Panes
5. Applying conditional formatting rules
6. Building basic formulas for addition
7. Building basic formulas for subtraction
8. Building basic formulas for multiplication
9. Building basic formulas for division
10. Merge & Wrap
11. Borders and Shades
12. Apply Formatting
13. Sheet Options
14. Adjust Margins
15. Page Orientation
16. Header and Footer
17. Adding Text Box
18. Undo Changes
19. Setting Cell Type
20. Setting Fonts
21. Text Decoration
22. Rotate Cells
23. Setting Colors
24. Text Alignments
25. Brief History and Purpose of Microsoft Excel
26. Importance of Excel in Data Management and Analysis
27. Installing Microsoft Excel
28. Launching Excel and Understanding the Interface
29. Overview of the Ribbon
30. Overview of the Quick Access Toolbar and Cells
31. Understanding Workbooks and Worksheets
32. Save Workbook
33. Close Workbook
34. Open Workbook
35. Create Worksheet
36. Copy Worksheet
37. Hiding Worksheet
38. Delete Worksheet
39. Renaming Worksheets
40. Context Help
41. Insert Data
42. Select Data
43. Delete Data
44. Move Data
45. Rows & Columns
46. Copy & Paste
47. Find & Replace
48. Spell Check
49. Zoom In Zoom Out
50. Special Symbols
51. Insert Comment
52. Formatting text, numbers, and dates
53. Cell merging and formatting options
54. Cell References in Excel
55. Functions Basic Excel
56. Mathematical Functions Excel
57. Excel BETA.DIST() function
58. Excel BETA.INV() function
59. Excel BINOM.DIST() function
60. Excel CHISQ.DIST() function
61. Excel CHISQ.DIST.RT() function
62. Excel CHISQ.INV() function
63. Excel CHISQ.INV.RT() function
64. Excel CHISQ.TEST() function
65. CONFIDENCE.NORM() function
66. Why study excel?
67. Excel formatting.
68. excel colors
69. Using Parentheses
70. Gridlines in Excel
71. Excel Format Painter
72. Excel format settings
73. Excel functions
74. Excel Functions
75. Excel Sort
76. Excel Tables
77. Undo and Redo
78. Fill in Excel
79. Excel Formulas
80. Conditional Formatting
81. Icon Sets in Excel
82. Charts in Excel
83. Pivot Tables
84. AND function in Excel
85. AND function in Excel
86. AVERAGE function in Microsoft Excel
87. Microsoft Excel, Manage Rules
88. Microsoft Excel, Data Bars
89. Microsoft Excel, Highlight Cell Rules
90. Getting Started With Excel Interface
91. Customizing Ribbon and Quick Access Toolbar
92. Cell Formatting Techniques
93. Themes and Templates
94. Naming Cells and Ranges
95. Using Excel’s AutoComplete and AutoFill
96. Data Entry Shortcuts and Efficiency Tricks
97. Advanced Copy Paste Special Options
98. Working With Multiple Worksheets Efficiently
99. Advanced Worksheet Navigation Techniques
100. Using Find and Replace With Options
101. Custom Number Formatting
102. Conditional Formatting Using Formulas
103. Data Validation for Drop Downs and Rules
104. Protecting Cells and Worksheets
105. Workbook Protection and Encryption
106. Versioning and Backup in Excel
107. Excel File Formats Explained
108. External Data Connections
109. Power Query Basics