Office Solutions

How to Use AND, OR and NOT Functions in Conditional Formulas

You can use conditional formulas in conditional formatting. And in this article, we will explore how to use AND, OR and NOT functions in the conditional formulas. In conditional formatting, you can use the combination of IF function and AND, OR or Not functions. Besides, in conditional formulas, you can omit the IF in the formula. Below we will talk about the usage in detail. AND Function In the image below, we want to highlight the months with the criteria: the sales volume of...

Read more »

3 Effective Ways to Put Texts on a Picture in Your Word Document

In today’s article, there will be 3 effective ways available for you to put texts on a picture in your Word document. Have you met such a situation when you need to add words on a picture and you happen to have no picture tool at hand? Been there, right? Here is the good news. Actually you can easily achieve this task in Word. So just take a look at our methods and you can say goodbye to complicated picture tools. Method 1: Simply Change the Text Wrapping Style Firstly, click...

Read more »

How to NOT Append the Default Signature to New Outlook Messages Created from Template

If you’ve specified a default signature in Outlook, when you create a new message from a template, the signature will be added automatically too. If you dislike it, you can use the quick method introduced in this article to disable it. When composing message templates in Outlook, you may get used to including the signature directly in the template. However, when you create a new email from the template, Outlook will automatically insert the default signature as well. In this case, there...

Read more »