Microsoft Excel: is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions
As you know we can use Microsoft Excel for accounting and many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For example, there are several ways to enter formulas and calculating the numbers in Excel.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. So let me show you that how you can use Excel formulas according to Microsoft Excel
Top useful Formulas in Microsoft Excel 2016
Ok first of all you should open your Excel program when you opened the Excel program it open tree sheet automatically in one window and then you can delete or add a new sheet, if you want to change the sheet name you can rename as will. Ok now you should use your formula according to role and regulation of Microsoft Excel, so when you open your program then you have many kinds of formula in Microsoft Excel program. Ok let’s go to star how you can use the formulas?
=4+4=?, =6-2=?, =12/2=?, =3*3=?
=SUM, =SUMIF, =COUNT, =COUNTA, =COUNTIF, = COUNTBLANK, =MAX, =MIN, =LOWER, =UPPER, =RIGHT, =LEFT, =POWER, =EVEN, =ODD, =SUMSQ, =AVERAGE, =CTRL+; , =CTRL+SHIFT+; , =ROMAN, =DELTA, =LEN, ALT+ = .
Sum: it will count the numbers and shows the result for you
Sumif: whit the help of sumif you can find the equal numbers, for example small 3 two or large then 3 numbers.
Count and Counta: they are the same working they are just and just count the numbers how many numbers do you have.
Countif: it will count the numbers as will but it is deferent. Foe example count small than 2 numbers, count large then 2 numbers or count the equal numbers.
Countblank: it will show the blanks cells how many blank cells do you have.
Max: it will find the maximum number (largest number) from the cells that you selected.
Min: it will find the minimum number (smallest number) from the cells that you selected.
Right: it will show the text from right side. For example, it shows 3 text from right side.
Left: it will show the text from left side. For Example, it shows 3 text from left side.
Lower: it will change your text from capital to small later, for example (TECHABL) change to tachbal.
Upper: it will change your text from small to capital later, for example (techbal) change to TECHBAL.
Power: it will find the power of your number like: 32=9
Even: it will change your number to joft number, if write 7 it will change to 8 number.
Odd: it will change your number to taq number, if write 6 it will change to 7 number.*
Sumsq: it will change your number to morba spatially in magmatic books are used.
Average: it will find average of two numbers for example average 30,60=45.
Ctrl + ; : it show just date.
Ctrl + shift + ; : it show you just the time.
Len: it will calculate for you how many liters you have in one word.
Roman: it will change your number to roman language, for example 3 = III.
AltGr + =: it will count your numbers essay
Successfully you have done. I wish success for you dear, if you want to see more amazing and helpful/ fresh articles then enter your email address. That’s all, if you have any question regarding this I am ready to answer
By: lutfullah moqadam