# MS Excel Tutorials

Tutorials Shared by the Internet Community

 Top Tutorials New Tutorials Submit Login Register

 Basic Concepts (16) Charts and Graphs (3) Data Entry (2) Functions (18) General Development (3) General Formatting (4) Interfaces (0) Security (0) Using Macros (0) Misc (1)

• ### Using Check boxes in Excel

The following tutorial will show you how to use Check boxes in Excel. You can use check boxes are ways of displaying text or figures that can be used
https://www.excelbuddy.com/excel-tutorial-database/using-check-boxes-in-excel/
• ### Selecting All Formula Cells in a Worksheet

Sometimes when working in Excel, it can be helpful to quickly identify or select all of the cells in a worksheet which contain formulas.
https://www.excelbuddy.com/excel-tutorial-database/selecting-formula-cells-worksheet/
• ### Print to Fit on X Number of Pages

Sometimes when using Excel you may want to customize the way that you print the information you are working with.
https://www.excelbuddy.com/excel-tutorial-database/print-to-fit-on-x-number-of-pages/
• ### 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/
• ### 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/
• ### 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/
• ### Android 7.0 Nougat Features

Google releases out Android 7 Nougat having more than 250 updates, and the major updates that can offer much help for the android developers are detai
http://www.agriya.com/blog/2016/08/26/android-7-0-nougat-features-what-is-new-behind-the-s...
• ### AngularJS vs jQuery

AngularJS is definitely better than jQuery in many facets. AngularJS is Very Strong Community Backing and Code Style is very declarative.
http://www.agriya.com/blog/2016/06/07/angularjs-vs-jquery-comparative-study/
• ### 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
• ### 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...
• ### Lookup and References in Excel: VLOOKUP, HLOOKUP, MATCH

Lookup and Referencing is a very important feature of MS Excel.
http://www.certiology.com/tutorials/excel-tutorial/vlookup-hlookup-match-index-and-choose-...
• ### 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
• ### Cell References in Excel: Absolute, Mixed and Relative

Cell references are very important in MS Excel. Cell referencing works in formulas and other automations performed within MS Excel. It is further clas
http://www.certiology.com/tutorials/excel-tutorial/cell-references-in-excel.html
• ### 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
• ### Worksheet in Excel: How to Select, Insert, Rename, Move

Worksheet plays a highly important role in MS Excel as all the automation in MS Excel requires worksheet as a key reference. In this tutorial you will
http://www.certiology.com/tutorials/excel-tutorial/worksheet-in-excel.html
• ### 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
• ### Logical Functions in Excel: IF, AND &amp; 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
• ### 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
• ### 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
• ### 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
• ### 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-...
• ### 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