Runakay

If you have to change the style of a Word document (like changing the color of the headings), you can do it manually by editing each text or you can edit the style only once.   For this, the recommendation is to set a style for the headings you work with, highlight the heading and go to "Styles" and select the one you want. Do this for all your headings.   Later, if you want to customize the style (like changing color) you can right-click on the style you are using and select "Modify...". In the new window edit the color for this style or other properties. Once you accept the edition, this will apply to the headings with the same style.   You will be able to change the style of your document easily by editing the style and no each text.

When you have many events in your Outlook calendar, it's useful to highlight them in different colors according to their categories.   It's possible to do this manually for each item, but you can set Outlook to do this automatically by right-clicking on an empty slot on the calendar and click on 'View Settings...'. In the new windows that appears, click on 'Conditional Formatting...'. The list of the rules already registered will be shown with the color assigned to each of them. Click on 'Add' and complete the field 'Name:' and select a color for this new rule. Then, click on 'Condition...'. There, you can set the filter for the events that will have the selected color by using different criteria.   Once the setting is finished Outlook will check each new item on the calendar to assign a color if it fits with the filters.

If the default way to get screenshots in Windows is to basic for you, let me introduce you Greenshot , a lightweight open source tool to make screenshots with the option to take a portion of the screen and then edit it. Once you make the screenshot, it's saved in the clipboard so you can use the capture immediately, but if you want, you can right click in the application icon in the taskbar and open the editor:   And add some marks and more: It's straightforward and has many options like capturing the mouse pointer, notifications, sound, default destination and more:   I use this tool as it's really practical, with many options and doesn't eat your memory, very recommendable. 

If you use Microsoft Outlook in your computer, you should have this application configured to reply emails by using blue fonts (not black):   To change this, just go 'File' and select 'Options' on the left: Then, go to 'Mail' and click on 'Stationery and Fonts...': In the new window, you will have fonts configuration, select the one in the section 'Replying or forwarding messages' and set the fonts as you like:   Now, when you reply or forward an email you will use the font as you set it.

The INDIRECT function in Excel allows you to reference cells by typing the cell position (for instance: "B2"). To clarify this, look at the first example, you can see in the function bar that it's a direct reference.    In the following example, the indirect function is used with the parameter "D3" as text and brings the same result. Now, as the parameter of the indirect function is text, you can concatenate and build the cell reference by using other cells.      It's clear that using a direct reference (example 1) is better than using the indirect function, however, there are cases where is required to build functions dynamically depending on other values and the indirect function is a great tool to consider for these situations.