Financial Functions Microsoft Excel provides a series of functions to perform various types of financial operations. These functions use some common arguments to solve a particular financial calculation. Basically, these…
Engineering Function CONVERT() Converts a number from one measurement system to another. CONVERT can translate a table of distances in miles to a table of distances in kilometers. The Syntax…
Data Validation Excel's data validation feature enables you to set up specific rules that restrict a user from entering invalid data. For example, you may want to limit data entry…
Definition of Logical Functions Excel’s logical functions are used to perform analytical tests to reveal whether a statement is true or false. Depending on the outcome of the logical trial,…
Understanding Formulas Basics The formula is what makes a spreadsheet program so useful. If it weren't for formulas, a spreadsheet would simply be a glorified world-processing document that has great…
Filling Series Excel Supports a wide variety of fill options. Go to Home Tab -> Editing Group -> Fill -> Series to display the series dialog box. There three types…
Introduction to Excel Excel is nothing but a spreadsheet program that has powerful tools and features, with the help of tools and features it analyzes the data and helps us…
Working with Rows and Columns Rows and columns make up an Excel Worksheet. Every worksheet has 1,048,576 rows and 16,384 columns, and these values can't be changed. You can insert/delete…
Learn Excel Online provides free step-by-step Excel lessons for beginners and professionals. Master formulas, functions, pivot tables, charts, and data analysis with practical examples.