Tips and Tricks

You can’t find a formula bar? In this lesson you can learn how to fix it.

Excel is not the best application to write books but it happens that you need page numbers.

In this lesson you can learn how to calculate ROE in Excel.

Learn here how to deal with blanks in your spreadsheet. For sure you can read here some stuff which will make your life easier.

I show you how to update value in cells without using formula. But I did it wrong. It should be doubled. How to correct it without formula?

Learn how to calculate XIRR for Annualized Returns for free with Excel Easy Tutorials Best Excel Tutorial. You wouldn’t be disappointed.

Do you know how to calculate modal in Excel? If not you will learn here for sure

Use PHP to create Excel files. Excel can cooperate with other programming languages. With PHP as well.

In this lesson you can learn how to calculate ROIC in Excel.

In this article you will learn how to sort data in a pivot table. You may need this for better visual eg. top buyers.