This article will mainly focus on showing you to insert a picture which can automatically update itself in Word document. Inserting picture into Word document has been a common tip for users to make their file attractive. However, when you modify...
Read more »This article will demonstrate you how to remove the formatting of pasted text with macro and VBA in your word. It happens a lot when you copy a text online, and you find the text is in rich formatting. For instance, there are repeating words,...
Read more »In Excel, you can use the icon sets to mark cells with different values. And in this article, we will talk about how to use this feature in Excel. Icon sets is a very useful feature in Excel. It is also a small feature of the conditional...
Read more »When you forward emails in Outlook, “FW” will be added to the subject by default. If you dislike it, you can apply the following 2 approaches to disable “FW” prefix in subject. As a rule, when we forward emails, the characters “FW:” will be...
Read more »If you often need to type the same content when you forward emails in Outlook, forwarding with a template will save you a lot of time. This article will exhibit two simple means about it. In my daily work, I’m often required to forward many...
Read more »In this article, we are going see some in-depth concepts about Microsoft Exchange PowerShell and Windows PowerShell Introduction: Exchange PowerShell, also called Exchange Management Shell, is a by-product of Windows PowerShell. Exchange...
Read more »This article will introduce how to enable multiple persons to edit the same Word file simultaneously with Microsoft OneDrive. From time to time, when you are out of town to have a meeting, there is the need to access a Word file online together...
Read more »If you want to create a chart in an Excel chart sheet, you can use the 2 methods in this article. You will certainly create a chart for a range in Excel. Sometimes instead of putting the chart in the same worksheet, you need to input the chart...
Read more »Count functions are the most frequently used functions in Excel. In this article, we will discuss about the different 5 count functions in detail. There are 5 variants of count functions: COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. Below we...
Read more »Now you can quickly insert line breaks in batch by using the shortcut keys and the find and replace feature. In our previous article 2 Quick Tips to Wrap Long Texts in Excel Cells so that All Contents are Visible, we have introduced two methods...
Read more »