Advanced Excel Techniques Part 2 ... An Introduction to Macros and VBA Programming
Video: .MP4, 1280x720 | Audio: AAC, 44kHz, 2ch | Duration: 3h 54m
Genre: eLearning | Language: English | Size: 739 MB
You may or may not know of the importance of Excel and the dependency businesses have on its use every single day. There is a HUGE need for advanced Excel users in the marketplace. I hope to transform you from being an ordinary user into your company's leading Excel expert and eventually master the ability to automate tasks with macros and the use of VBA programming . My hope is to provide you with a very straightforward course which will allow you to use some of the most advanced Excel techniques. VBA is a very useful skill to have and is used in almost all organizations. Knowing VBA can help you work considerably faster. Think of VBA as an extension of Excel skills. If improving your Excel abilities would be beneficial, then you should absolutely consider learning VBA. Course Topics: Macros vs VBA Using the Excel Macro Recorder Creating User Defined Functions The EXCEL Object Model Using Variables ... The Object Variable Using Variables ... String Variables Practical Application ... The Party Planner Creating and Using Worksheet Controls Practical Application ... Parts Ordering and Inventory Control The Party Planner Revisited ... Incorporating Selection and Repetition Practical Application ... Blinds Store Creating Menu Driven Workbooks Creating Custom User Forms Practical Application ... Parts Ordering Revisisted Practical Application ... Family Budget Tracker HOMEPAGE https://www.skillshare.com/classes/Advanced-Excel-Techniques-Part-2-...-An-Introduction-to-Macros-and-VBA-Programming/11271182
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.