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.
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.
The Analysis ToolPak allows you to perform complex statistical analysis on your data including: correlation, regression, random sampling, moving averages, creating rank and percentiles and histograms.
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.
UserForms in Excel 2007 and Excel 2010 allow you to add fully configurable dialogue boxes or User Interfaces to your spreadsheets. They are easy to use, reduce typing errors, save time and look great.
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 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 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.
What are the points in favor of using facial recognition with time and attendance software? What problems can facial recognition software have?