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