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