Online Safety Community

Excel - Automation - VBA & Macros 101

Event Details

Excel - Automation - VBA & Macros 101

Time: March 23, 2018 from 1pm to 2:30pm
Location: 26468 E Walker Dr, Aurora, Colorado 80016-6104
Street: 26468 E Walker Dr, Aurora, Colorado 80016-6104
City/Town: Aurora
Website or Map: https://goo.gl/tNwRPx
Phone: +1-888-300-8494
Event Type: online, webinar
Organized By: Training Doyens
Latest Activity: Feb 26

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - and if that sounds like a macro - well it is. 

Although Excel has a macro recorder, there's a limit to what it can do. So where the macro recorder's functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications.

WHY SHOULD YOU ATTEND

VBA is one of the must have skills for Excel Power Users. VBA will save you, your colleagues, and your customers hours of time by allowing you to automate any Excel-based task or process. If you've never used VBA before and you'd like to learn about the basics of VBA and automation, this webinar is for you.

AREAS COVERED

Session highlights include…

  • Getting familiar with the VBA Editor
  • Understanding VBA jargon such as procedures, modules, methods and properties
  • How to edit an existing macro
  • How to write a simple macro from scratch using VBA
  • Creating inline documentation
  • Using VBA to control what happens a file is opened or closed

LEARNING OBJECTIVES

This webinar is aimed at advanced users of Excel, with little or no programming experience, who wish to "dip their toe into the VBA water"

WHO WILL BENEFIT

This webinar gets you started with VBA. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder. This training is relevant to all industries. It is not industry specific.

Although the training will be delivered using Excel 2016 for Windows, it is just as relevant to users of earlier versions of Excel (2013, 2010 and 2007)

 

For more detail please click on this below link:

https://goo.gl/sce65E

 

Email: support@trainingdoyens.com

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

Comment Wall

Comment

RSVP for Excel - Automation - VBA & Macros 101 to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

Adam Fleaming posted a blog post

Having a [baby] is exorbitant and befuddling, notwithstanding for a wellbeing approach master

It is hard to believe that it has been just over since five months since our second son, Lukas, was born on Feb. 3. His mother, Hollyanne, is doing well, which is something to be thankful for, given the excessive maternal mortality rates in the U.S. Lukas is also healthy and growing, albeit sleeping little at night. What is unbelievable…See More
18 hours ago
Tytti posted a blog post

Safety Sign Colors and International Standards

Colors make a difference to our environment. They help us analyze the surroundings and distinguish between objects. We recognize plants as green and the sky as blue, whereas a frog, for example, can be either green or blue. Deviant colors, in this case blue, warns us about poisonousness. If we detect unusual colors in our food, for example, we associate them with rottenness, which then activates a warning in our mind “Don’t eat!” Colors cause diverse feelings and opinions, and even distinct…See More
19 hours ago
Mark Nilson posted events
yesterday
Aileen Scott posted a blog post

Certifications- And Why to Get Them

Education has been diversifying according to the overall needs of different types of candidates, and the ideals of the industry. Educators have been working tirelessly to let higher education programs and their material be more easily accessible thereby more attractive to international audiences. Hence, professional courses and distance programs are developed to cater to those with different needs from education that differ widely from the needs of traditional students. Certifications are one…See More
yesterday

Forum

5 TECHNOLOGY-BASED LONE WORKER SAFETY SOLUTIONS

ABOUT 75% OF EMPLOYEES IN NORTH AMERICA ARE MOBILE WORKERS. ADVANCES IN COMMUNICATIONS TECHNOLOGY MEANS THESE WORKERS CAN WORK ANYWHERE AT ANY TIME. THESE NEW TECHNOLOGIES ALSO MEAN THESE MOBILE…Continue

Tags: Solutions, People, IoT, Monitoring, Remote

Started by Jen McDade May 31.

Road Safety Solutions 14 Replies

The Road Safety Signs ,Barriers,Humps,Hazard Markers and Visual Warnings are some of the important marks to be observed. Signs such as "keep left",stop, "give way" should not be casually treated.…Continue

Tags: safety, gear, wear, Equipment, &

Started by Enna Henry. Last reply by Jen McDade May 31.

Remote Monitoring

Get "Safe Assets and Sound Productivity" Through Remote Monitoring.Visit:…Continue

Tags: Solutions, People, IoT, Monitoring, Remote

Started by Jen McDade May 23.

Python Condition Objects Tutorial in 2018 1 Reply

If you have knowledge of other programming languages, then you would know the importance of conditional statements. Conditional statements are required for taking decisions. Whenever we operate the…Continue

Tags: course, certification, training, languages, programming

Started by Elena Lauren. Last reply by Jim Chesters May 15.

Power BI Visualization Types

Visualizations in Power BI displays the visual insights from a data. In power bi service a visual can be pinned from reports to create dashboards. Visuals are used in reports.List of visualizations…Continue

Tags: COURSE, TRAINING, BI, POWER

Started by Azharuddin May 15.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service