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.
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.
Apart from typing a document, it is vital to know how to format, make it easy to use and presentable. This article explores how you can make use of the Microsoft Office Word 2007 Page Layout Ribbon Tab.
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.
An article about the different ways you can use and display fractions in Microsoft Word.
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.
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.
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.
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.
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.