You can automate MS Excel for a nearly unlimited range of functions. These are only a few of the tasks that can be automated: To clean and parse data; To send out mass mails; Tracking tasks; To update other workbooks and worksheets; To create pdfs; To create simple reports; To create dynamic dashboards ; Selective formatting; Data entry.