Did you know that you can code and run complex programs in Excel? VBA-Visual Basic for Applications enables you to do this through macros. It would give you an easy start if one has prior knowledge of a programming language like Java, C, C++, etc.
What is VBA?
VBA is an implementation of Microsoft’s programming language Visual Basic 6 and its associated integrated development environment (IDE), which are built into most Microsoft Office applications. This language enables you to build user defined functions and automate processes. To use VBA with an application such as Access, Word or Excel, terminology and language constructions are needed to interact with the application
Try it out in Excel !! : View tabs –> Macros –> View Macros/Record Macro…