Welcome to Excel Sparkle, an informal, online Microsoft Excel skills development programme. While you won't get CPD points for following these articles, you will probably be able to impress your colleagues and your boss with some of the skills that you may learn here.
The idea behind this series of articles is to share practical ways in which I use Microsoft Excel on a daily basis, with tips and tricks on making Excel easier to use and generating more professional looking documents. Some ideas presented here may be old news to you already, others may be completely new, but if even one person learns something new then I will consider this a personal victory.
The series will start with examples from my own experience, but I would like to encourage all members of this community to share their experiences with Microsoft Excel. An Excel Sparkle category has been created in the forums so that you can share your tips with others, or allow you to ask other community members how to do something in Excel.
This function is used to convert a numerical value into its equivalent textual representation, e.g. 123 becomes One Hundred and Twenty Three. Used in the format of =textamount(value[,"MajorCurrency"][,"MinorCurrency"]) where:
Over the years working as a Quantity Surveyor, I discovered that Microsoft Excel, while a wonderful tool, lacked certain functions. In order to overcome these shortcomings, I developed custom procedures and functions to enhance my Excel experience and productivity. Instead of keeping these tools to myself, I have decided to share them with anyone who is interested in trying them out. Your feedback on the addin will be appreciated and will assist in the further development of this product.