->

Advanced Excel Techniques Part 2 ... An Introduction to Macros and VBA Programming

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

 

Advanced Excel Techniques Part 2 ... An Introduction to Macros and VBA Programming


 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.


 Solid   |  

Information
Members of Guests cannot leave comments.




rss