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 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.
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.
Ms Word is a good and easy to use word processor. Around the world, it is used by many people to edit and produce typed documents. Get introduced to text editing and formating document using Ms Word.
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.
How to guide on using the LEFT, RIGHT and MID functions to extract text from cells in Excel 2007. Examples of extracting first names, surnames and middle initials were provided. Use of the CONCATENATE function to join...
Guide to creating and configuring combo boxes in Excel 2007. This step by step guide covers how to create and configure combo boxes both individually and in greater numbers easily and quickly.
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.
I recently setup the Oracle database 11g on my server at home, and went through a lot of troubleshooting to solve the many different errors I came across thought I would make this hub to help fellow database newbies...
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.