Excel has many functions to offer when it comes to manipulating text strings. The following is the list regarding to the arrangement of text. Alignment Function Find Vs Search Remove Unwanted Characters Text To Columns Number Of Instances Concatenate Strings Compare Text Lower/Upper Case Number Of Words Separate Strings Substitute Vs Replace
Without Array Formula | With Array Formula | F9 Key | Count Errors | Count Unique Values | Count with Or Criteria | Sum with Or Criteria | This chapter helps you understand array formulas in Excel. Single cell array formulas perform multiple calculations in one cell. Without Array Formula Without using an array formula, we would execute the […]
##### error | #NAME? error | #VALUE! error | #DIV/0! error | #REF! error This chapter teaches you how to deal with some common formula errors in Excel. ##### error When your cell contains this error code, the column isn’t wide enough to display the value. 1. Click on the right border of the column […]
Round | RoundUp | RoundDown | Even and Odd | Nearest Multiple This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function. Before your start: if you round a number, you lose precision. If you don’t want this, show fewer decimal places without changing the number itself. Round 1. Round […]
Average | Averageif | Median | Mode | Standard Deviation | Min | Max | Large | Small This chapter gives an overview of some very useful statistical functions in Excel. Average To calculate the average of a range of cells, use the AVERAGE function. Averageif To average cells based on one criteria, use the […]
Pmt | Rate | Nper | Pv | Fv 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) and a future value of 0 (that’s what you hope to achieve when you pay off […]
VLookup | HLookup | Match | Index | Choose 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 in the leftmost column of a table, and then returns a value in the same row from another […]
Year, Month, Day | Date Function | Current Date & Time | Hour, Minute, Second | Time Function | DateDif | weekdays | Time Sheet | Days until Birthday | Last Day of the Month | Holidays | Day of the Year | Quarter To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the […]
Relative Reference | Absolute Reference | Mixed Reference | Copy Exact Formula | 3D-reference | External References | Hyperlinks | 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 default, Excel uses relative reference. See the formula in […]
If Function | And Function | Or Function | Nested If | Ifs | Switch | Roll the Dice Learn how to use Excel’s logical functions such as the IF, AND and OR function. If Function The IF function checks whether a condition is met, and returns one value if TRUE and another value if FALSE. 1. […]
This article contains Count | Countif | Countifs | Sum | Sumifs | Count Text Occurrences | Count Logical Values | Count Blank/Nonblank Cells | Sumproduct 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 that […]
