Microsoft Word is a word processing program that is used for letter writing, creating documents and reports, etc. MS Excel is a spreadsheet program that is used to save data, make tables and charts and make complex calculations. Collection and Verification of Business Data.At its most basic level, Excel is an excellent tool for both data entry and storage. The 7 Most Popular Uses Of Excel For Your Business It has advanced features which allow you to format and edit your files and documents in the best possible way. Used to make professional-quality documents, letters, reports, etc., MS Word is a word processor developed by Microsoft. The number 1 use of MS Excel in the workplace is to do business analysis. Top 10 Uses of Microsoft Excel in Business You can enter functions into your worksheets manually, with a macro, or by using the Insert Function dialog box and the Formula palette. You can include a maximum of 1,024 arguments in a function, providing that no single string of characters in the function statement exceeds 255 characters. For example, you can use as many arguments in the SUM function as necessary. Some functions allow a variable number of arguments. The arguments row_number and column_number are required arguments, and the remainder of the arguments are optional. =ADDRESS(row_number,column_number,absolute_number,a1,sheet_text) For instance, the following is the format for the ADDRESS function, which returns a value about a cell address in a worksheet: Some functions require additional information, which is discussed in this hour.

Include information about a cell or range of cells to be analyzed.Įnter arguments about what to do with the selected range of cells. Start a function with an equal sign ( =). Other functions combine several formulas or procedures to achieve a desired result.įunctions should be entered in the following basic order: These simple formulas are the foundation of many functions. For example, the formula =SUM(B4:B8) inserts the sum of the numbers contained in the range B4 to B8 into the cell containing the formula. Understanding How Functions WorkĮxcel uses straightforward formulas to perform simple calculations, such as adding or subtracting, on a number or series of numbers. In other words, functions help answer your questions so that you can evaluate and examine your business and make projections. Functions are tools you can use to analyze data and get information.

15 uses of microsoft excel