There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

How to Change Columns Into Rows in Excel 2007. If you've ever entered a long list of business data and realized you need this information across a row instead of down a column, you can take ...

Have you ever found yourself endlessly dragging that little Excel fill handle, trying to populate rows or columns with numbers, dates, or formulas? It’s tedious, time-consuming, and let’s be ...