Excel Basics & Advanced Setup Complete Guide

Excel Basics & Advanced

Excel Basics & Advanced Setup: Microsoft Excel Seekhne ka First Step hai. Is Article mein hum Excel ke Interface, Workbook, Worksheet, Rows, Columns, Cell Formatting, Number/Date/Currency Format, Freeze Panes, Page Layout, Printing, Custom Views aur Excel Options ko Simple language mein Samjhenge.

Ye Guide beginners ke liye useful hai aur aage ke Advanced Excel, MIS, Accounting, Data Analysis aur Reporting Topics ko samajhne ke liye Strong Foundation Banata hai.

Excel Interface & Workbook

Excel Interface Kya Hai?

Excel open karne ke baad jo complete screen hume दिखाई देती है, use Excel Interface kehte hain.

Excel Interface mein different sections hote hain:

Title Bar
Quick Access Toolbar
File Tab
Ribbon
Tabs
Groups
Formula Bar
Name Box
Worksheet Area
Row Headings
Column Headings
Status Bar
Scroll Bar

Excel Interface

Workbook Kya Hai?

Excel mein banayi gayi complete file ko Workbook kehte hain.

Example:

Aap ek Company ka monthly sales data Excel mein maintain kar rahe hain. Aapki file ka naam hai:

Sales_Report_2026.xlsx

Ye complete Excel file ek Workbook hai.

Ek workbook ke andar multiple Worksheets ho sakti hain.

Example

Ek workbook mein:

January Sales
February Sales
March Sales
Annual Summary

jaise multiple worksheets ho sakte hain.

Important Point

Workbook = Complete Excel File

Worksheet = Workbook ke andar ek individual sheet

Worksheets, Rows & Columns

Worksheet Kya Hai?

Workbook ke andar jo individual sheet hoti hai, use Worksheet kehte hain.

Usually Excel mein neeche Sheet1, Sheet2, Sheet3 jaise tabs दिखाई देते हैं.

Aap worksheet ka naam change kar sakte hain.

Example:

Sheet1 → Sales Report

Sheet2 → Purchase Report

Sheet3 → Expense Report

Worksheet ke Basic Operations

Aap worksheet par:

Add
Delete
Rename
Move
Copy
Hide
Unhide

kar sakte hain.

What are Rows?

Excel mein horizontal lines ko Rows kehte hain.

Rows ko numbers se identify kiya jata hai:

1, 2, 3, 4, 5…

Example:

Agar customer ka naam Row 2 mein hai, to woh Row 2 mein hai.

Rows

What are columns?

Excel mein vertical lines ko Columns kehte hain.

Columns ko letters se identify kiya jata hai:

A, B, C, D, E…

Example:

A Column = Customer Name

B Column = Sales

C Column = GST

D Column = Total

Columns

What is a cell?

Row aur Column ke intersection ko Cell kehte hain.

Example:

Yahan:

A = Column
1 = Row

Isliye A1 ek Cell Address hai.

Practical Example

A	B	C
Customer	Sales	GST
Arman	10,000	1,800

Yahan:

A2 = Arman
B2 = 10,000
C2 = 1,800

Cell Formatting

Cell Formatting Kya Hai?

Excel mein data ko professional aur easy-to-read banane ke liye Cell Formatting ka use kiya jata hai.

Aap cell ka:

Font
Font Size
Bold
Italic
Underline
Font Color
Background Color
Border
Alignment
Number Format

Change kar sakte hain.

Example

Agar aap Sales Report bana rahe hain:

Sales Report

Customer	Sales	GST	Total
Arman	₹10,000	₹1,800	₹11,800

Heading ko Bold + Center + Border karne se Report professional dikhegi.

Useful Shortcut

Ctrl + B → Bold

Ctrl + I → Italic

Ctrl + U → Underline

Number, Date & Currency Formats

Excel mein different types ke Data ke liye Correct Number Format use karna important hai.

Number Format

Numbers ko properly display karne ke liye Number Format use hota hai.

Example:

10000

ko format karke:

10,000.00

Us Number ko Select karo Fir General se Option Click karke Number pe Click kariye is tarah display kiya ja sakta h hai

Currency Format

Money-Related Data ke liye Currency format use kar sakte hain.

Example:

10000

display ho sakta hai:

$10,000.00

Accounting aur business reports mein Currency/Accounting format kaafi useful hota hai.

Us Number ko Select karo Fir General se Option Click karke Currency pe Click kariye is tarah display kiya ja sakta h hai

Date Format

Excel mein dates ko different formats mein display kiya ja sakta hai.

Example:

29/09/2026

29-Sep-2026

September 29, 2026

Practical Example

Date	Customer	Amount
29-Sep-2026	Arman khan	₹10,000
30-Sep-2026	Amit	₹15,000

Correct Date Format se reports ko read aur filter karna easier hota hai.

Freeze Panes

Freeze Panes Kya Hai?

Jab Excel sheet mein bahut zyada data ho, to scroll karte waqt headings screen se disappear ho jati hain.

Freeze Panes ki help se important rows ya columns ko fixed rakha ja sakta hai.

Example

Suppose aapke paas 1,000 sales records hain.

Top row mein headings hain:

Date	Customer	Product	Qty	Amount

Jab aap neeche scroll karenge, headings normally disappear ho sakti hain.

Agar aap Freeze Top Row use karte hain, to headings screen ke top par visible rahengi.

Freeze Top Row

View → Freeze Panes → Freeze Top Row

Freeze First Column

Agar first column ko fixed rakhna hai:

View → Freeze Panes → Freeze First Column

Multiple Rows/Columns Freeze

Jis cell ke upar ki rows aur left side ke columns freeze karne hain, us cell ko select karke:

View → Freeze Panes → Freeze Panes

use kar sakte hain.

View → Freeze Panes → Freeze Top Row

Page Layout & Printing

Excel ka data screen par sahi dikhna aur print hone par properly fit hona alag cheez hai.

Isliye printing se pehle Page Layout settings check karna important hai.

Important Page Layout Settings

Margins
Orientation
Size
Print Area
Page Breaks
Scale
Gridlines
Headings

Portrait & Landscape

Portrait

Page vertical format mein hota hai.

Small tables ke liye useful hai.

Landscape

Page horizontal format mein hota hai.

Large reports aur multiple columns ke liye useful hai.

Example

Agar aapki report mein:

Date + Customer + Product + Qty + Rate + GST + Total + Profit

jaise bahut saare columns hain, to Landscape Orientation useful ho sakta hai.

Print Area

Agar worksheet mein bahut saara data hai lekin sirf specific area print karna hai, to Print Area set kar sakte hain.

Example:

A1:H30 mein report hai.

Aap:

Page Layout → Print Area → Set Print Area

use karke sirf A1:H30 print kar sakte hain.

Custom Views

Custom Views Kya Hai?

Excel mein alag-alag display aur printing settings ko save karke future mein quickly use karne ke liye Custom Views ka use kiya ja sakta hai.

Example:

Aapke paas ek large report hai.

Aap ek view bana sakte hain:

Management Report

Aur doosra:

Printing Report

Isse frequently used worksheet views ko manage karna convenient ho sakta hai.

Important Note

Custom Views ki availability/behavior Excel version aur workbook setup par depend kar sakta hai, especially agar workbook mein Excel Tables use ki gayi hain.

Excel Options & Important Settings

Excel Options Kya Hai?

Excel ke behavior aur working environment ko customize karne ke liye Excel Options ka use kiya jata hai.

Open karne ka path:

File → Options

Yahan Excel ki multiple settings available hoti hain.

Important Excel Options

1. General

Yahan Excel ka general appearance aur basic settings manage kar sakte hain.

2. Formulas

Formula calculation aur error-related settings ke liye useful hai.

3. Proofing

Spelling aur AutoCorrect settings manage kar sakte hain.

4. Save

Workbook ko save karne se related settings manage kar sakte hain.

5. Language

Excel ki language aur editing language settings manage ki ja sakti hain.

6. Advanced

Advanced editing, display aur calculation-related settings available hoti hain.

7. Customize Ribbon

Ribbon mein required commands ko add/remove ya organize karne ke liye useful hai.

8. Quick Access Toolbar

Frequently used commands ko easily access karne ke liye toolbar customize kar sakte hain.

Practical Example: Accountant ke liye Excel Setup

Suppose aap ek accountant hain aur monthly Sales Report maintain karte hain.

Aapki worksheet kuch is tarah ho sakti hai:

Date	Invoice No.	Customer	Sales	GST	Total
01-Sep-26	INV-001	Arman khan	10,000	₹1,800	₹11,800
02-Sep-26	INV-002	XYZ Ltd	₹20,000	₹3,600	₹23,600

Is report mein aap:

Date ko Date Format mein rakhenge
Sales/GST/Total ko Currency ya Accounting Format mein rakhenge
Header ko Bold karenge
Borders add karenge
Top Row Freeze karenge
Landscape Printing use kar sakte hain
Required data ka Print Area set karenge

(alt="Practical Example: Accountant ke liye Excel Setup").

Is tarah simple Excel sheet ko professional business report mein convert kiya ja sakta hai.

Important Excel Shortcuts

Shortcut	Use
Ctrl + N	New Workbook
Ctrl + O	Open Workbook
Ctrl + S	Save
Ctrl + P	Print
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + F	Find
Ctrl + H	Replace
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Ctrl + 1	Format Cells
Ctrl + Home	Go to beginning
Ctrl + End	Go to last used cell

Guide Summary

Is chapter mein humne Excel ke basic se advanced setup tak important concepts samjhe:

Excel Interface & Workbook
Worksheets, Rows & Columns
Cell Formatting
Number, Date & Currency Formats
Freeze Panes
Page Layout & Printing
Custom Views
Excel Options & Important Settings

Our Courses

Excel Basics & Advanced

Excel Interface & Workbook

Excel Interface Kya Hai?

Workbook Kya Hai?

Example

Important Point

Worksheets, Rows & Columns

Worksheet Kya Hai?

Worksheet ke Basic Operations

What are Rows?

Rows

What are columns?

Columns

What is a cell?

Practical Example

Cell Formatting

Cell Formatting Kya Hai?

Example

Useful Shortcut

Number, Date & Currency Formats

Number Format

Currency Format

Date Format

Practical Example

Freeze Panes

Freeze Panes Kya Hai?

Example

Freeze Top Row

Freeze First Column

Multiple Rows/Columns Freeze

Page Layout & Printing

Important Page Layout Settings

Portrait & Landscape

Portrait

Landscape

Example

Print Area

Custom Views

Custom Views Kya Hai?

Important Note

Excel Options & Important Settings

Excel Options Kya Hai?

Important Excel Options

1. General

2. Formulas

3. Proofing

4. Save

5. Language

6. Advanced

7. Customize Ribbon

8. Quick Access Toolbar

Practical Example: Accountant ke liye Excel Setup

Important Excel Shortcuts

Guide Summary

1 Comment

Leave a Reply Cancel reply