Printing from Excel may seem challenging at first, but with the right knowledge, you can easily print your sheets or workbooks with precision.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Image: 200dgr/Shutterstock Applying multiple criteria against different columns to filter the data set in Microsoft Excel sounds difficult but it really isn’t as hard as it sounds.

You can set the print area of an Excel spreadsheet using the Print Area button to print only a selected area of a spreadsheet.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.