Many users prefer to manage Outlook appointments by “Color Category” . So they hope that Outlook can auto categorize new appointments. This article will introduce how to realize it.
The article “How to Auto Categorize Appointments in Outlook Calendar” introduces a workaround. It uses Conditional Formatting to color code the appointments. Actually it just assigns a color to the item, not uses color category. Besides, Conditional Formatting relies on view settings. That is to say, if you...
Read more »
When you are working on your Excel file, you will probably have a need to note down the current date and time. Therefore, here we will discuss about 3 methods to achieve this task.
Knowing when you have modified a file is very important for you to track changes. Thus, sometimes you will insert the current date and time into a worksheet to make a mark. Instead of manually inserting date and time into cells, you can also use the three methods in this article. And in the coming passage, we...
Read more »
Excel has provided you with many practical functions. And in this article, we will introduce three methods to help you quickly know the function arguments.
You will probably have met with such a condition: When you are working in Excel and you need to use a certain function. You cannot remember the detail function arguments. However, at this moment, you cannot connect to the Internet and search for this function. The result is that you will spend even more time to finish this task or you...
Read more »
