Master Microsoft Excel Macros and VBA with 5 Simple Projects
3.5 Hours | Video: h264, yuv420p, 1280x720 | Audio: aac, 44100 Hz, 2 ch | 747 MB
Genre: eLearning | Language: English
3.5 Hours | Video: h264, yuv420p, 1280x720 | Audio: aac, 44100 Hz, 2 ch | 747 MB
Genre: eLearning | Language: English
Each Excel Macro/VBA Project will build upon Key Concepts that will give you a solid VBA foundation and confidence
* Lectures 47
*******************************************************************************************************
NEW BONUS LECTURE HAS JUST BEEN ADDED - PROJECT #6
WORKING WITH EXCEL VBA FORMS - SECTION #8
*******************************************************************************************************
*Automate placing and formatting a title on a worksheet
*Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
*Cleaning up multiple Excel Worksheets and prepare the data to be reported on
*Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
*Automate the creation of Excel Formulas to SUM data up in your Report