212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on WordpressGoogle Places

Tag: udf

A Free Excel Add-in Function: Convert Shorthand Notation

Excel Add-in

A Free Excel Add-in Function: Convert Shorthand Notation Because A Smart Student Asked An Insightful Question In business reports, large numbers are often reported in numeric shorthand notation like $2.5B or USD25M. While we can use the format cells dialog to create a custom number format, the majority of data we may import from other …

Continue reading

Excel User Defined Function (UDF) Calls A Macro To Change A Value In Another Cell

Excel User Defined Function (UDF) Calls A Macro To Change A Value In Another Cell According to Excel’s ‘rules’ a UDF should not be allowed to change values in other cells. If you are like me, you might hate it when someone says “It can’t be done”. I tend to follow a contrarian viewpoint, and …

Continue reading