Excel has two primary types of charts that graph data sets onto an axis: line charts and scatter charts. Depending on your settings, the two types of charts can look identical, but using the wrong one ...

A cumulative average recalculates a data set's average as new data is added. During the recalculation all data contained in the data set is included in the average. In Microsoft Excel your spreadsheet ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

When you paste in existing data from a comma-delineated text or an Excel file, Zoho creates the data structure for you and guesses the field types. After the fact, I could easily set a field in one ...