dmw | consultancy
tel 01732 833085
tonbridge · kent · UK

Microsoft Excel Tips and Techniques

This page lists links to topics of technical interest relating to Microsoft Excel and Excel Visual Basic for Applications (VBA) programming.

Written by David Wallis, these topics have not been vetted by third parties, so please treat them critically. If you have any views or comments, please contact me.

Summing time values demonstrates a formatting technique that displays the result of adding, or summing, a column of time values.

Converting time values demonstrates a way of converting hh:mm times in decimalised hours.

Change data/time into military date/time presents a formula for converting a 'dd/mm/yyyy HH:MM' date and time value to the military equivalent 'ddHHMMZmmmmyy' one.

Suppressing the #DIV/0! error presents a simple formula for hiding the #DIV/0! message Excel displays when you divide a number by zero.

Showing a formula result in a chart legend puts forward one way of making a chart legend respond to a formula.

The last day of next month presents a formula for calulating this date without resort to VBA.

The totaling percentages problem looks at colums of percentages for which the totals do not add up.

Criteria for DSUM formulae explores one way of furnishing DSUM formulae with criteria determined by calculated date ranges.

Excel SUMPRODUCT function is a lot more versatile than its name suggests.

Rounding to the nearest 5 explains the use of ROUND and MROUND functions to round any number to the nearest five.

Macros and VBA Programming in Excel is an introduction to a structured approach to creating and extending macros.

Error Trapping and Handling in Excel Macros suggests some VBA code for processing errors tripped by macros during run time.

Error 1004 identifies one cause of the 1004 macro error message.

Random Cell Background (Fill) Colours Macro for filling a block of cells with a random range of colours.


DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any techniques, methods or code included in this website are applied. Back up your data; test thoroughly before using on live data.

“You might be an Excel nerd if: you assess the romantic potential in a person based on their ability to create a pivot table in under 60 seconds.”

Author unknown.