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.
Microsoft Excel allows you to sort your data in a number of different and custom ways, let's learn how to sort Excel data according to the color of the fonts.
You don't need Photoshop or some other advanced piece of software to resize a large number of images at once. You can use Microsoft Office Picture Manager which is part of the Office suite.
Sometimes when you are writing a title, one last word jumps into the next row. If you don't want to change the font size, there is another way to deal with these so called widow words.
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.
