A data table is a range that displays the results of changing certain values in one or more formulas. The different values you want to enter in a formula are also included in the data table. A data table can have either a single variable or two variables.
This autofill feature allows you enter a series of numbers or characters in a specified range, and have Excel complete the entry you started typing. You can have Excel automatically prefill cells with months, days of the week, quarters, dates, number sequencing and a custom list you create.
Ask us how we can service your company's training requirements.