Microsoft Office - Excel: VBA 365

Content
2 modules
Difficulty
Intermediate
Rating
Course Length
305 mins
Instructor
Pantry of Knowledge

Description

This course will teach students proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. This course has an assessment which may be required for a certificate to be generated.

This course aligns with the CAP Body of Knowledge and should be approved for 5 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Objectives

  • Get started with VBA
  • Work with variables
  • Work with strings and string functions
  • Work with loops
  • Work with sub procedures options and functions
  • Work with user forms
  • Debug your code

Certificate

By completing/passing this course, you will attain the certificate POK Microsoft Skills Certificate

Learning Credits

CEU
5.25

Badges

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value') }}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}

{{ vm.percentage_badges[vm.selected_badge].greater_than_or_equal }}%

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value')}}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved') }}

{{ vm.helper.t('lup.gamification.learning_awards.on_course_completion') }}
1.
Software - Camtasia: Creating Videos: Beginner
{{ vm.helper.t('courses.scorm') }}
2.
Microsoft Office - Excel: VBA 365
{{ vm.helper.t('courses.survey') }}
 
Added 8 months ago, by April

Shopping Cart

Your cart is empty