Excel VBA -Learn Visual Basic macros (Beginner to Advanced)

Published 6/2023
Created by Rami Abou Jaoude
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 175 Lectures ( 19h 42m ) | Size: 14 GB

Become a Guru in Microsoft Excel macros (VBA) to automate your tasks, reports, dashboards and analysis with Visual Basic

What you’ll learn
Automate your tasks in Excel and focus your time on more productive activities
Wow your stakeholders, e.g., Dynamic Charts and AI analyzing your report
Make your team work fast and better with efficient VBA tools
As you can’t memorize everything, learn how to search, modify and use the right piece of code
Loose the fear of using VBA

Requirements
Be comfortable using the normal Excel sheets. You don’t need to be a formula Guru but you need to have the basic knowledge of Excel. How to use basic formulas, how to write in cells, copy paste formulas, etc…

Description
Why learn Microsoft Excel Visual Basic (VBA): Today, Ms Excel is becoming the tool of choice in companies (in the USA alone, more than 500,000 companies actively use Excel) to be able to perform analysis and present data in a Quick way. A lot of the work won’t require complicated models and can be set up in an automated way. Work Smarter not Harder: With the advance of technology and information, jobs are becoming more and more challenging. In addition, data and analysis are becoming more and more accessible with time. The difference in productivity between a NOOB in Excel and an advanced User is more than 10X. Imagine automating your task and using your time for more productive activities!Why this course: Excel has the power to access anything you can do on the computer. You will be surprised how much you can automated & save time!Learn how to automate reports. While you are home asleep, you computer can download data, analyze it, create a report and send it out!Coding could be daunting at first. With this course, you will see that it’s easy if you go step by stepThis course teaches you how to understand coding and memorize the minimum – This will enable you to find code, modify it and use it Unlike many courses, this course teaches you how to use code in real life – You will see examples you can relate to such as copy pasting, dashboards, creating customized letter, etc…Course is designed for all levels: Whether you want to learn from scratch or deepen your understand in VBA, you are at the right place!  4. Curriculum – Practical Hands on Excel Visual Basic (VBA):Dealing with Files & FoldersInteracting with Applications such as PDF, PPT and WordCreating your own formulas & Functions (Like what you have in Excel)Manipulating Excel Tables and Pivot TablesActiveX and Form controlsUserformsTriggering macros based on eventsComparaison though looping in CollectionsConditional & Logical operators (Even partial match)Loops (For, do, while etc…)Referencing cells & copy pastingVariables & how to use excel formulas in VBAHow to use the macro recorderMsgbox with inputs from userError Handling & DebuggingManipulating text and datesArrays  5. What you will learn:What you need to know to complete most assignmentsBest practices in coding such as identing, commenting, using variables, reusing codeBuilding automated Reports, Analysis & Dashboards (including how to get the raw data automaticallyHow to search for a code you don’t know – Using the macro recorder, internet and more…How to build faster codesUseful ShortcutsHow to deal with ErrorsFunctionalities of The Visual Basic EditorHow to create applications with cool userforms and graphs/pics in the formHow to simulate typing on the keyboardHow to run your macro while you are not thereAnd many more!  6. About me:Harvard MBAExtensive consulting experience with McKinsey & Co, having learned the ability to dissect problems and perform complex analysis in no time11+ years as a Vice President in a bank heading analytical and strategy teamsBuilt the whole analytics department of a 3500+ employee share services subsidiaryDegree in Computational Sciences among othersWell versed in Data and Artificial intelligence, having built chatbotsPassion for teaching Excel as a backbone to increasing productivity

Who this course is for
Beginners with no prior knowledge of VBA: You will learn step by step
Intermediate VBA users: You will be able to sharper your skill and take away a wealth of codes to use to in your projects

Password/解压密码www.tbtos.com

转载请注明：0daytown » Excel VBA -Learn Visual Basic macros (Beginner to Advanced)