The Box and Whisker Chart shows the distribution of data into quartiles. Learn how to create a Box and Whisker Chart in Excel properly.

Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code.

How to Convert True-False to Check Boxes in Excel. Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create ...

Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how to create a dynamic search box that filters data based on your input ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

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

The collection includes nearly 100 lectures and more than eight hours of training to help a complete spreadsheet novice get comfortable and innovate in the Excel environment.