## Excel Text Functions

Excel has many functions to offer when it comes to manipulating text strings. Join Strings To join strings, use the & operator. Left To extract the leftmost…

## Excel Lookup & Reference Functions

Learn all about Excel’s lookup & reference functions such as the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE function. Vlookup The VLOOKUP (Vertical lookup) function looks for a value…

## Excel Financial Functions

To illustrate Excel’s most popular financial functions, we consider a loan with monthly payments, an annual interest rate of 6%, a 20-year duration, a present value of \$150,000 (amount borrowed)…

## Excel Date & Time Functions

To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the “:” (colon). You can also enter a date and a time…

## Excel Cell References

Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success. Relative Reference By…

## Excel Logical Functions

Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If The IF function checks whether a condition is met, and…

## Excel What-If Analysis

What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily. Assume you own…

## Excel Count and Sum Functions

The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells…

## How to translate text in Excel

In some situations we need to translate text in excel from English to some other language. Here we are going to tell how to do…