MS Excel Functions Tutorials

Tutorials Shared by the Internet Community

Advertisements
  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 30 Tutorials

gap line

Most Recent Tutorials


  • MAX Function Usage

    The Excel MAX function returns the largest numeric value in a range of values.
    https://www.excelbuddy.com/excel-tutorial-database/max-function/
    • 93 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • INDIRECT Function

    The INDIRECT Function converts a text string into a cell reference.
    https://www.excelbuddy.com/excel-tutorial-database/indirect-function/
    • 104 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Rank Function Numeric Value Rank

    The Excel Rank function returns the numeric value when compared to a list of numeric values.
    https://www.excelbuddy.com/excel-tutorial-database/rank-function/
    • 139 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • SUMPRODUCT and EXACT Formula

    Learn to use the sumproduct and exact formulas.
    https://www.excelbuddy.com/excel-tutorial-database/sumproduct-exact-formula/
    • 213 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • EXACT Function in Excel

    The exact function compares two strings of text.
    https://www.excelbuddy.com/excel-tutorial-database/exact-function-excel/
    • 245 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • AVERAGEIFS Arithmetic Mean Multiple Criteria

    In this example, we will be using the AVERAGEIFS function. We will be finding the average of a data set if it meets multiple criteria.
    https://www.excelbuddy.com/excel-tutorial-database/averageifs-arithmetic-mean-multiple-cri...
    • 246 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Index Function Learn how to use in Excel

    The Index Function returns the value of an array given a specific row and column.
    https://www.excelbuddy.com/excel-tutorial-database/index-function/
    • 243 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Index and Match Replace vlookups in Excel

    Before reading this tutorial, please make sure you understand how to use the INDEX and MATCH function.
    https://www.excelbuddy.com/excel-tutorial-database/index-match-replace-vlookups/
    • 205 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • FV Function Future Value Calculation in Excel

    The FV Function is built into Excel. It is a financial function used to calculate the Future Value of an investment.
    https://www.excelbuddy.com/excel-tutorial-database/fv-function-future-value/
    • 199 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • CUMIPMT Function 15yr Mortgage

    The CUMIPMT Function in Excel is a financial function designed to calculate and return the cumulative interest paid on a loan.
    https://www.excelbuddy.com/excel-tutorial-database/cumipmt-function-15yr-mortgage/
    • 180 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • IPMT Function Calculate Interest of a loan

    Ever want to know how much interest you are paying for a current loan for any specific period?
    https://www.excelbuddy.com/excel-tutorial-database/ipmt-function-calculate-interest-loan/
    • 166 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Statistical Function in Excel: AVERAGE, AVERAGEIF, MODE

    In this article you will learn about Statistical Function in Excel that includes AVERAGE, AVERAGEIF, MODE, MEDIAN, Standard Deviation, MIN, MAX, Large
    http://www.certiology.com/tutorials/excel-tutorial/statistical-function-in-excel.html
    • 6561 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • The ROUND Function in Excel: The ROUND, ROUNDUP and ROU

    There are three functions to round numbers in MS Excel. The ROUND, ROUNDUP and ROUNDDOWN function. The ROUND function is used to round the fraction va
    http://www.certiology.com/tutorials/excel-tutorial/the-round-roundup-and-rounddown-functio...
    • 5200 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Text Functions in Excel: Concatenate, Left, Right and M

    String Manipulations in MS Excel facilitates its user to perform within string extraction. In this article you will learn about Text Functions in Exce
    http://www.certiology.com/tutorials/excel-tutorial/text-functions-in-excel.html
    • 4927 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Find and Select in Excel: Replace and Go to Special Fea

    MS Excel provides you the flexibility to use select, Find and Replace features to find specified text and replace it with your desired text.
    http://www.certiology.com/tutorials/excel-tutorial/find-and-select-in-excel.html
    • 4567 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Date and Time Function in Excel

    MS Excel supports multiple formats for data inputs. It also support date and time as a format and has the provision to apply various function over the
    http://www.certiology.com/tutorials/excel-tutorial/date-and-time-function-in-excel.html
    • 3694 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Logical Functions in Excel: IF, AND & OR Function in MS

    MS Excel supports logical and conditional functions which enables the user to perform conditional evaluations. In this article you will learn about IF
    http://www.certiology.com/tutorials/excel-tutorial/logical-functions-in-excel.html
    • 5272 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Count and Sum Function in Excel: CountA, CountBlank, Co

    The count and sum function is MS Excel is very important. In this tutorial you will learn count and sum functions, CountA, CountBlank, CountIFs, SumIF
    http://www.certiology.com/tutorials/excel-tutorial/count-and-sum-function-in-excel.html
    • 4853 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Share Data in MS Excel: How to Share Excel Data with Wo

    MS Excel is highly versatile and supports sharing its contents with other programs. Contents can be shared from MS Excel to MS Word, MS PowerPoint and
    http://www.certiology.com/tutorials/excel-tutorial/how-to-share-ms-excel-data.html
    • 4548 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Print in Excel: Print Gridlines in a Excel Worksheet

    In this tutorial, you are going to learn about how to setup your Excel sheet for printing. You will learn how to set margins, setting the printing pre
    http://www.certiology.com/tutorials/excel-tutorial/print-gridlines-in-an-excel-worksheet.html
    • 4343 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

« Previous 1 2 Next »


Advertisements