- Popular Topics
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.
Correlation is a relationship between two variables. Using the Correlation Tool in the Analysis ToolPak in Excel 2007 / Excel 2010 we can statistically test for a positive, negative or no correlation.
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.
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.
Microsoft's Excel has many terms and terminologies; some which are intuitive, some which are not. Here are 10 of the basic ones with full explanations.