Posted in General

The Secret Copy & Paste Trick (10x Faster!) – Windows 10

We all do ‘Copy & Paste’ every now and then.

Yet we often find it annoying to be able to paste only the most recent item.

Let’s have a look at Windows 10’s clipboard history that will make the copy-paste process much easier.

Using this Win+V will surely boost up your productivity in day-to-day work.

Posted in Excel

How to list files in folder & subfolders with Excel – no formula needed!

Let’s see how we can quickly list all files in folder and subfolders using Power Query. It took only 30 seconds – less than 10 clicks away!

Remark:
Power Query is readily available with Excel 365, Excel 2016, Excel 2019.
For Excel 2010/2013, you can install the Power Query add-in for free following the instructions provided in the following video: https://www.youtube.com/watch?v=gwW2CDdvUUs