Solutions

2 Fast Means to Split an Excel Worksheet’s Contents into Multiple Workbooks Based on a Specific Column

At times, in data analysis, you may need to split the contents of an Excel worksheet into multiple Excel workbooks according to a specific column. Now, in this post, we will teach you 2 quick ways to get it. Many users frequently need to split an Excel worksheet that contains huge rows of data into multiple separate Excel workbooks based on a specific column. For instance, here is my sample Excel worksheet. I would like to split this sheet's data on basis of the "Price of single license...

Read more »

2 Ways to Batch Mark All Outlook Emails Older Than a Specific Date as Read

After importing multiple old emails into Outlook and these emails are in "unread" status, you must want to batch mark them as read. Now, in this article, we will show 2 quick methods to you. At times, you may need to batch mark multiple emails as read. For instance, you have an old PST file, which contains a plenty of old emails. Then, you import the emails into your own Outlook PST file. However, after importing, these emails are shown as "Unread" by default. At this time, you'll want to...

Read more »

3 Quick Methods to Recursively List All Files in a Windows Folder in Excel Worksheet

Many users need to quickly list all files in a Windows folder and all of its subfolders in an Excel worksheet. Therefore, in this article, we will introduce you 3 rapid ways to realize it. If you want to recursively list all files in a Windows folder in an Excel worksheet, you'll surely dislike copying the file names to Excel manually. Undoubtedly, it is too tedious and time-consuming. Hence, here we will teach you 3 much smarter and more convenient approaches Method 1: List Files in a...

Read more »