However, there are some other parameters that can be set at the same time. For other options, simply choose the Advanced tab. There are three core parameters that you need to be aware of. The first is the length of time you will store the history in your file. Microsoft Excel allows you to store over 32000 days worth of changes to your Excel file, however, there is a catch. All of that information is stored in your file and consequently your file will grow exponentially. Most organisations generally work on a maximum of 30 days and that is the default, however the value entered simply depends on your workbooks requirements. You can choose the second option which says, Don‘t Keep Change History. This simply ensures no changes are maintained.
Overall most people tend to learn better this way rather than trying to learn all Excel formulas at the same time as this can be very confusing. Most of us tend to learn in smaller packages of information and you should look for a course of instruction that will allow you to do this. As you are learning to use Excel you should of course start by learning to use the formulas that you are actually using or are likely to have need of in the immediate future.