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

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

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

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

A check box may be integral to an Excel form, but you should still be able to edit it. However, if you've inherited a form from a co-worker or another source, removing a form field or even moving it ...

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

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting ...