Scribd
Upload
7 views2 pages

MS Excel Notes

Microsoft Excel is a spreadsheet program used for data organization, calculations, and analysis. Key components include workbooks, worksheets, cells, and various formulas for calculations. Excel also features charts, data tools, pivot tables, keyboard shortcuts, and important functionalities like freezing panes and printing options.

Uploaded by

wprathamesh539
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

MS Excel Notes

Microsoft Excel is a spreadsheet program used for data organization, calculations, and analysis. Key components include workbooks, worksheets, cells, and various formulas for calculations. Excel also features charts, data tools, pivot tables, keyboard shortcuts, and important functionalities like freezing panes and printing options.

Uploaded by

wprathamesh539
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Microsoft Excel Notes

1. Introduction to Excel
MS Excel is a spreadsheet program developed by Microsoft. It is used for data organization,
calculations, analysis, and chart creation.

2. Basic Components
Term Description
Workbook The Excel file (.xlsx). Contains multiple sheets.
Worksheet A single spreadsheet in a workbook.
Cell Intersection of a row and a column (e.g., A1,
B3).
Range A group of selected cells (e.g., A1:C3).
Row Horizontal line (numbered).
Column Vertical line (lettered).
Formula Bar Displays or enters formulas.

3. Basic Excel Formulas


Formula Use Example
=SUM(A1:A5) Adds values
=AVERAGE(B1:B5) Returns average
=MAX(C1:C5) Finds maximum value
=MIN(D1:D5) Finds minimum value
=COUNT(A1:A5) Counts numeric values
=COUNTA(A1:A5) Counts non-empty cells
=IF(A1>10,"Yes","No") Logical condition
=NOW() Current date and time
=TODAY() Current date only

4. Excel Functions Categories


Text Functions: LEFT, RIGHT, LEN, CONCAT, UPPER, LOWER

Date Functions: TODAY, NOW, DATEDIF, EDATE, EOMONTH

Logical Functions: IF, AND, OR, NOT

Lookup & Reference: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP

Math Functions: ROUND, INT, MOD, RAND, RANDBETWEEN


5. Charts in Excel
 Types: Column, Bar, Pie, Line, Area, Scatter
 Insert Chart: Select data → Insert tab → Choose chart type

6. Data Tools
 Sort & Filter: Home/Sort tab → Sort A-Z, Filter data
 Data Validation: Restrict input (e.g., dropdown lists)
 Conditional Formatting: Format cells based on conditions

7. Pivot Table
 Used for summarizing large data
 Steps:
 1. Select data
 2. Insert → PivotTable
 3. Drag fields to Rows, Columns, Values

8. Keyboard Shortcuts
Shortcut Action
Ctrl + C Copy
Ctrl + V Paste
Ctrl + Z Undo
Ctrl + Arrow Move to edge of data region
Ctrl + Shift + L Apply/Remove filter
Alt + = AutoSum

9. Important Excel Features


 Freeze Panes: Freeze header rows/columns
 Protect Sheet: Prevent unwanted editing
 Remove Duplicates: Data → Remove Duplicates
 Name Ranges: Assign names to cell ranges

10. Printing in Excel


 Page Layout: Set margins, orientation
 Print Area: Select data → Page Layout → Set Print Area

You might also like