- Popular Topics
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 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.
UserForms in Excel 2007 and Excel 2010 allow you to add fully configurable dialogue boxes or User Interfaces to your spreadsheets. They are easy to use, reduce typing errors, save time and look great.
The Analysis ToolPak allows you to perform complex statistical analysis on your data including: correlation, regression, random sampling, moving averages, creating rank and percentiles and histograms.
Pivot Tables within Microsoft Excel help you summarize large amounts of data quickly and efficiently. They are very easy to use and format and can be refreshed very quickly if the data changes.