See how can you Automate routine tasks in Power Query in 2021 Part 4 | TRANSFORM DATA
-See how can you Automate routine tasks in Power Query in 2021 Part 4 | TRANSFORM DATA This video explains how to transform data in Power Query. It covers how to Unpivot columns. Power Query is very useful for data analysis and with automation saves a lot of time spend in routine tasks.
This is fourth video in the series of videos about Power Query. In this series you will get to know Power Query in detail
Here is the link to the practice file. You can download and use for your practice.
https://docs.google.com/spreadsheets/...
Power Query Part1 | Import data from web
• See how can you Automate routine tasks in ...
Power Query Part2 | Import data from folder
• See how can you Automate routine tasks in ...
Power Query Part3 | Transform Data
• See how can you Automate routine tasks in ...
Visit & Subscribe channel:
https://www.youtube.com/c/TechReflect...
This video lecture is part of the videos on Excel and it tools.
Welcome to Tech Reflections (#techreflections) & I am Vikram.
Leave a comment on this video and let me know what all you want us to cover in coming videos of this series.
Playlists on this channel:
Pivot Tables & its features
• Pivot Tables & its features
Excel - Conditional Formatting?
• Excel - Conditional Formatting
How to create Gantt Chart?
• How to create Gantt Chart?
How FILTER function works?
• How FILTER function works?
How Lookup Functions work?
• How Lookup Functions work?
How to use INDEX & MATCH function?
• How to use INDEX & MATCH function?
Google Sheets Tools Formulae (Compared with Excel)
• Google Sheets Tools & Formulae (Compared w...
Excel Tools & Formulae
• Excel Tools & Formulae
Excel Keyboard Shortcuts
• Excel Keyboard Shortcuts
Excel - Formulae & Functions
• Excel - Formulae & Functions
Excel - Tools & Applications
• Excel - Tools & Functions Applications
Powerpoint Hacks
• Powerpoint Hacks
#techreflections #powerquery #etltool