Itech Education

Showing posts with the label ms excel tutorialsShow all

Divide Function in excel

To do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a…

Multiplication in excel

Multiply a column of numbers by a constant number Type =A2*$B$2 and press enter.

Subtract Function in Excel | Subtract numbers in excel

There is no specific function for SUBTRACT value in Excel. Use the SUM function and convert any num…

Mixed Cell References in Excel?

Mixed cell references are more-tricky than the absolute cell references if we compare. There can be…

Absolute Cell References in Excel?

Absolute cell references are useful when you don’t want the cell reference to change as you copy or…

password protection in excel

कभी-कभी हमारे worksheet के data में important information होती है, जिसको हम नहीं चाहते की कोई अन्य…

Data Security in excel

कभी-कभी हमारे worksheet के data में important information होती है, जिसको हम नहीं चाहते की कोई अन्य…

macros in excel

What is a Macro in Excel Hindi? MS Excel Macro Meaning in Hindi: MS Excel में Macros का मतलब छोटे छ…

page setup for printing in excel

Excel में Page Setup कैसे करे ? जब हम कोई भी Data MS Excel से Print निकालते है तो उससे पहले हमें Pa…

conditional formatting in excel

1. Highlight Value Greater Than = 100 2. Total bill values between 9000 to 15000

Logical Function Excel | Advance Excel Formula

Logical Function is a Function category in Excel, we use it to search the value according to a give…

Len function In Excel | Advance Excel Formula

Len function in excel This is also another function of text category and Len function is used to me…

Compound Interest Formula in Excel | Download Excel Sheet For Practice

When you invest your money such, you can earn interest on your investment amount. for exa…

How to convert number to text in MS excel ? Number To Text

in this post you will learn how to convert number into text using MS excel. Step 1 : Open MS …

Data Validation in Excel | Drop Down List In Excel

Data Validation in Excel - Learn how to use Data Validation tools in Excel Hindi to improve the acc…

How to remove duplicate value in excel ? remove duplicates

Step 1 Select sheet data where you want to remove duplicate value from your data. Step 2 Press o…

Learn Advance Excel Course With 50+ Functions || Advance Excel Syllabus

Learn Microsoft Excel from beginning to Advanced. Learn Advance Excel Course with 50+…