Chat with us, powered by LiveChat
  • LOGIN
  • No products in the cart.

Excel VBA Data Management

Excel VBA Data Management

8 STUDENTS ENROLLED

Introduction

Welcome to Excel VBA Data Management course!

The familiarisation with every aspect of Excel is a must in today’s business world. Whether you are a newbie with Excel VBA (Visual Basic for Applications) or have a very little knowledge of VBA, or you made an attempt, and it didn’t work, then you are in luck.

Course description

This course will teach you how to complete your tasks much more professionally and automate everyday tasks within Excel and assist you by providing resolutions for various points. Besides, gain a firm understanding of the applications for creating macros and streamline your VBA code.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

How is the course assessed?

This course does not involve any assessment.

While I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Excel VBA Data Management is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Curriculum

Excel VBA Data Management
Create a Macro Using the Macro Recorder 01:00:00
Edit a Macro 01:00:00
Debug a Macro 00:30:00
Customize the Quick Access Toolbar and Hotkeys 00:30:00
Set Macro Security 01:00:00
Insert Text 00:30:00
Format Text 00:30:00
Sort Data 00:30:00
Duplicate Data 01:00:00
Generate a Report 01:00:00
Determine the Dialog Box Type 00:15:00
Capture User Input 01:00:00
Insert, Copy, and Delete Worksheets 00:30:00
Rename Worksheets 00:30:00
Modify the Order of Worksheets 00:15:00
Print Worksheets 00:30:00
Create User-Defined Functions 00:30:00
Automate SUM Functions 00:30:00
Activities and Exercise Files – Microsoft Excel 2016 and VBA 00:00:00
Excel Templates
Excel Templates 00:00:00

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

COPYRIGHT © 2018 One Education