Conditional Formatting

Conditional Formating In Excel

Conditional formating ek tarika hota hai jisme hum apane cell ko color karte hai kuch condition ki madad se. Isme hum apane cell ko format karte hai us cell value ke according

There is a different type of conditional formatting available
koi bhi style use karne ke liye sabse pahle hum apane cells ko select karte hai jisme format use karna
hai

1:--> Highlight cell rule

Iska matlab hota hai hum apane cell ko highlight karte hai lekin kuch condition ki madad se
isme pahla condition hai greater then

isme hum sabse pahle apane numbers ko select karte hai

fir home menu me jakar condition formatting choose karte hai

isme hum highlight cell ke ander greater then option per click karte hai aur hame ek dialog box milta hai usme hum koi bhi value enter karte hai aur ok per click karte hai.

iss number se bada jo bhi number hoga us selected area me usme color ho jayega.

Download

Download software list

• Typing Master
• Tally Erp 9
• Microsoft office 2007
• Microsoft office 2010
• Winrar

Download WINRAR Setup

How to Extract a ZIP or RAR File

WinRar ek software hai jo free of cost milta h isko download karne ke liye niche ke download link per click karo. iski madad se hum apani file ko kam size me convert kr sakte hai

yadi hamare pass koi file hai jo bahut jayada size ka hai to hum usko kam size me convert kr sakte hai bas uske liye hame winrar name ka software download karna hoga yahi nahi agar hamare pass koi zip ki file hai to hum usko wapas se normal me convert kr sakte h

To chaliye ab hum dekhate hai ki winrar software ko kaise downkload kr sakte h aur install kr sakte hai

Download

WinRar software ko download karne ke liye page sabse niche jakr download icon pr click kare.
jab apaka download complete ho jae to use install kr le

Install

1. install karne ke liye winrar software ki setup file per double click kare
   
2. fir ek massage aayega usme yes per click kare.
3. Ab apane winrar software ko installation path ko choose kare
   
   
   
4. fir install option per click kare
   
5. ab winrar format me apane document format ko choose kr ke ok per click kare
   
6. kuch samay ke bad agar done ka window aata hai to iska matlab apaka software install ho gya hai
   

So Now Enjoy :)

Extract a ZIP or Rar File

How to Extract a ZIP or RAR File

WinRar ek software hai jo free of cost milta h isko download karne ke liye niche ke download link per click karo. iski madad se hum apani file ko kam size me convert kr sakte hai

yadi hamare pass koi file hai jo bahut jayada size ka hai to hum usko kam size me convert kr sakte hai bas uske liye hame winrar name ka software download karna hoga yahi nahi agar hamare pass koi zip ki file hai to hum usko wapas se normal me convert kr sakte h

To chaliye ab hum dekhate hai ki winrar software ko kaise downkload kr sakte h aur install kr sakte hai

Download

WinRar software ko download karne ke liye page sabse niche jakr download icon pr click kare.
jab apaka download complete ho jae to use install kr le

Install

1. install karne ke liye winrar software ki setup file per double click kare
   
   
2. fir ek massage aayega usme yes per click kare.
3. Ab apane winrar software ko installation path ko choose kare
   
   
   
4. fir install option per click kare
   
   
5. ab winrar format me apane document format ko choose kr ke ok per click kare
   
   
6. kuch samay ke bad agar done ka window aata hai to iska matlab apaka software install ho gya hai
   
   

So Now Enjoy :)

Install Microsoft Office 2010

how to Install Microsoft Office 2010

1. Microsoft office ko install karne ke liye sabse pahle apako microsoft office ka setup install karna hoga uske liye app hamare website microsoft office ka setup download kr sakte hai
2. microsoft office download karne ke liye sabse niche download option per click kare aur fir opened window ke under download ka button click kare.
3. jab apake download complete ho jayega to fir us downloaded location per jakr downloaded file ko extract kr le kyoki downloaded file zip format me hota hai
Zip file ko extract kaise karte ha uske liye yaha click kare

4. jab apaka file extract ho jayega to usko open kr le aur install karne ke liye niche ka step follow kare.
5. Step 1: setup name ki file per double click kare
   
   
6. Step 2: fir ek massage aayega usme yes per click kare.
   
   
   
   
7. Step 3: Ab term and condition ke pass box me mouse ka left click kr ke accept karo aur continue per click karo
   
   
8. Step 4: Ab Install now per click karo
   
   
   
   isse aapka microsoft office installation start ho jayega
   
   
   
   per isme kuch samay lagega to uske liye wait karo jab installation complete ho jaye to
9. Step 6: Ab open window me close button per click karo.
   
   

Now your microsoft office is installed in your computer

So enjoy :)

Thank You

Install Microsoft Office 2007

how to install microsoft office 2007

1. Microsoft office ko install karne ke liye sabse pahle apako microsoft office ka setup install karna hoga uske liye app hamare website microsoft office ka setup download kr sakte hai
2. microsoft office download karne ke liye sabse niche download option per click kare aur fir opened window ke under download ka button click kare.
3. jab apake download complete ho jayega to fir us downloaded location per jakr downloaded file ko extract kr le kyoki downloaded file zip format me hota hai
Zip file ko extract kaise karte ha uske liye yaha click kare

4. jab apaka file extract ho jayega to usko open kr le aur install karne ke liye niche ka step follow kare.
5. Step 1: setup name ki file per double click kare
   
   
   
   
6. Step 2: fir ek massage aayega usme yes per click kare.
   
   
   
   
7. Step 3: Ab sr no copy karo aur open window me paste kar do aur continue per click karo
   
   
   
   
Sr no serial no mocrosoft office folder ke ander serial no file me hai.

8. Step 4: Ab term and condition ke pass box me mouse ka left click kr ke accept karo aur continue per click karo
   
   
9. Step 5: Ab Install now per click karo
   
   
   
   isse aapka microsoft office installation start ho jayega
   
   
   
   per isme kuch samay lagega to uske liye wait karo jab installation complete ho jaye to
10. Step 6: Ab open window me close button per click karo.
    
    

Now your microsoft office is installed in your computer

So enjoy :)

Thank You

Format Number in Excel

hamare pass jo excel ki sheet hoti hai usme hume bahut si cells mili hoti h jisme hum bahut kuch likh sakte h

lekin kai bar aisa hota h ki hame apane number ke sath kuch format lagana hota hai jaise hame apane number ke sath apane rupees or currency ka symbol likhana hota h

uske liye hum number formate ka use karte hai

To chalo start karte hai

sabse pahle hum apane cell ko select karte h jaha hame currency symbol use karna hai uske bad hum home menu me number formate me jate h

usme jab hum dekhete h to hame ek jagah per general likha hota h waha per right side me ek chota sa down arrow ka nishan hota h usper click karte h aur apane according formate choose kr lete hai

Isme hame 2 option milta h currency symbol lagane ke liye

1. Currency aur
2. Accounting

Isme se hum jo chahe wo choose kr sakte hai Per isme kuch different hota hai

• Currency me hume currency ka symbol pass milta h jabki accounting me hume symbol dur milta hai
• Currency me jab hum zero likhte h to hame zero ke sath currency ka symbol aata h jabki accounting jab hum zero likhate h to hume - ke sath currency ka symbol aata h.

Lekin kai bar hame apani currnecy ki jagah kisi aur desh ka ya koi aur symbol show karta h to hame usko change karna hota hai

Uske liye hum accounting number format per jate hai jo general word ke thik niche left side me hota hai usme agar hamara currency symbol mil jata h to change kr dete hai nhi to sabse last option choose karte hai jo more accounting ka hota hai

Isme hum apane right side me symbol likha hua dekhate h jisme hamara current symbol show hota hai usme hum jakr ke ek ek symbol ko check kr ke apana symbol choose karte h aur fir niche ok per click karte hai.
Isse hamara currency symbol mil jata hai.

To aaiye ab hum isi cheez ko ab video me dekhate hai.

Format a worksheet

You can help improve the readability of a worksheet by applying different types of formatting. For example, you can apply borders and shading to help define the cells in a worksheet.

How?

Apply cell borders

1. Select the cell or range of cells that you want to add a border to.
Tip To quickly select the whole worksheet, click the Select All button.

2. On the Home tab, in the Font group, click the arrow next to Borders , and then click the border style that you want
Tip The Borders button displays the most recently used border style. You can click the Borders button (not the arrow) to apply that style.

Change text color and alignment

1. Select the cell or range of cells that contain (or will contain) the text that you want to format. You can also select one or more portions of the text within a cell and apply different text colors to those sections.
2. To change the color of text in the selected cells, on the Home tab, in the Font group, click the arrow next to Font Color, and then under Theme Colors or Standard Colors, click the color that you want to use.
Note To apply a color other than the available theme colors and standard colors, click More Colors, and then define the color that you want to use on the Standard tab or Custom tab of the Colors dialog box.
3. To change the alignment of the text in the selected cells, on the Home tab, in the Alignment group, click the alignment option that you want.

Apply cell shading

1. Select the cell or range of cells that you want to apply cell shading to.
2. On the Home tab, in the Font group, click the arrow next to Fill Color , and then under Theme Colors or Standard Colors, click the color that you want

Adjusting and Formatting data

Adjusting and Formating data in a worksheet

Adjust settings

1. To wrap text in a cell, select the cells that you want to format, and then on the Home tab, in the Alignment group, click Wrap Text.

2. To adjust column width and row height to automatically fit the contents of a cell, select the columns or rows that you want to change, and then on the Home tab, in the Cells group, click Format.

3. Under Cell Size, click Auto-fit Column Width or Auto-fit Row Height.
Tip To quickly auto-fit all columns or rows in the worksheet, click the Select All button, and then double-click any boundary between two column or row headings

Format the data

1. To apply number formatting, click the cell that contains the numbers that you want to format, and then on the Home tab, in the Number group, click the arrow next to General, and then click the format that you want.

2. To change the font, select the cells that contain the data that you want to format, and then on the Home tab, in the Font group, click the format that you want.

Enter data

Enter data in a worksheet

To work with data on a worksheet, you first have to enter that data in the cells on the worksheet. Then, you might want to adjust the data so that it is visible, and display it just the way that you want.

Enter the data

• Click a cell, and then type data in that cell.
• Press ENTER or TAB to move to the next cell.
Tip To enter data on a new line in a cell, enter a line break by pressing ALT+ENTER.

• To enter a series of data, such as days, months, or progressive numbers, type the starting value in a cell, and then in the next cell type a value to establish a pattern.
For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells.
Select the cells that contain the starting values, and then drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) across the range that you want to fill.
Tip To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.

Create a New File

When you create a new workbook, you can use a blank workbook template, or you can base your workbook on an existing template that already provides some data, layout, and formatting that you want to use.

How?

Click the File tab.

This will open the Microsoft Office Backstage view, which temporarily hides the worksheet.

Click New.

Under Available Templates, click the workbook template that you want to use.

Tips

• For a new, blank workbook, double-click Blank Workbook.
• For a workbook that is based on an existing workbook, click New from existing, browse to the location of the workbook you want to use, and then click Create New.
• For a workbook that is based on a template, click Sample templates or My templates, and then select the template that you want.

Create a workbook

Create a New File

When you create a new workbook, you can use a blank workbook template, or you can base your workbook on an existing template that already provides some data, layout, and formatting that you want to use.

How?

Click the File tab.

This will open the Microsoft Office Backstage view, which temporarily hides the worksheet.

Click New.

Under Available Templates, click the workbook template that you want to use.

Tips

• For a new, blank workbook, double-click Blank Workbook.
• For a workbook that is based on an existing workbook, click New from existing, browse to the location of the workbook you want to use, and then click Create New.
• For a workbook that is based on a template, click Sample templates or My templates, and then select the template that you want.