Excel Volume Calculator

The ‘Excel Volume Calculator’ is now available to buy as a direct download! :)




Microsoft Excel is a very versatile tool and can be used for many different purposes. The example we have here is a volume calculator for some simple geometric shapes. The user can enter values for the parameters (such as side length, or radius), and the corresponding volume is updated automatically.

However, rather than just display the parameters and calculated volume, it is often more user friendly to format the spreadsheet area with diagrams, and the odd splash of colour here and there!

Also, this example does not make use of any macros, but could be easily extended to do so. The volume equation for each shape is entered directly into worksheet cells but could be stored in macro code instead in the form of a custom worksheet function. This function could then be called as necessary, just like a standard worksheet function.

This entry was posted in Excel, Graphics and tagged , , , , , . Bookmark the permalink.

18 Responses to Excel Volume Calculator

  1. sajith says:

    pls sent me the excel sheet.
    thanks…

    sajith

  2. mike says:

    Can you send me the Excel sheet for shape volume?

    Thanks.

  3. alok kumar says:

    plz. send me the excel sheets.

  4. ghulammustafa says:

    plz. send me the excel sheets.

  5. derek says:

    I would really appreciate a copy of the sheet.

  6. TMONEY says:

    PLZ send me the excel sheet I

  7. TMONEY says:

    Plz send me this excel sheet I really could use this

  8. Peter Moonen says:

    Good Morning, please send the excel sheet,
    Thank you

    Peter Moonen

  9. Siggi says:

    Is there a possubility of dl that sheet?

  10. Albu Ioan says:

    plz. send me the excel sheets.

  11. hardik says:

    I am interested in your sheet and want to try it out. Pls send me ur sheet.
    Nice job

  12. Randy Allen says:

    Could you please send me the spreadsheet?

  13. rania says:

    Could you please send me the spreadsheet?

  14. Bill Kelley says:

    What shapes does it do the volumes for?
    Is it only the 4 shapes shown in the picture?

  15. bk says:

    How many and what shapes does it have formulas for?

  16. bk says:

    Do you offer this any more? As fast as you respond to questions makes me question weather I should purchase it or not.
    Please respond, How many and what shapes does it have formulas for?

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>