- Popular Topics
- All Computer Software Topics
Using the IF and IFERROR functions as well as the logical functions AND, OR and NOT in Excel 2007 and Excel 2010
The IF function returns one value if a condition is true and another if false. The AND, OR and NOT functions allow for comparison against multiple conditions. Use IFERROR to suppress known errors.
DISPLAYBARCODE and MERGEBARCODE: How to Insert or Mail Merge Barcodes (Bar Codes) Word 2013, Microsoft Word 365
How to generate barcodes in Word 2013 using the hidden DISPLAYBARCODE Word feature. This works with Mail Merge, and data for the barcodes can come from your Mail Merge Datasource.
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 create and use Sparklines in Excel 2010 to summarise and add context to your data and to also show trends
Sparklines are a new chart in Excel 2010 and can be simply and quickly placed in just one cell. They can be placed directly next to the data to add context to that data and show trends and variations.
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.