##### 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 […]
Embed Embed an Excel worksheet in a Word document and work with Excel in Word. You can also embed files in Excel. 1. Select the Excel data. 2. Right click, and then click Copy (or press CTRL + c). 3. Open a Word document. 4. In word, on the Home tab, in the Clipboard group, […]
In last post we have learn how to merge two cells using CONCATENATE but there is another easy way to combine different cells that is using & operator. This method is very easy as compared to Concatenate because typing the & is much easier and quicker than typing the word “concatenate”.Combining by & Operator In this […]
MS excel is the application that can solve your every problem in calculation but there is now any button to join/combine two or more cell into new one cell. In this article we will learn how to show two or more values in one cell from different cells. Merging or combining different cell is common […]
What is Workbook? Workbook is another name of MS excel file. when a user open MS Excel and it automatically display an empty workbook. Opening Workbook If you have created a file (Workbook) and you have saved in you PC. There are two options to open that file. 1. Open the file from saved […]
MS Excell is easy to calculate any thing just in seconds. you need to just enter the formula then enoy the rest part. so lets start how to find any answer. see th following figure Managing Formula Entering Formula Dynamic Named Range Names in Formulas Paste Options Status Bar Percent Change
