- Duration: Upto 2 Days
Course details
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
Updated on 09 June, 2019
Eligibility / Requirements
All Excel users that would like to transform their models into something magical
Job roles this course is suitable for:
Digital Marketing Manager , Project Manager , Business Leader - Marketing , Information Security Manager , IT Consultants , Manager - IT Infrastructure , Marketing ExecutiveCourse Location
About my Learning Key
We are Industry Professionals providing Certified Training Courses. Based in Dubai , our training courses are designed as per Industry standards and delivered by highly qualified instructors.
We provide bespoke training in disciplines such as Big Data, Cloud Computing, Project Management, IT Service Management and Life Skills workshops.
Our vast community of instructors with years of experience help professionals to equip themselves with real world examples in this ever-changing business world.
myLearningKey an affiliate accredited by EXIN, Axelon, ITpenures, DASA, Cloud Credential council (CCC), Peoplecert.
Under License - Dubai Economic Department (DED) Knowledge and Human Development Authority (KHDA)
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Certification Levels 1-3 Courses Distance Learning Ltd.AED 184
AED 367Duration: Upto 40 Hours - Excel VBA/Macros Foundations Diploma StudyHubAED 89
AED 1,763Duration: Upto 9 Hours
