Programming Microsoft Office Excel

Programming Excel with VBA

If you’ve ever wanted to do a bit more or automate routine operations so that you don’t always have to perform boring, repetitious tasks manually, this part is for you. This lesson is also aimed at those Excel users who want to develop Excel-based applications for other users. Visual Basic for Applications (VBA) is the powerful programming language that you can use for these tasks, as well as for more esoteric purposes, such as developing that specialized worksheet function that you simply can’t find in Excel.

Working with Excel Add-Ins

Microsoft Excel has for long been such a valuable and ubiquitous tool in the world so much that most if not all software in the business world provide for Exporting and importing Data to and from Excel. With the introduction of Power Query, Power Pivot, Power-view and Power Map features as add-in to Excel 2010 and 2013, Excel’s powers were supercharged. The key benefit of using Excel Add-Ins is the ability to let you manipulate the imported data, analyze it, and draw conclusions without slowing down your computer.