Microsoft Office - Excel: Power Query

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

Description

Save time cleaning up and managing your data with Excel’s popular power tool Have you spent a lot of time performing repetitive cleanup tasks on your data, using multiple VLOOKUP functions to merge data, or trying to combine multiple datasets? If so, then Excel’s Power Query tool will transform how you work. You’ll learn how to connect to multiple data sources, and set up queries to remove unneeded data, manipulate existing data, and even create new columns. And the best part is, once you’ve set up your query, you’ll just refresh it when you need to perform those tasks. Microsoft certified trainer Kathy Jones will show you how to use the Power Query Editor to perform all of these functions and streamline your workflow in the process.

Objectives

  • Describe the purpose of Power Query
  • Connect to data in Excel, databases, and other sources
  • Clean up and transform data
  • Add new columns
  • Sort, filter, and unpivot data
  • Manage applied steps
  • Manage multiple queries
  • Create append and merge queries

Certificate

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

Learning Credits

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

Shopping Cart

Your cart is empty