Excel :: Excelbart

Login

Join Yurls!

Add to Yurls

QR code

Excel

Visitors:

(Advertisment)

Microsoft resources

Add to Yurls
Generate QR code
Copy box url

Microsoft Power Query official site of Microsoft (released june 2019) Y

Webinar Ken Puls Microsoft Excel: Best practices for spreadsheet modeling data shaping and data - BRK2035 - YouTube Y

Types of Joins

Add to Yurls
Generate QR code
Copy box url

Merge Tables in Power Query - YouTube Y

Say NO to Venn Diagrams When Explaining JOINs – Java, SQL and jOOQ. Y

SQL Joins using venn diagrams Y

SQL Joins Visualizer Y

Types of join/merge available in Power BI/ Excel - YouTube Y

Venn diagram - Wikipedia Y

Visualizing Merge Join Types in Power BI | SQLJason | Some Random Thoughts Y

Videos from Oz de Soleil

Add to Yurls
Generate QR code
Copy box url

Connect Power Query to a Dynamic Dropdown List - YouTube Y

Excel Power Query & Data Cleansing Part 1: Different Ways to Format Data Using Power Query - YouTube Y

Excel Power Query Tutorial: Unstack & Merge Data Using Power Query - YouTube Y

Power Query - consolidating 2 columns of data using Don't Aggregate - YouTube Y

Power Query: Split Column by Delimiter and Split into Rows - YouTube Y

PQ blogs

Add to Yurls
Generate QR code
Copy box url

#powerquery – How to handle different decimal separator when importing csv files – Erik Svensen – Blog about Power BI, Power Apps, Power Query Y

Direct Query with Power BI - Simple Talk Y

Mynda Treacy Blog : unpivot unstructured data (with files to download) Y

Power Query Tips: 10 Most Useful Commands | GoSkills Y

PQ to use VLOOKUP approximately match (so bonus structure) Y

VLOOKUP using Merge Queries - Computergaga Blog Y

(Advertisment)

(Advertisment)

Error chalanges

Add to Yurls
Generate QR code
Copy box url

Error Handling in Power Query | Learning Tree Blog Y

Error-handling in Power Query | Gerhard Brueckl's BI Blog Y

playlist

Add to Yurls
Generate QR code
Copy box url

Excel Power Query (Get & Transform) Video Playlist of Videos - YouTube - Mike Girvin Excel is Fun Y

Power Query - YouTube Playlist Geeky Veep Y