This video is a free intermediate Excel tutorial that will teach you how to make really long and time consuming lists in Excel in just seconds using the Fill and Series functions!
Creating lists is part of everyday life in Excel. Whether you’re preparing a report for your boss, planning a wedding, analyzing the results of your Fantasy Sports League, or trying to nail that internship, you’ll probably need to make some lists in Excel. The trick is making your lists quickly and efficiently. You don’t want to manually punch in every number in the list ( that is far too time consuming and there is too much room for human error), and unlike my beginner tutorial on creating a numbered list in excel where dragging was the fastest way to make your list, dragging your list down is not the quickest way to make an Excel list if you’ve got to make an extremely long list.
This video shows you how to make a list of 5 numbers and a list 500,000 number in the same amount of time. [click to continue…]