Is it true that Macro can be used to automate almost any task you perform in Excel?

Yes it is. Macros are used to automate tasks. If you know how to create them, you can do many different kinds to do a wide range of tasks.