Introduction to Power Query

Name: Introduction to Power Query
Brand: Microsoft Office
Price: 500 MYR
Availability: InStock

RM 500.00

Choose Date

Are you drowning in messy data? Do you spend hours manually cleaning spreadsheets, copy-pasting between files, or reformatting data before you can even begin analysis? Does the thought of combining multiple reports from different sources make you break into a cold sweat?

You're not alone. The average data professional spends 80% of their time preparing data and only 20% actually analyzing it. That's four days of every workweek wasted on tedious, repetitive tasks rather than delivering valuable insights.

Our comprehensive Introduction to Power Query course is the solution you've been searching for.

Training Duration: 1 Day

Certificate Of Completion Available
Group Private Class
VILT Class Available
SBL-Khas Claimable

Download Course Outline

This course provides a comprehensive introduction to Power Query, a data transformation and preparation tool in Microsoft Excel and Power BI. It covers essential concepts such as data extraction, transformation, and consolidation, helping participants efficiently clean and shape data for analysis. Through hands-on exercises, case studies, and speed challenges, learners will gain practical skills to enhance their data-handling capabilities.
Business analysts

Data analysts

Finance professionals

Excel users who work with large datasets

Professionals who need to clean, transform, and analyze data efficiently

Anyone looking to automate repetitive data-preparation tasks
Module 1: Basics of Power Query

What is Power Query?

Why should we learn Power Query?

Where is Power Query?

The Power Query Editor – Basic anatomy

Basics of data types & operators

Coding best practices

Caveats

Tips

Module 2: The Power Query Editor Interface

Getting familiar with PQ interface

Transforming data

The applied steps

Formatting data

Basics of data types & operators

M rudiments

Module 3: Getting Data

Getting data from Excel file

Getting data from Text File/CSV (Comma Split Values)

Getting data from Folder

Getting data from PDF (single page PDF)

Module 4: Data Transformation

Transforming Data

Split/Merge Columns

Formatting Data

Extract Data

Replace Value

Fill Up/Down

The Applied Steps

Module 5: Consolidating Data

Append Query

Merge Query

Module 6: Case Study

Case Study 1: Financial Analysis

Case Study 2: Acquisition Due Diligence

Speed Challenge: Raisin dataset (multi-page PDF)

Case Study 3: Basics of Time Series Analysis

Speed Challenge: Filling Up/Down

Case Study 4: Product Dimension

Case Study 5: Sorting custom orders in dataset

Frequently Asked Questions

What is Generative AI for Content Creation?

Generative AI for Content Creation refers to using AI tools to generate or enhance content such as images, videos, voiceovers, music, narration, and other creative assets from prompts and reference materials.

How can Generative AI help with content creation?

Generative AI can accelerate ideation and production by helping users create images, video concepts, voiceovers, music, and other content assets. It can also automate repetitive production workflows and generate multiple content variations.

Can beginners learn AI content creation without technical skills?

Yes. The course is designed for content creators, marketing teams, designers, social media managers, and business professionals, with practical exercises focused on prompting, creative production, and workflow automation rather than traditional programming.

Can Generative AI create videos and voiceovers?

Yes. The course covers prompt-to-video, image-to-video, AI voiceover, narration, music, sound design, voice cloning, and multilingual dubbing. Participants also learn about the current limitations of AI-generated video and audio.

What tools are used in this Generative AI content creation course?

The course introduces platforms and tools including Figma Weave, Krea, OpenArt, AI image and video models, and dedicated audio tools. Examples covered include ChatGPT Images, Nano Banana, Imagen, Veo, Seedance, Kling, ElevenLabs, and Minimax.

Is AI-generated content safe to use commercially?

AI-generated content may involve copyright, attribution, licensing, privacy, and confidentiality considerations. The course teaches participants how to identify these risks and apply responsible practices when creating content for commercial use.

Is this course HRDC Claimable?

Yes, the course can be offered as an HRDC claimable training programme, subject to applicable HRDC requirements, approval, and the employer's eligibility.

Can this Generative AI content creation course be customized?

Yes. The course can be customized around an organization's content requirements, brand guidelines, target audiences, preferred AI tools, and real-world content production workflows.

Introduction to Power Query

ABOUT THIS COURSE

AUDIENCE

COURSE MODULE

Frequently Asked Questions

Contact Us