Power Query For Beginners
Welcome back to Day 6 of 30 Day Excel Analyst – transforming your analytical skillset in 30 days.
Power Query is one of the most powerful features Excel offers the modern analyst. It’s an absolute must if you’re engaged in data management tasks in Excel. Well, this week is data management week, so let’s explore the potential of Power Query in Excel. I’m not a Power Query expert so, even if you’re a beginner, you should be able to engage with this session – I fully expect to learn a few things myself …
💻DOWNLOAD THE RESOURCES
https://tinyurl.com/2tb2sbst
🔥30 DAY EXCEL ANALYST PLAYLIST
https://tinyurl.com/4439xtnb
🔥FIRST VIDEO IN THE COURSE
https://youtube.com/live/CF-Y46c829Q?...
Yesterday, we saw how Power Query can be used to import data to Excel from an external data source. We pulled data from a Google sheet (which houses responses to the online form we created,) but you could pull data from a multitude of data sources: a sheet in the same Excel file, another Excel file, some kind of online database. The possibilities are endless. And yes, multiple queries can be set up simultaneously, which means you can ‘merge’ datasets together using Power Query. Cool!
That’s for another day. For now, let’s look through around 8 things beginners can accomplish in Power Query to dramatically simplify your data management work in Excel.
This session should include, but probably won’t be limited to:
Re-ordering columns
Changing row order
Splitting column entries with a ‘delimiter’
Adding custom calculation columns
Grouping rows
Cleaning and trimming text
Adding an index column (with a suffix or prefix)
Adding date and time columns
Did you enjoy getting started with Power Query? Let me know how you got on in the comments below ...
FOLLOW UP RESOURCES
🔥30 DAY EXCEL ANALYST PLAYLIST
https://tinyurl.com/4439xtnb
🔥CAN'T DO DATA ANALYSIS IN EXCEL? JUST DO THIS!
• Can’t Do Data Analysis In Excel? Just...
🔥EXCEL VBA BEGINNER BUILDING BLOCKS
• How To Write Your First Excel VBA Mac...
🔥MAKE EXCEL BEAUTIFUL: 14 EXCEL FORMATTING TIPS
• 14 Excel Formatting Tips (Make Excel ...
🔥PIVOT TABLES FOR BEGINNERS
• Your First Pivot Table
🔥THE 72 THINGS YOU NEED TO KNOW IN EXCEL
• The 72 Things You Need To Know In Exc...
🔥STOP FILTERING EXCEL
• Don't Use Excel Filters! Use This Inc...
🔥LEARN EXCEL VBA WITH THIS 5-HOUR WALKTHROUGH PROJECT
• Learn Excel VBA From Beginner Level W...
🔥10 EXCEL FORMULA BUILDING TIPS
• 10 Excel Formula Building Tips (Windo...
Смотрите видео Power Query For Beginners онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tiger Spreadsheet Solutions 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,543 раз и оно понравилось 41 людям.