Basic of Excel

Before we study how we can use Table Style, lets understand how to change the color of the text, background of the cell or customize it. To Change the color…

Math Functions Sumif() The SUMIF function calculates the total of only those cells that meet a given condition or criteria. The syntax for the SUMIF function is : =SUMIF(Range,Criteria,Sum Range)…

Types of Paste Special in Excel You may not always want to copy everything from the source range to the destination range. For example, you may want to copy only…

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,…

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…