The “Find and Replace” function or Ctrl + F is a nice feature in MS Office, and we all know how useful it is; however, it does not seem to work in an Excel spreadsheet having thousands of cells as it gives you the following error ...
Ever wanted to combine text from multiple cells into one cell in Excel? When you have a large Excel sheet and you want to combine text from multiple cells into one cell, you don’t have to keep on entering those values into the cel...
Are you someone who has been struggling with trying to manually calculate only the active worksheet in Excel? Do you have big Excel workbooks with a lot of worksheets containing calculations and formulas? When a recalculate is per...
Do you know how to rename worksheet tabs in Excel? Microsoft Excel has been in use for years now and is one of the most important components of the Microsoft Office suite. It is used by everyone, be it in schools, colleges or in o...
Have you ever tried to customize and use the status bar in Excel? Are you someone who uses Microsoft Excel frequently? The status bar displayed at the bottom of the Excel window offers a lot of interesting features. It is easy to ...
No matter how easy and convenient the mouse-click is, there is no doubt about the power of the alternatives (i.e. keyboard short-cuts). A keyboard short-cut can give rise to more productivity than a mouse-click can, the only probl...
If you’re working on a spreadsheet with lots of rows and columns to fill, you could end up deleting some blank rows that you don’t really need. For example, if you’ve deleted data from specific rows, they’ll be left blank and can ...
Excel’s TEXT function is one that you can convert, or combine, numbers and text with. You can also add it to spreadsheets to convert numbers to alternative formats. The basic syntax for this function is TEXT(value, format). ...
LCM (Least Common Multiple) is an Excel function that returns the least common multiple of values. The least common multiple is the lowest integer (a number without fractional component) that is a multiple of all the selected numb...
EDATE and EOMONTH are two date functions you can add to your Excel 2010/13 spreadsheets. These are functions that return that add or subtract months from a specified date. EMONTH returns the last day of the month and EDATE adds or...
GCD (Greatest Common Denominator) is another function you can add to Excel 2010/13 spreadsheets. The function finds the greatest divisor between two or more integers (numbers without fractional components). It returns the largest ...
This post covered the FACT Excel function that you can find factorials with. You can also find double factorials with Excel 2010/13. The double factorial is the product of all integers from one up to a non-negative integer n with ...
A nominal interest rate for a loan is one that does not factor in compound interest. However, as interest rates are compounded monthly, or quarterly, the effective rate of loan interest is slightly higher. To find the effective ra...
Excel has numerous functions that you can add to spreadsheets. Among them are ODD and EVEN. Those are functions that round numbers to the closest odd or even values. To add the ODD function to spreadsheets, click the fx button. Th...
Excel 2010/13 has a variety of financial functions. Among them is the ISPMT function, which returns the interest paid for a specific period of a loan. The ISPMT sysntax is ISPMT(interest_rate, period, number_payments,PV). For exam...
