Learning these skills can also set you up nicely to learn using Visual analytics tools like tableau and powerBI. I also would recommend PowerQuery to the extent of unifying using powerquery to connect to a sql database, however that is not something easy to practice and you are better off learning SQL or python. I would even daresay that knowing how to use excel well and its limitations sets yourself up well to use SQL.Įxcel: for a career just get used to using pivot tables and lookups to the maximum effect. What Will I Learn Automate tasks and procedures in Excel using Visual Basic for Applications (VBA) Utilize the objects in the Excel Object Model to emulate. SQL is liking an object based programming language where spreadsheets are the objects. At some level, this differs much from languages like VBA and Python. This then becomes an exercise of manipulating relational databases. There are many online courses that offer exercises giving you a database and a way to figure out how to solve it. SQL: for a career you often only need to be able to query very well. Much of this knowledge will help you figure out VBA. Python: you can learn many of the core ideas of object based programming. By learning to write VBA code you can unlock the true power of Excel and be able to do things which you earlier didn’t think were possible. VBA works by running macros, which are step-by-step procedures written in Visual Basic.
Let me talk about the items you wish to learn here. Visual Basic for Applications or VBA is used to control and extend the functionalities of Microsoft Excel. Learning to google specific items is a very very useful skill. The tried and true advice is to find a project that interests you and build from there.
0 kommentar(er)
