تفاصيل الدورة
Unit 1Recording & Running Macros
Creating Button to run the macros
Correct methods of recording macros
Unit 2
Overview of Excel VBA Editor
Adding & Deleting Modules
Sub & End Sub
Unit 3
Protecting your Macro Codes)
Working with Workbooks & Worksheets
Understanding Ranges coding
Declaring Variables
Unit 4
Using IF & Multiple IF in macro
Unit 5
Understanding Looping
Practically using looping in macro
Unit 6
Taking Backup of Modules
Debugging Code & Break Points
Commenting Codes
Unit 7
Creating Message Box for interaction
Using different types of Message boxes
Using IF Condition in Message Box
Unit 8 (Practical Projects)
Formatting regular reports
Auto Filtering & Separating Data
Consolidating Multiple Sheet into one
Consolidating Multiple files into one
تحديث بتاريخ 09 June, 2019
المتطلبات
All Excel users that would like to transform their models into something magical
وظائف مناسبة لهذه الدورة
Digital Marketing Manager , Project Manager , Business Leader - Marketing , Information Security Manager , IT Consultants , Manager - IT Infrastructure , Marketing Executive- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Excel VBA Tutorials with practical approach Yoda Learning110 درهم
176 درهممدة الدورة التدريبية: 8 Hours - Excel 2008 – Intermediate 1TRAINING78 درهم
563 درهممدة الدورة التدريبية: Upto 4 Hours