Excel VBA - Learn from real case studies and projects

LeeAndro · May 28, 2022

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 12.2 GB | Duration: 18h 55m

In this course I have reproduced the works to develop and test solutions in VBA for some of my works and of my students' projects.

Improve your knowledge in Excel VBA from real case studies of projects of my students and from my works
What you'll learn

Their knowledge in Excel VBA will improve

They will understand how to apply thier VBA knowledge to their projects

They will be able to create Applications with VBA in Excel

They will be able to import, export and format data into Excel tables

They will improve their knowledge in using VBA to generate Excel formulas and references

They will improve their knowledge in using VBA to apply conditional formatting

They will improve their knowledge in using VBA to exchange data using VBA dictionaries

They will improve their knowledge in using VBA to import/export data with OLE DB

They will improve their knowledge in using VBA to generate, access, format Excel tables

They will improve their knowledge in using VBA to generate, format and customize Excel charts

They will improve their knowledge in using VBA to add ActiveX objects to Excel sheets and assign macros

Requirements

Basic knowledge of Microsoft Excel

Basic knowledge of Excel VBA

Description

This is a collection of great works we did together in the last 3 years.

In details new students can learn how to use Excel VBA to:

import data from other workbooks using OLE DB

use VBA dictionaries to import/export data between worksheets, workbooks and tables

generate, format and customize Excel tables in VBA

generate and customize complex charts

generate dynamically created named ranges

assign Excel formulas to ranges

format borders and colors of ranges

create reusable, parametrized, common and generic routines

handle errors

define data validations

create complex conditional formatting formulas

At the end students will be able to create their own Application using Excel and VBA and generate automatic reports

Who this course is for:

Who already knows how to use Excel and create VBA macros

DOWNLOAD
uploadgig.com

rapidgator.net

ddownload.com

Search

Search

Excel VBA - Learn from real case studies and projects

LeeAndro

Trusted Editor