Dasun Sanaka

0 Subscribers
27 Shares
279 Media views
0 Likes
  • 4 months ago

    Dasun Sanaka shared excel filter function

    excel filter function

    Optimize Data Analysis with Excel's Filter Function – Uncover hidden insights in your spreadsheets using Excel's powerful filter function. Streamline data manipulation and effortlessly sort, search, and visualize information. Improve produc

  • 5 months ago

    Dasun Sanaka shared mod function excel

    mod function excel

    Unlock Excel's Power with the MOD Function! Learn how to use the MOD function in Excel for precise data manipulation. Our step-by-step guide simplifies calculations, making your spreadsheets more efficient. Discover real-world examples and

  • 6 months ago

    Dasun Sanaka shared Excel If Function

    Excel If Function

    In this post, we'll go over all the best practises for utilising Excel's IF function, including how to combine it with other functions like AND, OR, and NOT to simulate real-world scenarios. https://www.modelsbytalias.com/excel-if-functi

  • 7 months ago

    Dasun Sanaka shared Excel Roundup

    Excel Roundup

    The Excel ROUNDUP function rounds a number up to a specified number of digits. It is helpful for avoiding decimal places, adjusting for precision, and rounding up values in spreadsheet calculations. https://www.modelsbytalias.com/excel-rou

  • 7 months ago

    Dasun Sanaka shared Excel Filter Function

    Excel Filter Function

    The FILTER function is very good for making visual comparisons between a data and subsets of the data based on criteria set. In this post we would provide a detailed guide regarding the use of the FILTER FUNCTION.

  • 8 months ago

    Dasun Sanaka shared Excel Mod Function

    Excel Mod Function

    The MOD Function may seem bland and useless, but when combined with other functions, it has tons of uses. Let's take you through the MOD Function and how you can utilize it in your financial models. https://www.modelsbytalias.com/excel-mod

  • 8 months ago

    Dasun Sanaka shared Subtotal Function In Excel

    Subtotal Function In Excel

    The subtotal function is a very handy function to use when you constantly apply filter to a dataset, and you need to see results instanty. Today we take you through the workings of the SUBTOTAL Function. https://www.modelsbytalias.com/exce

  • 8 months ago

    Dasun Sanaka shared Excel Roundup

    Excel Roundup

    The Excel ROUNDUP function rounds a number up to a specified number of digits. It is helpful for avoiding decimal places, adjusting for precision, and rounding up values in spreadsheet calculations. https://www.modelsbytalias.com/excel-rou

  • 8 months ago

    Dasun Sanaka shared Excel Sumproduct

    Excel Sumproduct

    The Excel SUMPRODUCT function multiplies corresponding elements in multiple arrays and then sums the products. It is used for weighted calculations, conditional aggregations, and array-based calculations in spreadsheets. https://www.mode

  • 8 months ago

    Dasun Sanaka shared Excel Match Function

    Excel Match Function

    The MATCH function can check for close and exact matches as well as partial matches using wildcards. We would explain the MATCH function in detail and provide instances of how it is used in modelling in this post.

  • 9 months ago

    Dasun Sanaka shared Excel Mod Function

    Excel Mod Function

    The MOD Function may seem bland and useless, but when combined with other functions, it has tons of uses. Let's take you through the MOD Function and how you can utilize it in your financial models.3

  • 9 months ago

    Dasun Sanaka shared Excel Mod Function

    Excel Mod Function

    The MOD Function may seem bland and useless, but when combined with other functions, it has tons of uses. Let's take you through the MOD Function and how you can utilize it in your financial models.

  • 9 months ago

    Dasun Sanaka shared Excel If Function

    Excel If Function

    In this post, we'll go over all the best practises for utilising Excel's IF function, including how to combine it with other functions like AND, OR, and NOT to simulate real-world scenarios.

  • 9 months ago

    Dasun Sanaka shared Index Match Multiple Criteria

    Index Match Multiple Criteria

    In our INDEX Function post, we treated the INDEX MATCH Function combination, however that was for single criteria lookup. In this post we would be reviewing how to combine the INDEX and MATCH Functions for a multiple criteria lookup.

  • 9 months ago

    Dasun Sanaka shared Index Match Multiple Criteria

    Index Match Multiple Criteria

    In our INDEX Function post, we treated the INDEX MATCH Function combination, however that was for single criteria lookup. In this post we would be reviewing how to combine the INDEX and MATCH Functions for a multiple criteria lookup. htt

  • 10 months ago

    Dasun Sanaka shared Excel Filter Function

    Excel Filter Function

    The FILTER function is very good for making visual comparisons between a data and subsets of the data based on criteria set. In this post we would provide a detailed guide regarding the use of the FILTER FUNCTION. https://www.modelsbytal

  • 10 months ago

    Dasun Sanaka shared excel if function

    excel if function

    In this post, we'll go over all the best practises for utilising Excel's IF function, including how to combine it with other functions like AND, OR, and NOT to simulate real-world scenarios. https://www.modelsbytalias.com/excel-if-function

  • 11 months ago

    Dasun Sanaka shared Excel Today Function

    Excel Today Function

    The today function in Excel returns both the current date and time, whereas the TODAY function only delivers the user's current date. The benefit of employing these routines is that regardless of when you open the spreadsheet, the date and

  • 12 months ago

    Dasun Sanaka shared count function in excel

    count function in excel

    The count function in Excel displays the total number of entries in a range of number fields. This implies that only numerical values falling within the chosen range would be counted. Visit our website for more details on the Excel count fu

  • 12 months ago

    Dasun Sanaka shared Excel Mid Function

    Excel Mid Function

    To extract a specific amount of characters from a text string, use the excel mid function. The start and stop points of the extracted characters can be specified by the user. Visit our website for additional details about the excel mid func

  • 12 months ago

    Dasun Sanaka shared how to filter data in excel

    how to filter data in excel

    Dates, text values, and numbers can all be subject to the filters. You can improve your analysis of your data by filtering a data set. By implementing a filter, you can accomplish your goal of focusing your analysis or viewpoint on one or m

  • 1 year ago

    Dasun Sanaka shared excel absolute value

    excel absolute value

    Excel's absolute function operates in the same manner as the vertical lines. It always produces a non-negative value when applied to cells with numerical values. Our variance analysis is enhanced by combining the ABS with additional functio

  • 1 year ago

    Dasun Sanaka shared Excel Today Function

    Excel Today Function

    The today function in Excel returns both the current date and time, whereas the TODAY function only delivers the user's current date. The benefit of employing these routines is that regardless of when you open the spreadsheet, the date and

  • 1 year ago

    Dasun Sanaka shared excel index function

    excel index function

    To return a value from a specific place in a range or array, use the INDEX function. An full row or column, or a single value, can be extracted using the INDEX. The Excel Lookup and Reference functions section includes the INDEX Function[1]

  • 1 year ago

    Dasun Sanaka shared Index Match Multiple Criteria

    Index Match Multiple Criteria

    However, that INDEX MATCH Function combination was for a lookup based on a single criterion. Although it was for a single criteria lookup, we covered the INDEX MATCH Function combination in our piece on the INDEX Function. For a multiple cr

  • 1 year ago

    Dasun Sanaka shared How To Filter Data In Excel

    How To Filter Data In Excel

    Dates, text values, and numbers can all be subject to the filters. You can improve your analysis of your data by filtering a data set. By implementing a filter, you can accomplish your goal of focusing your analysis or viewpoint on one or m

  • 1 year ago

    Dasun Sanaka shared Vlookup Excel

    Vlookup Excel

    One of the most well-liked and often used Excel functions is vlookup. When looking for values in a vertically arranged data table, the Vlookup function is utilised. It can search for both close and precise matches, and you can even use wild


arrow_drop_up