Software - Micro Learning - STOP using SUMIF in Excel

Content
2 modules
Difficulty
Basic
Rating
Course Length
15 mins
Instructor
Pantry of Knowledge

Description

In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a favourite for many, we're here to introduce you to a more powerful alternative – the SUMIFS (plural!) function. The SUMIFS function not only replicates the capabilities of SUMIF but takes it a step further by accommodating multiple criteria seamlessly. No longer bound by the limitations of SUMIF, SUMIFS empowers you to handle complex conditions. Join us as we showcase how SUMIFS can efficiently replace SUMIF in both single and multiple-criterion scenarios. Embrace the efficiency, simplicity, and versatility of SUMIFS to revolutionise the way you approach data analysis.

Objectives

KEY OBJECTIVES

  • Discover the SUMIFS function in Excel and how to proficiently conduct data analysis with both single and multiple criteria

Certificate

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

Learning Credits

CEU
0.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 - Micro Learning - STOP using SUMIF in Excel
{{ vm.helper.t('courses.scorm') }}
2.
Software - Micro Learning - STOP using SUMIF in Excel
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty