Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

How to create a helper function in Excel Once the data is in order, you’re ready to add the conditional format. This is one of the few situations in which a single rule can’t get the job done.

Creating custom templates in Excel allows you to save time and maintain consistency in your spreadsheets. Follow these steps to create your own templates: ...

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

How to Create a New Workbook in Excel. In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on ...

Format Painter applies the same formatting to multiple text or objects. Learn how to use Format Painter in Word, PowerPoint, and Excel.

How to create a new workbook You can create a new empty workbook where you add your own spreadsheets or simply begin with a built-in Excel template for a jump-start.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

How to Use Excel to Create Interactive Worksheets. As a small business owner, you will often have to work with others on an Excel worksheet. For example, if you have hired a sales or marketing ...