Microsoft Office - Excel: Dynamic Arrays

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

Description

Once you learn the basics of this new functionality, you will never work in Excel the same way again! Dynamic Array functions resolve many of the issues we often face in Excel, and they make it easier to do tasks that have traditionally been difficult, even for veteran Excel users. In this fast-paced course you will learn the characteristics of these new functions and learn how to use each of the seven new functions. You’ll also learn best practices, and how to avoid a few pitfalls as well.

Objectives

  • Define dynamic array functions
  • List the characteristics of dynamic arrays
  • Use the seven new dynamic array functions
  • List the benefits of using dynamic arrays
  • Recognize potential issues and errors
  • Identify best practices
  • Use nesting functionality with dynamic array functions

Certificate

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

Learning Credits

CEU
0.5

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.
Microsoft Office - Excel: Dynamic Arrays
{{ vm.helper.t('courses.scorm') }}
2.
Microsoft Office - Excel: Dynamic Arrays Survey
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty