Excel
Microsoft Excel also called spreadsheet, developed by the Microsoft for various Operating Systems like Windows, Mac, Android and iOS.
Microsoft Excel
Logan Clark // Microsoft Excel // Microsoft Office // www.office.com/setup
formulas and functions in excel
In this blog, we are going to provide a list of basic Excel formulas
and functions with examples and with more in-depth insight.
Microsoft Excel is extremely an excellent and powerful spreadsheet when it comes to calculating numbers or solving mathematical equations at the engineering levels. It do the calculations with the in the blink of an eye either it’s an average of hundreds of cell or any other calculation. Apart from that, we can compute an interest, make the roaster of the employee, and calculate their shift timing, over time and salaries within no time. Excel can be used for making and maintaining different record like company performance, population index, and pollution and school time tables as we.
the basics of excel formulas
Before we introduce you with the basic Excel formulas list, let’s me here define the you with some key terms just to make sure you that you have an clear idea of the working of both. Excel formula and Excel function?
· Formula which is done manually by the user by adding different values or to calculates the value of a cell.
For example, =A1+A2+A3+A4 is a formula that adds up the values in cells A1 to A4.
· Function is a predefined formula already exists in Excel. Functions perform specific calculations based on the arguments and parameter mentioned in the function body.
For example, doing the manual calculation in excel by selecting each cell you can do the same by taking the SUM function to add up a range of cells: =SUM(A6:A10)
All the Excel functions are available in the Function Library on the Formulas tab:
Smarter insertion of functions
In Excel, we do have more than 400+ functions in Excel, and this number is growing by version to version. Of course, actually it is impossible to remember all of them, and you actually do not able to need to do so. The Function Wizard will help you find the function which is best suited for a particular work, while the Excel does provide you autocomplete setup of functions when to try to put any, it shows you the further parameters of that function.
SOME BASIC FUNCTIONs which you SHOULD knows
Below mentioned is a list of 10 simple very helpful functions that you should know in term of using Excel at the professional level.
SUM
This Excel function enables you to perform the basic arithmetic operation of addition:
SUM(number1, [number2], …)
In this Excel functions, atleast one argument is must required where as second argument in the enclosed in [square brackets] is optional.
AVERAGE
This Excel AVERAGE function does exactly the same as the name suggests, i.e. finds an average, of the group of number or the sum of different values
AVERAGE(number1, [number2], …)
In this example we are taking thE sum of the cell range from A2:A6 and then taking average of it by dividing it with 5. (=SUM(A2:A6)/5).
Microsoft Excel Release History
Microsoft Excel first version was released for Macintosh systems in 1985, the after the gap of 2 years Windows gets its version in 1987. The following is a list of Excel releases for Windows:
Excel 2.0 (1987)
Excel 3.0 (1990)
Excel 4.0 (1992) – Included in Microsoft Office 3.0
Excel 5.0 (1993) – Included in Microsoft Office 4.0
Excel 95 (1995) – Included in Microsoft Office 95
Excel 97 (1997) – Included in Microsoft Office 97
Excel 2000 (2000) – Included in Microsoft Office 2000
Excel 2002 (2002) – Included in Microsoft Office XP
Excel 2003 (2003) – Included in Microsoft Office 2003
Excel 2007 (2007) – Included in Microsoft Office 2007
Excel 2010 (2010) – Included in Microsoft Office 2010
Excel 2013 (2013) – Included in Microsoft Office 2013
Office Setup
Copyright © 2018 setup-office.com,
All Rights Reserved.
Location
7303 De Soto Ave
Canoga Park
CA91303