You will find out how to summarize cells that have a same color of the font, the red one in my case. Really useful when working with different types of specific data in Excel.
If you are using the same entries all over again, you can create a custom list with these entries and when you need it just enter the first one then drag the cell down for the rest to fill out automatically.
If you know how many years or months you got left until the retirement or any other event or project in your life, Excel can return you the exact date and the number of days left to reach it.
It often happens that we need to insert a table into the document. In this lesson we will show you how to create a table and then we will redesign it to be more transparent.
When you want to copy the result of the cell to another cell in Excel, the target displays an invalid references error messag. This error can be avoided by copying cell value into target cell and not the whole formulas.
Mail merge is one of the most useful features of Microsoft Word when wanting to send personalized letters, documents or e-mails to people you have stored in an Excel sheet. Let me show you how to use it.
