Microsoft Excel Basics – Complete Beginner to Advanced Guide

Learn Excel formulas, functions, charts, tables, pivot tables, sorting, filtering, shortcut keys and real-life uses.

---

What is Microsoft Excel?

Microsoft Excel is a powerful spreadsheet software developed by Microsoft. It is used for calculations, data management, reporting, accounting, analysis and chart creation. Excel helps users organize data in rows and columns and perform calculations automatically using formulas and functions.

Excel is widely used in offices, schools, colleges, businesses, banks, accounting firms and data analysis work.

Why Learn Microsoft Excel?

Learning Excel is very important because it is one of the most useful computer skills for students, office workers, business owners and professionals.

• Fast calculations
• Easy data management
• Professional report creation
• Charts and graph creation
• Sorting and filtering data
• Useful for office jobs
• Important for CCC and computer courses

1. Rows, Columns and Cells

Excel worksheets are divided into rows and columns. Rows are horizontal and numbered as 1, 2, 3 and so on. Columns are vertical and named as A, B, C and so on.

The box created by the intersection of a row and column is called a cell.

2. Workbook and Worksheet

A workbook is an Excel file. A worksheet is a single sheet inside a workbook. One workbook can contain multiple worksheets.

• Workbook: Complete Excel file
• Worksheet: Individual sheet inside workbook
• Cell: Box where data is entered

3. Creating a Spreadsheet

A spreadsheet is used to store, organize and calculate data. It is useful for making marksheets, attendance sheets, salary sheets, expense records, sales reports and business data.

Steps to Create a Spreadsheet

1. Open Microsoft Excel
2. Click on Blank Workbook
3. Enter data in rows and columns
4. Apply formulas if required
5. Save the file using Ctrl + S

4. Data Types in Excel

Data Type	Example
Text	Student Name
Number	500
Date	11-05-2026
Currency	₹1500
Percentage	85%

5. Basic Excel Formulas

Formulas in Excel are used to perform automatic calculations. Every formula starts with an equal sign.

Formula	Use
=SUM(A1:A5)	Adds numbers
=AVERAGE(A1:A5)	Finds average
=MAX(A1:A5)	Finds highest value
=MIN(A1:A5)	Finds lowest value
=COUNT(A1:A5)	Counts numbers

6. Mathematical Operations in Excel

Operation	Formula Example
Addition	=A1+B1
Subtraction	=A1-B1
Multiplication	=A1*B1
Division	=A1/B1

7. AutoFill Feature

AutoFill is used to automatically fill data patterns in Excel. It saves time and reduces manual typing.

8. Formatting in Excel

Formatting is used to make spreadsheets attractive, clear and professional.

• Font size
• Font color
• Bold, italic and underline
• Cell borders
• Background color
• Text alignment
• Number formatting

9. Conditional Formatting

Conditional formatting changes the appearance of cells based on conditions.

For example, you can highlight students who scored more than 80 marks or show low sales values in red color.

10. Charts and Graphs in Excel

Charts and graphs are used to represent data visually. They make reports easier to understand.

Types of Charts

• Bar Chart
• Column Chart
• Pie Chart
• Line Chart
• Area Chart

Steps to Create a Chart

1. Select the data
2. Click on Insert
3. Choose chart type
4. Excel will create the chart automatically

11. Sorting Data

Sorting is used to arrange data in a specific order.

• A to Z
• Z to A
• Smallest to Largest
• Largest to Smallest

12. Filtering Data

Filtering is used to display only selected data from a large dataset.

13. Freeze Panes

Freeze Panes keeps selected rows or columns visible while scrolling. It is useful when working with large spreadsheets.

14. Data Validation

Data validation controls what type of data users can enter in a cell.

For example, you can allow only numbers between 1 and 100 in a marks column.

15. Pivot Tables

Pivot Tables are used to summarize and analyze large datasets quickly.

Uses of Pivot Tables

• Sales summary
• Monthly reports
• Category-wise data analysis
• Business reporting

16. Excel Tables

Excel Tables help organize data professionally. Tables provide automatic filtering, better formatting and easy data handling.

17. Lookup Functions

Lookup functions are used to search data from a table.

Function	Purpose
VLOOKUP	Searches vertically
HLOOKUP	Searches horizontally
XLOOKUP	Advanced lookup function

18. IF Function

The IF function checks a condition and returns different results based on true or false.

19. Protecting Excel Sheets

Excel allows users to protect sheets using passwords. This prevents unwanted editing and keeps data safe.

• Protect worksheet
• Lock cells
• Add password
• Restrict editing

20. Printing in Excel

Excel provides many printing options to make professional printouts.

• Page orientation
• Margins
• Print area
• Header and footer
• Page scaling

Important Microsoft Excel Shortcut Keys

Basic Shortcut Keys

Shortcut Key	Function
Ctrl + N	New Workbook
Ctrl + O	Open Workbook
Ctrl + S	Save Workbook
Ctrl + P	Print
Ctrl + C	Copy
Ctrl + V	Paste
Ctrl + X	Cut
Ctrl + Z	Undo

Formula Shortcut Keys

Shortcut Key	Function
Alt + =	AutoSum
F2	Edit Cell
Shift + F3	Insert Function
Ctrl + `	Show Formulas

Navigation Shortcut Keys

Shortcut Key	Function
Ctrl + Home	Go to A1 Cell
Ctrl + End	Go to Last Used Cell
Ctrl + Arrow Key	Move Quickly in Data
Page Up	Move One Screen Up
Page Down	Move One Screen Down

Row and Column Shortcut Keys

Shortcut Key	Function
Ctrl + Space	Select Entire Column
Shift + Space	Select Entire Row
Ctrl + Shift + +	Insert Row or Column
Ctrl + -	Delete Row or Column

Real-Life Uses of Excel

• Creating student marksheets
• Maintaining attendance records
• Preparing salary sheets
• Managing business inventory
• Creating sales reports
• Tracking monthly expenses
• Preparing charts and presentations
• Analyzing business performance

Advantages of Microsoft Excel

• Easy to use
• Saves time
• Performs fast calculations
• Helps in data analysis
• Creates professional reports
• Useful in almost every job field

Tips for Excel Beginners

• Practice formulas daily
• Learn shortcut keys
• Use charts for better presentation
• Keep data clean and organized
• Use filters for large data
• Learn Pivot Tables step by step
• Save your work regularly

Conclusion

Microsoft Excel is one of the most important tools for calculations, data management, analysis and reporting. It is useful for students, office workers, business owners and professionals. By learning rows, columns, formulas, functions, charts, sorting, filtering, pivot tables and shortcut keys, you can work more efficiently and professionally.