Excel Guide 📊

Data Analysis & Reporting Tool

1. What is Excel?

Excel is a spreadsheet tool used to store, analyze, and visualize data.

2. Basics

Cells → A1, B2
Rows → Horizontal
Columns → Vertical

3. Basic Formulas

=SUM(A1:A5)
=AVERAGE(A1:A5)
=MAX(A1:A5)
=MIN(A1:A5)

4. IF Condition

=IF(A1>50, "Pass", "Fail")

5. VLOOKUP

=VLOOKUP(A1, B1:C10, 2, FALSE)

6. Pivot Table

Used to summarize large data quickly

7. Filtering & Sorting

Sort → Ascending/Descending
Filter → Show specific data

8. Charts

Bar Chart
Line Chart
Pie Chart

9. Shortcuts

Ctrl + C → Copy
Ctrl + V → Paste
Ctrl + Z → Undo
Ctrl + Arrow → Navigate

10. Real Use Cases