Skip to main content


Showing posts with the label Backup

Robocopy backup using Task Scheduler

Backup is a simple word that has a very good significant value in today’s digital world.

Unattended backup or automated backup is a good strategy, so the user or the whoever is managing the backup won't need to manually trigger the backup.
No data backup is a head-on strategy, that leads to catastrophe.
Backup is very, very important in today’s digital world. You will never know when a data disaster will strike.
The whole laptop will be lost, the hard drive will fail without any sign, a virus might corrupt the whole system or just simple mistake to overwrite or delete a data. All this scenario requires a backup rescue to recover the data.
Robocopy is a built-in command in Windows that does a pretty awesome job to backup or copy files.
Using Windows task scheduler, robocopy and Vbscript will create an important task to backup data.
How the three tools will be used, to backup data?
Robocopy – to backup or copy the files Vbscript – to hide the robocopy in the background while Roboc…

Excel 2010 date difference

How to use datedif function in Excel?
How to find date difference between two dates in Excel?
How to find date difference by month, year or days in Excel?
Excel has a built-in function and does the heavy lifting to date difference between two dates.
Excel uses the “datedif” function to easily compute the date difference  by days, months or years.
Notice the Datedif function has a single “f” at the end it’s not DateDiff. If you accidentally type double “f” at the end of the function excel will return an error and will just display “#NAME?” which basically means that the function is not recognized by Excel.
Here’s the function:
=DATEDIF(A1,C1,"d")  ==== > this function find the date difference by days for the values of A1 and C1

=DATEDIF(A3,C3,"m")  ==== > this function find the date difference by months for the values of A3 and C3

=DATEDIF(A5,C5,"y")  ==== > this function find the date difference by years for the values of A5 and C5
Excel screen sho…

How to create a system image in Windows 7

Creating a system image is the most neglected step when a user buys a computer.
But it’s quite important, so when the system slows down and formatting the hard drive is one of the best options.
System image will come into the picture.
How to launch or use Windows 7 to create a system image?
Press the Windows key, and on the search box type “backup”.
On the search result, click on “Backup and Restore” (check image below)

Control Panel will open, on upper left corner of the window.
Click “Create System Image”. (check image below)

System Image window will open and will prompt where to save the image.
Windows will automatically check the available options on the system; if an external drive is connected to the computer it will be included on the option.
Or you can opt to select DVD if you want the image to be on DVDs. (check image below)

Upon selecting where to save the backup click the “next” button.
I had selected the external hard disk. If the DVD is selected, the capacity of your da…