![]() How do you use the ‘text’ functions in Excel? Is it possible to join the text of two or more cells in Excel? Working with arrays of data can be time-consuming and make one prone to mistakes, and the content on ‘lookup’ and ‘reference’ functions will teach you how to use ‘vlookup’ and ‘hlookup’ to automatically perform tasks to save time and avoid errors. The second module of the course begins with the explanation of the ‘text’ and ‘concatenation’ functions. We then move on to some key financial functions that can execute a variety of calculations and are commonly used in business and even in our personal lives and these functions are taught step-by-step. This course demonstrates the role of ‘logical’ functions in decision-making, whether you’re comparing marks scored by students or deciding who gets a sales bonus. What are the ‘logical’ functions in Excel? What Excel functions are used in accounting? What is the use of the ‘lookup’ function? Our step-by-step explanation will introduce you to each function and its arguments and syntax as we explain how and where to use each formula. This free online Excel course provides a hands-on tutorial on how to use twenty-five advanced functions in the following categories: logical, functional, text, lookup and reference. They help in finding the maximum and minimum number respectively from a large data base.Microsoft Excel organizes your data and saves you time by using its built-in functions to make calculations and create charts and graphs. These are the most easy functions in excel. If you need to logically test a number or a text through a formula and check the results in two different scenarios (if the logical test if true and if the logical test is false), then IF serves as the best function to check the same.įor example If in a class total marks allocated to students are 700 and student who scores more than 300 passes the exam and if not, then he fails. This acts as a tester function for two scenarios, IF TRUE or IF FALSE. From simple to complex problems can be solved using IF function. ![]() IF function is a very useful function in the overall excel. And, you can also use AVERAGEIFS function similar to SUMIFS and COUNTIFS. This works similar to SUMIF and COUNTIF function. The function can also be used for calculation of Mean of the given data.ĪVERAGEIF function is used for calculation of average of filtered data with specific criterias. If we have a large data belonging to different categories then the function will give the count of different categories.įor example if a company is selling 2 products and wants to check each products sales count they can do so by using COUNTIF function.ĬOUNTIFS is another function which can be used for counting selected data with more than one criteria.ĪVERAGE function calculates average value of the data selected. The function is used to count the selected data with criterias. It is most common and easy function to use in excel.ĬOUNTA function is used for also counting the cells with error in formula. Similarly, SUMPRODUCT function can be used for multiplication of various variables which can be even more than two (2).ĬOUNT function is used for counting the numbers of items in the selected cells. SUMPRODUCT function is used for adding various ranges which derived through multiplication of two numbers.įor example if you need to find total marks of the overall class through addition of marks coming in different subjects. For example if we need to find the sum of Product A and Product B individually sold to different geographies, we can use SUMIFS function to get the results. Similarly, we can also use SUMIFS if Categories are more than one (1). If we have a large data belonging to different categories then the function will give the sum of different categories.įor example if a company is selling 2 products and wants to check each products sale they can do so by using SUMIF function. The function is used to sum the filtered data. It is the very first function of excel to know and the function can be used in 2 ways:Ī) Selection of overall range together after incorporating sum formula and then clicking enterī) Individual selection of overall range after incorporating sum formula and then clicking enter The function is used for simple addition of multiple numbers. View Course List of prominent and basic excel Formulas for Beginners
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |