Microsoft Excel, a spreadsheet and data analysis program, is available as a stand-alone program or as a component of the Microsoft Office productivity suite. Excel 2007 included a number of new ...

Populate a userform combo box in Excel with a dynamic list Your email has been sent Populating a combo box isn't hard, but getting the combo box to communicate with a constantly changing list is a ...

Inserting and customizing the timeline chart . It's now time to insert a line chart, which you'll adapt into a timeline chart ...

How to take advantage of the Name box in Microsoft Excel Your email has been sent Scrolling around a large sheet can be tedious, awkward, and occasionally, even fruitless because you simply can’t find ...

Last week’s post, “A Histogram is NOT a Bar Chart ”, explained that bar charts were used for comparing categorical variables and that histograms were used to show the distributions of binned ...

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

This post describes how to autofit comment box in Excel. While adding a large comment in a cell in Microsoft Excel, you may have noticed that only a part of it is visible to you by default. You need ...

Visualization methods enhance our understanding of sample data and help us make comparisons across samples. Box plots are a simple but powerful graphing tool that can be used in place of histograms to ...