MS Excel
MS Excel Notes (Basic to Advanced) 1. Introduction to MS Excel MS Excel is a spreadsheet software developed by Microsoft. It is used to store, organize, calculate, and analyze data . Excel files are called Workbooks . Each workbook contains one or more Worksheets . 2. Components of MS Excel Workbook – An Excel file Worksheet – A page inside the workbook Row – Horizontal line (1, 2, 3…) Column – Vertical line (A, B, C…) Cell – Intersection of a row and column (e.g., A1) Cell Address – Name of a cell (Column + Row) 3. Starting MS Excel Steps: Click Start Select Microsoft Excel Choose Blank Workbook 4. Types of Data in Excel Text (Label) – Names, cities, subjects Number (Value) – Marks, age, price Formula – Calculations (starts with = ) Example: = A1 + B1 5. Entering and Editing Data Click a cell → Type data → Press Enter To edit data: Double-click the cell or press F2 6. Formatting Cells...