Description

Reviewof the Windows version:”This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in depth knowledge” — Daniel SandbergWelcome to Excel VBA – An Introduction for the Mac. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MSOffice products).Microsoft Excel is an extremely powerful tool and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features yet most people dont even know its there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school or in other words, Visual Basic for Applications (VBA).In this course, Ill assume that you have some fair knowledge of Excel able to do basic formulas and colour cells and the like but you dont need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. Ill take things nice and slowly. Each video will center around one new aspect, or well consolidate what you already know with coding exercises.Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems.And youll be able to take your new-found knowledge for use in Word and PowerPoint as well