Microsoft Excel allows us to create Custom Excel Functions or User Defined Functions using VBA. We can create Custom Excel Functions with the functionality we want and they can be accessed in the ...

Have you ever run into the pesky problem where any text-based data (that you add as a secondary column) in a pivot table incorrectly display as values instead of text? This is because pivot tables in ...

This is an interactive periodic table with chemistry-themed calculators built using Microsoft Excel, VBA, and macros. I created this as a final project for my Introduction to Engineering Computation ...