This course intended for Excel users who want to learn the best way to automate their tasks. Other Microsoft Office applications, as well as Excel, come with a powerful scripting language referred to as VBA. With a little bit of programming knowledge, complicated tasks can be completely automated and finished in seconds. This course assumes no programming experience; only a realistic level of familiarity with Excel.
Microsoft Excel : This courses uses Excel 2007 for the demonstrations, and comes with .xlsm files for the code examples. These demos and files will not be incompatible with later versions of Excel as well. If you're using Excel 2003, you will not manage to open the .xlsm files, but you'll be able to follow along with the demos.
The course begins with an introduction to macros. You'll find out how to inspect the VBA code that gets created from this process, and how to record a series of activities, the way to run the recorded macro.
You'll then find out the best way to make use of numbers in VBA. There are different kinds of numbers that are utilized in various scenario, so you will be a given an overview of the differences between them.
You'll then be presented to strings. Strings are utilized to symbolizes words and characters in programming. For instance, "hello world" may be saved in your VBA code as a string. You could then perform various operations on your string, like converting it to upper case, replacing a word, counting the number of characters, and others.
Then you'll look at booleans, if-statements and loops. These concepts will enable you to create complex behaviours that wouldn't have been possible by simply recording a macro. You'll able to write code that makes conclusions and implements legitimate rules.
This course is the lite version of "Become an Excel VBA Expert for Beginners"
Hope you join with me.
EDUmobile Academy develops high quality video training courses around topics in mobile development including iPhone, Android, Windows Phone, Java, Responsive Web Design and other emerging technologies.
Every course is created by an expert developer AND a trained mentor in the area of expertise.
Each course undergoes a rigorous planning, review and an internal quality check phase - to ensure that the teaching is of highest standards available online.
EDUmobile Academy was founded in 2008 when smart phones were just emerging into the market. Founder Vishal Lamba is experienced in multiple areas of digital design, mobile development and design, web technologies and digital marketing. He has a mathematics and computer science degree from Lawrence University, USA.
Vishal works closely with content creators and teachers to ensure that every course released meets the internal rigorous quality standards.
All course creators and trainers are currently based in the USA. Support for each course on Udemy is provided with quick turn around by a small team of developers and trainers.