Hello and welcome to a new video
In this video we are going to learn
How to take backup of excel file
So to take backup of excel file
What all steps we have to follow
We will learn all those steps
But the most important thing is
Why to take backup of any file
To take backup of any file
You have to remember
Suppose you are working on
Any important file
What happens in this
Suppose there is a power cut
Or your UPS is not working
And you forget to
Save your file
Then what will you do
In that case your data
Will be lost
So it is better to
Generate a file which
Provide backup
I will give you a very good example
Google Whenever you click on a photo
It automatically saves
Why it automatically saves
Because you have taken its backup
You have connected it
With your gmail id
In the same way
We have this file
We have some data
We want to get
Backup of this data
So we will do the same thing
How to take
Backup of this file
We don't have to take it manually
Manually means
That we are
Saving it again and again
We are creating backup
So we don't have to do this
What we have to do
Our file will automatically
Take backup
So we have to follow some steps
This is my data
I have to go to file
Here you will get options
You have to go to this options
You have become familiar
We have come here many times
What we came here to do
We came here to customize
We went to advanced options
What we saw
We can customize the list
But now we have to come to this option
We have to come to save option
We clicked on save option
Here you will see
Auto recover information every
Now what is this
To take backup
Here you have 10 minutes 10 minutes 10 minutes means
After every 10 minutes
Your backup file will be created
In that backup file
Your data will be saved
Suppose you are saving data in any file
And after every 10 minutes
It will be updated in the backup file
Backup file will be created
And data will be updated
We don't want it to be done in 10 minutes
We want it to be done in 1 minute
So we will save time
We will do it in 1 minute
If it is unchecked
We will check it
It should be saved
After that see here
Here will be the file location
Which will be by default
You can also change it
How can we change
What you have to do
I will tell you a shortcut
Window plus E
We come to our computer
This PC
Where we can see C, D, E
I will show you
If you click window plus E
You will see this
You have to go to this PC
Here you can see C drive, D drive
In your computer it can be E drive, F drive
It has different names
So what we have to do
We have to come inside this
Suppose I go inside D drive
And here
I make a folder of excel file
Ok I will create a folder
Here I go to new
I create a folder
Here I name this folder as Excel
And here I click on excel
So this is my path
How can I copy this path
To copy this path
I have to click here
And then do ctrl plus C
To copy ctrl plus C
Shortcut is done
From here where I have to go
I have to go to my excel
And from here
I have to remove this path
And do ctrl plus V
So now what will happen
The path where I want my file backup
This is that path
I by default
I do this path
I remove it from here
I do ctrl plus V
I paste it again
This is my path
Now what I have to do
Ok Now I save this file
Save as
Browse I don't want to save excel file here
Because I created a new folder
So I want to save this file
In this folder
What I did in this folder
Backup File.xlsx I did this
And here before saving
You have to remember one thing
You have to go to general option
In general option
Remember in last video
When we put password on our file
We have to go here again
Here you will see always create backup
You will see
Here it will be unchecked
You have to check it
You have to check it once
After checking once
What will happen
Your file backup
Will be ready once
Update will be done after every one minute
Whenever you will work in it
Ok From here
Save Now what we have to do
We have to go there and see
After one minute
Did I create another backup file
Or not
After one minute
Let's see
Here is backup file.xlsx
Let's increase it
Ok I selected this file
Ok Now what we have to do
We have to create another backup file
Of this file
And in that file
I have to see the same data
Which I can see here
So what will happen
Automatically my data
Is generated
A backup file is created
So after one minute
I hope it will be ready
Till then
Let's go back to backup file
You can do many things in it
As you can see January, February, March
As we have seen earlier
In the list
We have dragged it like this
You can drag it here also
As you can see January, February, March, April, June
Here is the plus sign
So you can drag it here also
Can you see
What happened
If September, October, November, December
Has come
You can drag it in row also
Or you can drag it in column also
I think
One minute is over