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.
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 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.
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.
How to Add a Check Box in a Microsoft Word Document. A useful guide to how to add a check box to a number of Word documents, including lists, questionnaires and surveys.
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.
Percentage formulas are used all of the time in Excel. It is important that you know how to write them.
Microsoft Word has become the standard word processor for business use, but with it's functionality and ease of use it is also a powerful tool for the home user.
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.