Macro programming in Excel

Macro programming in Excel

Product Code: Office Productivity
  • 300.00€

  • Ex Tax: 300.00€
lessons

Don't waste your time with low quality videos and confusing explanations. This Excel course explains complex things in simple language . The content has been carefully thought out and clearly organized. The videos are of high quality and include animations on important points. And most importantly you will learn VBA in a practical way.

This course will give you:

An understanding of the proper use of VBA syntax

Useful Excel VBA codes that you can directly use in your work

Utilize the macro writer tool for easier tasks and better code

Working with the Visual Basic editor

Debugging tools and error handling techniques

Different methods of referencing ranges and cells

Different loop methods

How to work with data types

How to work with worksheet and workbook events

ActiveX and custom forms to enhance Excel's interface

Virtually all the knowledge you need to automate tasks in Excel

Who this course is for:
Business professionals who want to simplify and automate their work
Analytics Date
You already use Excel in your work and want to improve your skills

What you will learn
Improve your current Excel files and automate your work using VBA
Apply the included Excel VBA example files to your work
Simplify your work routine
Excel formulas and basic functions can't do everything. Take advantage of VBA when you've reached your limits
Master Excel VBA and macros
Reduce manual work to a single click of a button
Create simple solutions to complex problems by augmenting Excel functions with macros
Customize VBA code found on the Internet to fit your needs

Course content 11 sections - 152 lectures - Total duration 10 h 0 min

Introduction
Getting started
Range Properties
Cell Properties
Variables
Important tools
Loops and Reports Basics
Worksheet Events
Workbook Events
ActiveX controls
Control Forms

3 lectures - 4 min
11 lectures - 36 min
13 lectures - 42 min
6 lectures - 15 min
6 lectures - 20 min
17 lectures - 1 hour 3 min
27 lectures - 1 h 52 min
17 lectures - 57 min
13 lectures - 49 min
29 lectures - 2 h 17 min
10 lectures - 1 h 5 min

 

Write a review

Note: HTML is not translated!
    Bad           Good