■ Microsoft Excel Notes
■ 1. What is MS Excel?
Microsoft Excel is a spreadsheet program used to record, organize, calculate, and analyze data
using rows, columns, and formulas.
Developer: Microsoft
Part of: Microsoft Office Suite
File Extension: .xlsx (new), .xls (old)
■ 2. Features of MS Excel
• Data Entry & Storage – Organize data in tabular form.
• Formulas & Functions – Perform automatic calculations.
• Charts & Graphs – Visual representation of data.
• Data Filtering & Sorting – Manage and arrange data easily.
• Conditional Formatting – Highlight data based on conditions.
• Pivot Tables – Summarize and analyze large datasets.
• Data Validation – Restrict data input with rules.
• Macros – Automate repetitive tasks.
■ 3. Components of Excel Window
Component Description
Workbook Excel file that contains one or more worksheets.
Worksheet A single spreadsheet page within a workbook.
Cell Intersection of a row and a column (e.g., A1).
Row Horizontal group of cells (numbered 1, 2, 3…).
Column Vertical group of cells (labeled A, B, C…).
Formula Bar Displays the data or formula in the active cell.
Name Box Shows the address of the selected cell.
Ribbon Contains tabs and commands (Home, Insert, Formulas, etc.).
■ 4. Basic Excel Terms
Term Meaning
Cell Address Name of a cell (e.g., A1, B2).
Range Group of selected cells (e.g., A1:A10).
Active Cell Currently selected cell for data entry.
Worksheet Tab Name of each sheet at the bottom.
Gridlines Light lines that separate cells.
■ 5. Types of Data in Excel
• Labels (Text) – Names, words, etc.
• Values (Numbers) – Numeric data used in calculations.
• Formulas – Equations beginning with '='.
• Dates and Times – Special data formats.
■ 6. Common Excel Formulas
Function Purpose Example
SUM() Adds numbers =SUM(A1:A5)
AVERAGE() Finds mean value =AVERAGE(B1:B5)
MAX() / MIN() Largest / Smallest value =MAX(C1:C10)
IF() Conditional logic =IF(A1>50,'Pass','Fail')
COUNT() / COUNTA() Counts cells with numbers / any data =COUNT(A1:A10)
COUNTIF() Counts based on condition =COUNTIF(A1:A10,'>50')
SUMIF() Adds based on condition =SUMIF(A1:A10,'>50',B1:B10)
VLOOKUP() Lookup values vertically =VLOOKUP(A2,B2:D10,3,FALSE)
NOW() / TODAY() Current date/time =NOW()
■ 7. Charts in Excel
Charts are used for data visualization. Common types include: Column, Bar, Line, Pie, Area, and
Combo Charts.
Steps: Select data → Insert → Chart → Choose chart type → Customize
■ 8. Data Sorting & Filtering
Sort: Arrange data in ascending or descending order. (Data → Sort)
Filter: Display only specific rows based on criteria. (Data → Filter)
■ 9. Cell References
Type Example Description
Relative A1 Changes when copied
Absolute $A$1 Does not change when copied
Mixed $A1 or A$1 Partially fixed
■ 10. Keyboard Shortcuts
Shortcut Action
Ctrl + N New Workbook
Ctrl + O Open File
Ctrl + S Save File
Ctrl + C / V / X Copy / Paste / Cut
Ctrl + Z / Y Undo / Redo
Ctrl + A Select All
Ctrl + F Find
Ctrl + Arrow Keys Move to data end
Alt + = AutoSum
F2 Edit cell
■ 11. Advantages of Excel
• Easy to use and widely available
• Powerful data analysis tools
• Customizable formulas and charts
• Integrates with other MS Office apps
• Saves time and effort
■ 12. Uses of MS Excel
• Student marksheets ■
• Financial analysis ■
• Attendance management ■
• Inventory & sales tracking ■
• Reports and dashboards ■