What is ETL Excel?
In most organizations, data goes through an ETL (extract, transform and load) process before it is available for reporting. But in some organizations, business users do some of this ETL work right in Excel, often referred to as data shaping and transformation.
Can you code in Excel?
Excel has a built-in tool for writing macros called the Visual Basic Editor—or VBA Editor for short. To open that, open a spreadsheet and use the shortcut Alt + F11 (for Mac: Fn + Shift + F11 ). The new window that pops up is called the VBA Editor. You'll then see the blank space to write your code on the right.
What are the Menus in MS Excel?
Excel Menus and Shortcuts