One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. Here are a few data types you can drag to auto increment:
- day of week
To take advantage of this shortcut, just add your first value, then click-and-drag the bottom-right corner of the cell as far as you need values filled in. Alternatively, if you’re working with a table of data, you can double-click on the bottom-right corner, and Excel will fill values to the row of the previous columns.
Another alternative is to create your own lists that you can later use to auto increment, such as student names, list of products, sales regions, members of a group, etc.
You can learn more about data formatting in my Annielytics Dashboard Course, a video course that will teach you how to put your data in stilettos and work the pole.