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 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 ...

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

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.

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.