Numerical methods are used to solve mathematical problems that cannot be solved using analytical methods. These methods involve approximating solutions using numerical techniques, such as iterative methods, interpolation, and extrapolation. VBA (Visual Basic for Applications) is a programming language used in Microsoft Excel to automate tasks, create custom functions, and develop applications.