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.

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.