Home >> SAP BPC >> Learn VBA for MS Excel – Video Course Review

Learn VBA for MS Excel – Video Course Review

Learn VBA for Excel
From a little less than a year, I had plans to learn VBA basics for Excel. As an SAP BPC Consultant I am not expected to be a master of it, but there is no doubt it is a useful programming language in a variety of cases.

As a rule of a thumb, SAP BPC Consultants should avoid extensive usage of VBA, especially for sophisticated calculations. However there are circumstances where you will need to automate tasks such as changing chart source data, chart title, copying excel formulas to dynamic input forms, etc.

Initially, I was a bit scared of VBA Learning as it was one of the most disliked languages, especially from hardcore programmers. However, in the current project in which I am involved, there were few cases where VBA was highly demanded.

In this situation, there are two approaches. Either you can try spending few hours looking for a quick fix, stealing and modifying a code from the web or you can learn the basics and do it on your own. I decided to go for the second option as it was much more rewarding at the end.

The commitment of time was a little bit higher, but it was worth it. After passing the first 4 hours of the video course below, I was able to finish my tasks in almost 20 minutes.

I was amazed at how enjoyable the learning of VBA was. Besides that, because it is happening in Excel, you can quickly see the results of your coding efforts. And one of the best things is that it improves your programming thinking, enriching you with skills you can use in other languages as well.

In Summary, you will learn about How to:

  • work with static and dynamic ranges
  • work with cells
  • declare variables
  • assign properties to charts, fonts, etc
  • use VBA Menus
  • use loops to perform repetitive tasks
  • take advantage of Excel Events triggering your code
  • and much more

 

 

 

 

The Ultimate Excel Programmer Course

About Emiliyan Tanev

Hello, My name is Emiliyan Tanev. I am SAP BPC Certified Application Associate with a good process understanding of FICO. I am also an experienced accountant and financial controller with 5+ years of diversified responsibilities. I am also a member of Management Accounting Body in the UK - CIMA and CGMA in the US. I love IT and Finance which impacted my career orientation towards SAP FICO and BPC. Follow me and get the latest tips, tricks, tutorials and career guides related to SAP BPC. More about me on My Story.

Check Also

Energy Efficient SAP HANA Server Build for Home

SAP HANA Home Server PC Build (Energy Efficient)

In my last post, I wrote about my intentions to build another PC Build which …

Leave a Reply

Your email address will not be published. Required fields are marked *