![]() To match a literal question mark or asterisk, use a tilde (~) in front question mark or asterisk (i.e.A question mark matches any one character and an asterisk matches any sequence of characters (zero or more). The wildcard characters ? and * can be used in criteria.Cell references in criteria are not enclosed in quotes, i.e. "Text strings in criteria must be enclosed in double quotes (""), i.e.Use the COUNTIFS function for multiple criteria. Use the EXACT function for case-sensitive counts. Essentially, COUNTIF returns two counts in an array (one for "red" and one for "blue") and the SUM function returns the sum. The formula above will count cells in range that contain "red" or "blue". Putting forward all these uses, MS Excel has been proved to be an important resource for business and financial analysis.= SUM ( COUNTIF (range, )) // red or blue Human Resource Professionals use this to take the whole employee journal in bulk and use it to plan future credit and decide whether to invest more or not, making it important for the control of the future. Even better, it allows you to customise the colours and boundaries of the charts and pie diagrams!Ĭontaining over 1,048,576 rows and 16,384 columns each in the spreadsheet, with hundreds of them, or even more if your PC is capable, in a single file, Excel allows you to create spreadsheets bigger than 20 A1 papers! You can import data from other spreadsheets and add pictures and other objects through the insert tab, making it easy to put all the data you collected in various files in one place.Īlthough there are other systems such as Oracle, or QuickBooks for planning this, Excel allows you to manage it all in one file! You can summarise an employee’s expenses, their pay per hour, and easily discover wrong entries. MS Excel makes it easy to do so! After filtering and correctly inputting data, you can turn it into a Pie Chart or Clustered Columns with a single click. If you are working in a large association where the boss wants the detailed visual representation of the various sectors of the business, you’ll need to draw charts. Using a web-enabled PC, mobile or tablet, you can use the same programme and access the same file remotely, making it easy to do changes if you can’t access your PC and need to send the spreadsheet immediately! You can use them to highlight specific entries in Accounting.Įxcel is part of the Office 365 Productivity Suite, Which means that business employers and their employees can easily access their files over the cloud network, free from the bondages of file transfer. A number of tasks achieved through this tool are beyond impressive, with entire row highlighting and comparing lists and values to name a few. The various formatting options, including italics, highlighting, and colours, allow businesses to bring the most important data to be different from the rest. This feature can be used to easily make a company’s yearly sales and other spreadsheets. With a vast program full of formulae, it can add, subtract, multiply and divide hundreds of numbers altogether, and can easily re-do it if a value is changed or added. Perhaps the most important use of MS Excel is using its ability of mass arithmetic calculations. So, let’s start! IMPORTANCE OF MS EXCEL IN OUR DAILY AND BUSINESS LIVES: That’s WRONG! Today, we are going to look at some of the major important purposes MS Excel is most used for. However, many still believe it is just a mere tool for small business purposes. Fast forward to the future after 31 years, it is now the most commonly used program for creating graphs and pivot tables. MS Excel is a spreadsheet programme developed by Microsoft in 1985, with the sole purpose of helping businesses compile all their financial data, yearly credit, and yearly debit sheets. Importance of MS Excel in our daily & Business Lives WHAT IS MS EXCEL?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |