shape
shape

Excel Power Query Crash Course

Students29 Views424

Excel Power Query Crash Course

About The Course

This short course will give you the base-level introduction, and a few tips and tricks, that will embolden you to explore the new “Power Query” tool.  It was first launched in Excel in 2010 and has only gotten better and easier since then.  It’s purpose is for redundant data clean-up that will then be used in data analysis, charts, and pivot tables. Set up the clean-up steps once-and-for-all, then just refresh each time you need it.

What Will You Learn?

Excel Power Query is a fairly new tool useful for redundant data clean-up tasks

Course Curriculam

Excel Power Query Crash Course

  • Introduction to Excel Power Query
    02:16
  • Get Data and Screen Overview
    03:19
  • How to Change the Data Source
    04:12
  • How to Fix Mistakes
    02:54
  • Intro to Conditional Columns
    04:03
  • Edit Query Settings
    03:11
  • Close-and-Load to Save
    02:11
  • 10 Conditions in 1 Step
    03:40
  • Format Numbers and Dates
    03:43
  • Conditional Col from 3 columns
    03:01
  • Advanced Editor
    03:28
  • Final Overview and Review
    01:48
ed3ee01783e2473865c4f12d388e59b7?s=96&d=mm&r=g

admin

12 Courses 2810 Students
4.7
Total 3 Ratings
5
2 Ratings
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
  • RG

    Rakshitha G

    2 months ago
    It was really good supported me in building me career
  • CK

    Charushila Khot

    4 months ago
    Excellent
  • SS

    Shubham Shrivastava

    5 months ago
    Good Teaching Skills