LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Skillshare – VBA Beginner To Ninja Beginner Series

Leave a Comment

Skillshare – VBA Beginner To Ninja Beginner Series-ViGOROUS
English | Size: 583.68 MB
Category: Tutorial

VBA Beginner To Ninja teaches you how to become a proficient Visual Basic for Applications ninja programmer. The course is split into three series, beginner, intermediate and advanced. The beginner series focusses on the VBA fundamentals, providing you with the knowledge to be able to begin programming your own VBA macros. As you progress, the Intermediate and Advanced series courses, focus more on specific functionality that you will encounter in the real-world, providing you with all of the tools you will need to be able to tackle even the most complex tasks. [Read more…]

Packt – Excel VBA Programming the Complete Guide

Leave a Comment

Packt – Excel VBA Programming the Complete Guide-JGTiSO
English | Size: 16.78 GB
Category: Tutorial


Learn
Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
Utilize objects in the Excel Object Model to emulate user actions in Excel
React dynamically to user events such as entering a cell value or opening a workbook
Get comfortable with the fundamentals of computer programming [Read more…]

Packt – VBA Intermediate Training

Leave a Comment

Packt – VBA Intermediate Training-JGTiSO
English | Size: 1.08 GB
Category: Tutorial


Learn
How to write and implement Excel events, to modify how Excel reacts to different user actions.
Discover how to modify a variety of standard behaviors, such as double-clicking, opening files and saving files through VBA.
Learn how to design and implement specialized classes of objects.
Discover how to customize the right-click menu within cell ranges.
Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
Learn about where VBA falls within the Excel file structure, and how different Excel file types use VBA differently.
How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code
Learn custom classes, including introducing you to blank custom classes, and how to use user form classes. [Read more…]

Packt – Essential VBA Training for Excel

Leave a Comment

Packt – Essential VBA Training for Excel-JGTiSO
English | Size: 739.74 MB
Category: Tutorial


Learn
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code.
How to use intellitext with variables, particularly those that are defined constants.
What functions are, how they are used, and how to stage a scenario to complete.
How functions return values.
How to define inputs for functions.
How to use input boxes and message boxes to interact with the user.
The intricacies surrounding creating an array formula.
How to use the application object to control the user experience.
How to use errors to improve your code.
How to use the name and names object to manage named ranges.
General information about the PivotTable object and basic approaches to utilizing it. [Read more…]

Master Microsoft Excel Macros and Excel VBA

Leave a Comment

Master Microsoft Excel Macros and Excel VBA
English | Size: 1.14 GB
Category: CBTs


Master Microsoft Excel Macros and Excel VBA
Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros

What you’ll learn
Learn how to automate daily routine tasks within Excel
Learn best practices when creating macros and streamline your VBA code
Determine when it’s best to use the Macro Recorder versus VBA
Learn how to write custom VBA Macros to create more robust automation
Learn VBA programming concepts to create dynamic, re-usable code
Complete real world Macro/VBA projects from beginning to end
Requirements
In order to complete the projects detailed in this course, you will need Microsoft Excel loaded on you computer. Any version of Excel will work.
Videos have been recorded using Excel 2013, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.
[Read more…]

Udemy – Excel VBA The Beginner’s Blueprint to Programming Excel VBA

Leave a Comment

Udemy – Excel VBA The Beginner’s Blueprint to Programming Excel VBA
English | Size: 1.00 GB
Category: Tutorial


What Will I Learn?

UNDERSTAND why you would want to use VBA in Excel
KNOW the difference between Macros and VBA
CREATE Macros in Excel
MODIFY your Macros
NAVIGATE comfortably in the Visual Basic Editor
LEARN the essentials of writing Excel VBA code [Read more…]

Excel VBA in Depth

Leave a Comment

Up and Running with VBA in Excel
English | Size: 185.07 MB
Category: Video Training


In Excel: VBA in Depth, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.
[Read more…]

Excel VBA

Leave a Comment

Excel VBA
English | Size: 1.25 GB
Category: Tutorial


1 – Getting started with Range object, running and debugging
2 – Using the Cells object with and without range object, named ranges
3 – Using For and Next with variable, using loops for custom reporting
4 – IF THEN statements within the FOR NEXT loop
[Read more…]