Udemy – Unlock Excel VBA and Excel Macros 2020-2

Description

Unlock Excel VBA and Excel Macros is a training course from Udemy site that teaches you the language of VBA and macros in Microsoft Excel software to help you do the most complex tasks automatically and save your time. VBA is a programming language in Excel software that allows you to automate various tasks with the help of simple commands.

This course will transform you from a novice user to a VBA expert in Excel software. You will get acquainted with the necessary commands step by step and learn how to use the appropriate syntaxes in different situations. The instructor explains how to record macros for simple tasks and helps you better implement VBA code. Working with the Visual Basic Editor, using troubleshooting methods, loop methods, working with data types, using PivotTables, and data mining are other topics in this course.

Items that are taught in this course

Automate tasks in Excel with VBA

Complete macro tutorial

Build simple solutions to complex problems

Use VBA instead of formulas

Easy editing of VBA codes

Unlock Excel VBA and Excel Macros course specifications

English language

Duration: 22 hours and 30 minutes

Number of courses: 172

Level of education: Intermediate

Instructor: Leila Gharani

File format: mp4

Prerequisite

Familiarity with Microsoft Excel.

Demonstration is done with Excel 2016 but the techniques work with any version of Excel.

Excel on Windows (some techniques might work on mac, but I will not be able to support you).

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

Changes:

Version 2020/2 has no significant changes compared to 2019/2.