Tips If you use AutoFill to populate a date series but want to use the date formatting from another cell, use "Fill Series" to complete your data.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.