drawing Courses

Filter by category

    Filter by



      We found 1 course available for you

      Automating Data Tasks in Excel using Power Query

      1 Lesson
      6.5 hours

      In the era of big data, the ability to efficiently …

      What you'll learn
      Understand the capabilities and benefits of Power Query for data transformation and analysis.
      Learn how to import data from various sources into Excel using Power Query.
      Gain proficiency in cleaning, transforming, and manipulating data using Power Query's features and functions.
      Develop advanced skills in data enrichment, augmentation, and error handling.
      Acquire the knowledge to create custom functions and parameterize queries to automate repetitive tasks.
      Learn how to set up automated data refreshes to ensure analyses remain up-to-date.
      Understand how to deploy Power Query solutions within Excel workbooks and share them with colleagues and stakeholders.
      Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
      • Image
      • SKU
      • Rating
      • Price
      • Stock
      • Availability
      • Add to cart
      • Description
      • Content
      • Weight
      • Dimensions
      • Additional information
      Click outside to hide the comparison bar