Skip to main content

Posts

Showing posts with the label Backup

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…