Why
Do you frequently repeat the same tasks in Excel? Copying and pasting. Formatting cells, row, or columns. Repeating a data analysis process.
All of these small tasks can easily add up over the day, and many can be automated and made to fit with a more natural work flow.
How
Simple data manipulation can be done using existing Excel functions and features.
Custom functions can be made for more specific tasks.
Custom processes can be made using VBA macros to automate nearly anything you do in Excel and beyond.