- Popular Topics
How to use the COUNTIF and COUNTIFS functions in Excel 2007 and Excel 2010 to count text in a cell range. Remove Duplicates allows you to create lists of unique items from a larger data source.
A Speedometer, Dial or Gauge chart in your Excel 2007 / 2010 spreadsheet will look impressive, especially in a dashboard. It uses a Doughnut chart and Visual Basic code to create a moving needle.
The Moving Average Tool from Excel 2007 and Excel 2010's Analysis ToolPak allows you to calculate a trend in data using a moving average which is defined by an interval (or number of values averaged).
Bubble charts created in Excel 2007 or Excel 2010 allow you to show data in three dimensions in a visually stunning chart. This can then be saved as a template to be used to create additional charts.
How to use, create and configure Form Controls / ActiveX Controls Option / Radio Buttons in Excel 2007 / Excel 2010
Option or Radio buttons in Excel 2007 / Excel 2010 allow you to create visually appealing and user friendly panels with selectable items in a list. Users can then select a single item from each panel.