Macro's

Hi Jonathan

Thanks for getting in touch. There is a very wide array of things that you can do in Excel with macros, far greater than say Word.

Because Excel revolves around data, there are often repetitive analysis, formatting or calculations that need to happen. Macros can step in to help with this. If you need to download a file, delete certain columns, format another column, add another column with a new calculation, and then perhaps filter off certain rows on to their own sheet, this is a perfect scenario for a macro.

It's difficult to list all the possibilities for macros as it is so vast, instead perhaps browse forums for inspiration, such as our own:

https://www.stl-training.co.uk/thread-18-excel-vba-support-forum.html

Or another popular forum is the MrExcel one:

http://www.mrexcel.com/forum/excel-questions/

I hope that gives you some ideas.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector