%3CLINGO-SUB%20id%3D%22lingo-sub-1784721%22%20slang%3D%22en-US%22%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThis%20week's%20blog%20roundup%20brought%20to%20you%20by%20Excel%20MVPs%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5003732%3FfullName%3DAjay%2520%2520Anand%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAjay%20Anand%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4030532%3FfullName%3DMourad%2520Louha%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMourad%20Louha%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000742%3FfullName%3DIsmael%2520Romero%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIsmael%20Romero%3C%2FA%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ajay.jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226981i9076E63BFC137062%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22ajay.jpg%22%20alt%3D%22Ajay%20Anand%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EAjay%20Anand%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mourad.jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226982iE6CD904E8F8ADA3E%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22mourad.jpg%22%20alt%3D%22Mourad%20Louha%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EMourad%20Louha%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ismael%20(2).jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227041iB867E63EDDF39BA9%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22ismael%20(2).jpg%22%20alt%3D%22Ismael%20Romero%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EIsmael%20Romero%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fxlncad.com%2Fhow-to-connect-excel-tables%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20Connect%20Excel%20Tables%3C%2FA%3E%3C%2FSTRONG%3E%2C%20Ajay%20Anand%3C%2FP%3E%0A%3CP%3EAjay%20shows%20how%20to%20build%20relationships%20between%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Foverview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c%23%3A~%3Atext%3DTo%2520quickly%2520create%2520a%2520table%2520in%2520Excel%252C%2520do%2Cto%2520be%2520the%2520header%2520row%252C%2520and%2520...%2520%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etables%3C%2FA%3E%20using%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b%23%3A~%3Atext%3D%2520Create%2520a%2520Data%2520Model%2520in%2520Excel%2520%2Ccan%2520contain%2520only%2520one%2520Data%2520Model%252C...%2520More%2520%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EData%20Model%3C%2FA%3E%20in%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22http%3A%2F%2Fwww.excel-ticker.de%2Fzwei-bereiche-per-formel-zusammenfuehren%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EZwei%20Bereiche%20per%20Formel%20zusammenf%C3%BChren%3C%2FA%3E%26nbsp%3B(Merge%20two%20areas%20using%20formula)%3C%2FSTRONG%3E%2C%20Mourad%20Louha%3C%2FP%3E%0A%3CP%3EMourad%20describes%20how%20you%20can%20dynamically%20append%20two%20ranges%20by%20using%20a%20single%20formula%20and%20dynamic%20arrays%2C%20building%20the%26nbsp%3Bformula%20step%20by%20step%20and%20using%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flet-function-34842dd8-b92b-4d3f-b325-b8b8f9908999%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELET%3C%2FA%3E%20function%20make%20it%20more%20readable%20and%20more%20performant.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fexcelforo.blogspot.com%2F2020%2F10%2Fpower-query-combinaciones-sin-repeticion.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPower%20Query%3A%20Combinaciones%20sin%20repetici%C3%B3n%3C%2FA%3E%20(Power%20Query%3A%20Combinations%20without%20repetition)%3C%2FSTRONG%3E%2C%20Ismael%20Romero%3C%2FP%3E%0A%3CP%3EIsmael%20deep%20dives%20in%20creating%20a%20list%20of%20combinations%20without%20repetition%20using%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fintroduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPower%20Query%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerquery-m%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EM%20language%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EClick%20the%20Like%20button%20and%2For%20leave%20a%20comment%20below%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1784721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSC17_collaboration_009_noBG.png%22%20style%3D%22width%3A%20821px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215690iF4223357BE7EBB69%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSC17_collaboration_009_noBG.png%22%20alt%3D%22MSC17_collaboration_009_noBG.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ECheck%20out%20the%20latest%20from%20Excel%20MVPs%20Ajay%20Anand%2C%20Mourad%20Louha%2C%20and%20Ismael%20Romero%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1784721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

This week's blog roundup brought to you by Excel MVPs Ajay Anand, Mourad Louha, and Ismael Romero.

 

Ajay AnandAjay AnandMourad LouhaMourad LouhaIsmael RomeroIsmael Romero

 

How to Connect Excel Tables, Ajay Anand

Ajay shows how to build relationships between tables using Data Model in Excel.

 

Zwei Bereiche per Formel zusammenführen (Merge two areas using formula), Mourad Louha

Mourad describes how you can dynamically append two ranges by using a single formula and dynamic arrays, building the formula step by step and using the LET function make it more readable and more performant.

 

Power Query: Combinaciones sin repetición (Power Query: Combinations without repetition), Ismael Romero

Ismael deep dives in creating a list of combinations without repetition using Power Query and M language.

 

 

Click the Like button and/or leave a comment below