MS Excel Functions Tutorials

Tutorials Shared by the Internet Community

Advertisements
  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 18 Tutorials

gap line

Most Recent Tutorials


  • 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
    • 351 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...
    • 295 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
    • 262 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
    • 255 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
    • 182 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
    • 294 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
    • 269 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
    • 264 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
    • 246 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-...
    • 181 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
    • 269 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
    • 170 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Measurement Conversions in Excel

    Need to convert measurements for international clients? Check here
    http://www.versitas.com/blog/2011/09/12/a-few-excel-tips/
    • 33083 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Stay Organized Using Countifs

    Using Countifs for Organization
    http://www.versitas.com/blog/2012/09/25/excel-tips-stay-organized-using-the-countifs/
    • 33051 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Data Validation

    How to use data validation for dropdown lists
    http://www.versitas.com/blog/2011/03/21/excel-tips/
    • 33251 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Median Function

    The median is widely used in statistics ...
    http://excel.officetuts.net/functions/statistical/median.php
    • 32870 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • Main Functions and Formula

    pre-defined functions in Excel
    http://www.computerfreetips.com/may_tips/25-05-07.html
    • 33204 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

« PreviousNext »


Advertisements