Scribd
Upload
8 views2 pages

Excel Basics Notes

Microsoft Excel is a spreadsheet program for storing, organizing, and analyzing data, with workbooks containing worksheets. Key features include rows, columns, cells, and various data types, along with shortcuts for efficient use. Essential functions and formulas, sorting, filtering, and chart creation are also covered, along with basic formatting and printing options.

Uploaded by

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

Excel Basics Notes

Microsoft Excel is a spreadsheet program for storing, organizing, and analyzing data, with workbooks containing worksheets. Key features include rows, columns, cells, and various data types, along with shortcuts for efficient use. Essential functions and formulas, sorting, filtering, and chart creation are also covered, along with basic formatting and printing options.

Uploaded by

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

Excel Basics Notes (Quick & Easy)

1) What is Excel?
- Microsoft Excel is a spreadsheet program used to store, organize, calculate, and analyze data.
- A file is called a Workbook
- Each workbook contains Worksheets (Sheets)

2) Main Parts of Excel


- Row → Horizontal line (1, 2, 3…)
- Column → Vertical line (A, B, C…)
- Cell → Box where row + column meet (Example: A1)
- Formula Bar → Shows what is written in the selected cell
- Name Box → Shows cell address (like B5)

3) Types of Data in Excel


- Text → Name, City, Item
- Number → 10, 250, 99
- Date/Time → 01-01-2026, 10:30 AM
- Formula → Starts with =

4) Basic Excel Shortcuts


- Ctrl + C → Copy
- Ctrl + V → Paste
- Ctrl + X → Cut
- Ctrl + Z → Undo
- Ctrl + Y → Redo
- Ctrl + S → Save
- Ctrl + A → Select all
- Ctrl + F → Find
- Ctrl + H → Replace
- Ctrl + P → Print

5) Basic Formatting Options


- Bold → Ctrl + B
- Italic → Ctrl + I
- Underline → Ctrl + U
- Change Font, Size, Color
- Wrap Text → fits text in cell
- Merge & Center → combines multiple cells into one
- Alignment → Left / Center / Right

6) Basic Formulas (Most Important)


- Always start formulas with =
- Addition → =A1+B1
- Subtraction → =A1-B1
- Multiplication → =A1*B1
- Division → =A1/B1

7) Common Functions (Very Useful)


- SUM → =SUM(A1:A5) (adds values)
- AVERAGE → =AVERAGE(A1:A5)
- MAX → =MAX(A1:A5) (highest value)
- MIN → =MIN(A1:A5) (lowest value)
- COUNT → =COUNT(A1:A5) (counts numbers)
- COUNTA → =COUNTA(A1:A5) (counts filled cells)

8) Fill Handle (Drag Feature)


- Use the small square at the corner of a selected cell
- Helps to auto-fill numbers, dates, formulas
Example:
- Type 1 and 2 → select both → drag down → it fills 3,4,5…

9) Sorting & Filtering


- Sort A to Z → ascending order
- Sort Z to A → descending order
- Filter → shows only selected values (like only Bangalore)

10) Tables in Excel


- Select data → Press Ctrl + T
Benefits:
- Easy filtering
- Auto formatting
- Structured data

11) Charts (Basic)


- Column Chart, Bar Chart, Pie Chart, Line Chart
Steps:
1. Select data
2. Insert → Choose chart type

12) Page Setup (Printing)


- Page Layout tab
- Set: Margins, Orientation (Portrait / Landscape), Print Area

13) Saving Excel File


- Ctrl + S
- .xlsx (normal Excel file)
- .xls (older version)
- .csv (comma separated values)

You might also like