• LOGIN
  • No products in the cart.

[course_title] continues Velsoft’s in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA.

So, if you are interested to develop your skills and knowledge, you shouldn’t be late to join this course.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Edukite

 

Course Curriculum

Developing Macros
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
Formatting Worksheets Using Macros
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
Creating an Interactive Worksheet
Determine the Dialog Box Type 00:15:00
Capture User Input 01:00:00
Working with Multiple Worksheets
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
Performing Calculations
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
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.7

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

No Reviews found for this course.

5 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841