0

Excel Power Query Crash Course

4.5
10 Reviews
65 Enrolled
38 minutes
Free

About 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

Requirements

  • Must have Microsoft Excel 2010, 2013, 2016, or Ofc 365

Course Content

Excel Power Query Crash Course

  • Introduction to Excel Power Query
    02:16
  • Get Data and Screen Overview
    03:20
  • How to Change the Data Source
    04:13
  • How to Fix Mistakes
    02:54
  • Intro to Conditional Columns
    04:04
  • Edit Query Settings
    03:11
  • Close-and-Load to Save
    02:12
  • 10 Conditions in 1 Step
    03:41
  • Format Numbers and Dates
    03:44
  • Conditional Col from 3 columns
    03:02
  • Advanced Editor
    03:29
  • Final Overview and Review
    01:48

Instructors

A

admin

4.5
10 Reviews
6151 Students
19 Courses

Feedback

4.5
Total 10 Ratings
70%
10%
20%
0%
0%

Reviews (10)

  1. MG

    MUSKAN GUPTA

    1 month ago
    good
  2. AR

    Asheera Rizwan

    4 months ago
    helpful
  3. AT

    Areeba Tahir

    5 months ago
    excellent
  4. JD

    Jayanta Das

    5 months ago
    This course helps me a lot to understand many things and thanks to tutor and the providing organisation
  5. AI

    Areej Imran

    5 months ago
    good
  6. IK

    Ishmeet Kaur

    8 months ago
    nice
  7. NS

    Nitin Singh

    12 months ago
    good couse if you want to gain overview
  8. RG

    Rakshitha G

    1 year ago
    It was really good supported me in building me career
  9. CK
    Excellent
  10. SS
    Good Teaching Skills

Want to receive push notifications for all major on-site activities?