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.
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 guide on housekeeping your mailbox in Outlook 2007. The tutorial includes determining the mailbox size and identifying firstly the biggest folders and secondly the biggest emails which should be the focus of...
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.
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.
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.
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.
The file is corrupt and cannot be opened is a false error message, and may be easily resolved by unblocking the file. By Easy Bins Dumpster Rentals of Northern VA.
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.
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.