Excel formula for every other row color

Formatting makes our documents look appealing to our eyes. The power of conditional formatting is far-reaching. Excel has not been left behind since we can use a specific formula to…

Comments Off on Excel formula for every other row color

Excel formula for Amortization

The process of amortization involves paying back a loan for a given period of time until the loan is fully paid. For a long time, amortization calculation used to be…

Comments Off on Excel formula for Amortization

Excel formula for average balance

Average balances are closely associated with bank transactions and credit cards. One can easily calculate his or her average balance depending on the amounts spent.   1. Simple average balance…

Comments Off on Excel formula for average balance

How to sort alphabetically in Excel and keep rows together

I understand using excel can be a daunting task, especially to newbies. The good thing is that there are many online resources to help you maneuver every corner of MS…

Comments Off on How to sort alphabetically in Excel and keep rows together

How to apply the same formula to multiple cells in Excel

For excel, nothing saves time than the use of formulas. As a matter of fact, this is the bread and butter of this Microsoft Office application. However, crafting a useful…

Comments Off on How to apply the same formula to multiple cells in Excel

Excel extract text from string between characters

Microsoft has been in use for a long time to create grids of texts. It is essentially a spreadsheet program which is the reason why it's so successful in creating…

Comments Off on Excel extract text from string between characters

Apply formula to the entire column without dragging

Excel is helping people and businesses solve some of the hardest tasks. This Microsoft application also makes it very easy and simple for anybody to compute some problems that would…

Comments Off on Apply formula to the entire column without dragging

How to auto fill numbers in excel without dragging

If you can use excel the right way, I don't see any need to reach out for your calculator to do the math. Excel just needs some simple formulas and…

Comments Off on How to auto fill numbers in excel without dragging

How to Split cell diagonally and fill half color in Excel

Excel actually is one of my favorite spreadsheets due to its great formatting features. One can format any content that is housed in the worksheet including cells. You can also…

Comments Off on How to Split cell diagonally and fill half color in Excel