IF statement is used to test whether a certain condition is met. Sometimes you can have more than one condition to test, thus creating an If statement within another if statement (nested if statement). This enables you to come up with a statement with many possible outcomes. The excel If () function is used when
Concatenate is an excel function that allows you to join two or more strings together. When creating a Pivot table, you may want to combine data from two or more columns to form a single column. An example, you may wish to combine the names field with the address field to form a single column
A Pivot table is one of the powerful features in excel for any data analyst. The feature allows you to extract data from a large dataset. You can also create a multi-level Pivot table to analyze data. To help you understand how to create a nested PivotTable, we will use a data set consisting of
1. TODAY function This function returns the current date. This function is useful when you want the current date displayed on your worksheet. The returned value will be updated each time the worksheet is recalculated or when you open the workbook. Syntax =TODAY () The function has no arguments. Example =TODAY() this function returns current
Find and replace is an excel feature used to search for specific data in an excel worksheet or within a workbook and what you do with the data found. This article will explore different ways you can use find and replace together with using advanced find features. Scanning through columns and rows in a large
Sometimes when working with Excel, you may need to do a calculation that involves several formulas. One way of handling this is to break each formula out in its own cell. Another more elegant solution is to nest those formulas or combine them. Let's look at an example. The above sheet is a bonus calculator
The IF Function with a single condition IF Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct tests on values and formulas. Syntax IF(logical_test,value_if_false) A logical test is any value or expression that can be evaluated to TRUE or FALSE. For
Advanced excel formulas can be used to lookup values or text in Excel and return the relative cell address. An INDEX function can be used to MATCH the lookup value in a range of cells. INDEX function can be used in two ways, INDEX reference and INDEX array The reference form returns the reference to
If formula can be used together with VLookup formula to return an exact match of values and an empty string if the value is not found. The combination of these formulas makes excel tasks more effective. Example: Look for a commission using the Vlookup function Calculate Bonus by getting a product of total and commission.
Excel spreadsheet is a common tool used by every accountant or financial analyst to analyze, report, and share financial information. Some basic excel functions let you perform complex calculations and produce useful models making your work more effective and easier. Excel can become a more versatile tool if you increase your knowledge on more other