In Microsoft Excel you canĀ use formating tools like colors, text alignment, font styles and many more to make your sheets look nicer and more transparent.
Word is becoming stronger in graphic design tools and I will show you something really neat today. We will draw a custom shape and add your favorite gradient colors.
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.
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.
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.
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.