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.
Guide to Visual Basic or Visual Basic for Applications (VB or VBA) code in Excel 2007 and 2010, learning the basic commands, how to work with errors and how to run the code that you have written.
How to mail merge images and photos in Microsoft Word using the IncludePicture field. Detailed step-by-step instructions. Includes a discussion of IncludePicture limitations and workarounds.
Visual Basic code allows you to configure a User Interface using a UserForm in Excel 2007 or Excel 2010. Scripts initialise the User Interface, configure the buttons and add data into the worksheet.
Forms created in Excel 2007 and Excel 2010 using ActiveX List Boxes allow you to enter data into Excel quickly, easily and with a minimum of errors. A Command Button is also used to complete the form.
Using List Boxes in Excel 2007 and Excel 2010 you can create visually appealing and very easy to use boxes containing lists of items from which users can select one or multiple items.
Guide for creating to do lists in Excel 2007 / Excel 2010 using Check boxes and Combo boxes. Use Conditional Formatting using formulas and cell values with icon sets to add visual impact to your list.
The SUMIF function in Excel is a great way to quickly summarize data without having to create a pivot table. Follow these simple step-by-step instructions and you will be a pro at it in no time.
Thematic maps show themes or variations across geographical regions. Data is linked to the chart in Excel 2007 or Excel 2010 using Visual Basic code which updates each part of the map automatically.