In this course, you will learn
1) learn how to work with arrays and import/export arrays from/to Excel using VBA code;
2) learn how to work with text strings and write data to .txt files and import information from .txt files;
3) automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet as well as the import of information from multiple workbooks to a central workbook; and
4) gain experience with creating professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet.