Pivot table can help us manage large data and information. In this article, we will introduce how to group or ungroup data in a pivot table.
There are many useful features in pivot table. And those features make the pivot table a very useful tool for data analysis. The image below shows the pivot table in a worksheet.
The first column is the date of the range. By default, they will all be listed in the column A. But if you need to know the sales volume in a certain period, such as in a...
Read more »
Several times SQL Server might be the reason for the space issue on disks. In this article, we will see what the root causes for this issue are and how we can fix it.
Your SQL Server needs space.
Many times SQL Server will need disk space. This might be because of growing data inside your database or unshrunk log files or undeleted backup files or undeleted, unwanted database files. Whatever the reason is, on a SQL Server, space on the disk is very important for database...
Read more »
Outlook supports you to design forms, no matter the message, task, appointment or contact form. Have you ever wanted to create a drop-down list in the default forms? This article will take Contact form as an example and teach you to create a custom drop-down list.
When I create new contact, I tend to input the relationship with this contact, such as colleague, superior, friend, relative and others. In the past, I just created a new custom field called as “Relationship”, like the following...
Read more »
