Category Archives: Excel

How to Recover data from Hard disk, USB flash drive or SD card?

How to Recover data from Hard disk, USB flash drive or SD card

[sociallocker id=”1063″] #1. Download Testdisk for Windows, Linux or Mac from here. Plug in your USB flash drive, SD card or External Hard disk.

#2. Extract the zip file and open the file called Photorec, (Run as Administrator) it will open a Command Prompt. [/sociallocker]

#3. Now select a media, which you want to recover and press “Enter”.

Select a Media

Note : If you see the message “Please select the partition table type”, you need to select Intel for Windows and press Enter.

#4. You will see “To recover lost files, PhotoRec need to know the filesystem type where the file were stored”, choose other for Windows and Mac and ext2/ext3 for Linux, press Enter.

Recovered file type

#5. Next you’ll see “Do you want to save recovered files in….”, type Y and press Enter.
Testdisk recovery software

#6. The software recovering the files and save it to the destination folder. It will take around 10 min for 8 GB Pen drive to recover data.


Figure out slot from given time

Leave a comment

Posted by on April 20, 2016 in Excel


Update Report Filters Using Simple Macro – A Dynamic Pivot Chart Example | – Learn Microsoft Excel Online

Leave a comment

Posted by on April 1, 2016 in Excel


How to Record Desktop Screen with YouTube


Best of Chandoo

Best of – 2015

Posted: 31 Dec 2015 12:06 AM PST

2015 has been the busiest year since starting

Wow, that is 12 years of breaking previous records. Thank you.

In 2015, we published 124 posts (down 3% YoY), received 6,300+ comments(up 5%). Our forum too had busy year with 1000s of new members and 5,000+ new threads. podcast continued to shine, we had 24 episodes this year and reached the 50 episode milestone. Our podcast episodes has been downloaded more than 900,000 so far since launch (in March 2014) with 600,000+ downloads this year alone!!!

Fun fact: People have spent 6.8 million minutes in 2015 listening to podcast. (assuming only 50% of downloads materialized to listens)

We have trained more than 1,800 people thru my online classes – Excel School, VBA Classes & 50 ways to analyze data program.

8.5 million people visited our site in 2015 (up 8%) and consumed a whopping 21 million web pages. Each visitor spent an average of 2:01minutes on our site becoming awesome in Excel. There are 1.95 million who spent an average of 15 minutes or more on our site.

We have added another 20,000 more users to newsletter / RSS follower community. At the end of 2015, has more than 120,000 registered members (excluding forum members) and 3,500 active students (and 7,000+ alumni out in trenches making awesome reports, workbooks and impressing their bosses).

Leave a comment

Posted by on January 1, 2016 in Excel


Big thank you to all my friends ☺☺☺☺☺

The stats helper monkeys prepared a 2015 annual report for this blog.

Here’s an excerpt:

A New York City subway train holds 1,200 people. This blog was viewed about 4,000 times in 2015. If it were a NYC subway train, it would take about 3 trips to carry that many people.

Click here to see the complete report.


Excel Tools and Utilities

Leave a comment

Posted by on December 2, 2015 in Excel

%d bloggers like this: