MS Excel Functions Tutorials

Tutorials Shared by the Internet Community

Advertisements
  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 27 Tutorials

gap line

Most Recent Tutorials


  • SUMPRODUCT and EXACT Formula

    Learn to use the sumproduct and exact formulas.
    https://www.excelbuddy.com/excel-tutorial-database/sumproduct-exact-formula/
    • 88 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/
    • 128 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...
    • 122 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/
    • 116 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/
    • 97 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/
    • 114 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/
    • 87 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/
    • 95 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
    • 6461 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...
    • 5108 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
    • 4815 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
    • 4485 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
    • 3605 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
    • 5172 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
    • 4752 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
    • 4446 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
    • 4267 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • How to Protect a Workbook with Password in MS Excel 201

    The protection level implemented in MS Excel is password protected and hence, without a correct password, it cannot be unlocked. To make your Excel fi
    http://www.certiology.com/tutorials/excel-tutorial/protecting-a-workbook-in-ms-excel-with-...
    • 3309 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Excel Keyboard Shortcuts: A List of Keyboard Shortcuts

    In MS Excel, you have plenty of keyboard shortcuts available that will help you performing your tasks in a quicker way. This tutorial will discuss the
    http://www.certiology.com/tutorials/excel-tutorial/excel-keyboard-shortcuts.html
    • 4750 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • MS Excel Formulas and Functions

    Microsoft Excel provides the flexibility to use these formulas and functions in an entirely convenient manner. As long as you have the understanding a
    http://www.certiology.com/tutorials/excel-tutorial/formulas-and-functions-in-ms-excel.html
    • 4001 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

« Previous 1 2 Next »


Advertisements