Robotic Process Automation Using Excel Macros

We use Excel almost everyday.  However, we do a lot of mundane, repetitive, non-value-added tasks such as copy-and-pasting of data from one Excel spreadsheet to another, looking up of data from another spreadsheets, formatting of spreadsheet into a specific format and consolidation of data from multiple Excel spreadsheets into one master spreadsheet, etc.  Many of these tasks can actually be automated using Excel Macro.  Besides Excel VBA, Excel actually has two other macro tools: Power Query and Power Pivot. Power Query comes with the Microsoft Excel that all of us are using. It’s one of the least known yet powerful, and probably the “best kept secrets” from Microsoft. It is especially powerful in cleaning, transforming and consolidating data from multiple spreadsheets. Many research have shown most of us spent more than 70% of our time cleaning up the data before we can perform any analysis. All the 3 Excel macros – Excel VBA, Power Query and Power Pivot – will be covered in class.