For what little it may be worth, if by "tasks" you mean the menu items in the program then you are always limited by what the program developers provide as "tasks". It is not unlikely that real world solutions will not be completely available in the provided items and so you there is a point that you will need to understand how to extend solutions by code.
As an example of the limitations of menu driven solutions I worked with one program to develop report tables. My customers almost always wanted something that was just not available when working through the menus. So I used the menu to generate the basic code for the desired table and then add to that to get the desired appearance. What I learned in that software package was that 1) not all of the options available in the code were available in the menu, 2) the menu could develop things not documented for the code and 3) the documentation for the code had many things not even addressed in the menus.
... View more