Excel MVP Blog Roundup

Published Sep 04 2020 09:43 AM 1,769 Views
Microsoft

This week, we bring you recent articles by Excel MVPs Mourad Louha, Ismael Romero, and Frederic Le Guen.

 

Datentypen aus Power BI in Excel abrufen (Get data types from Power BI in Excel)

Excel MVP Mourad Louha describes his first experience with Power BI datatypes in Excel and how easy it is to get custom datatypes into Excel – starting with an introduction to the geography datatype and then the steps to create custom datatype from an existing Power BI dataset.

 

Power Query: Repetir y numerar filas como n de N (Power Query: Repeat and number rows as n of N)

Excel MVP Ismael Romero describes using Power Query to obtain an enumerated list in 'n of N' form for each original record.

 

Le secret du raccourci Ctrl + D (The Secret of Ctrl-D)

Excel MVP Frederic Le Guen reveals the secret of Ctrl-D when working with graphics objects in Excel.

 

Find this useful or want to know more about a specific Excel topic? Leave a comment below.

%3CLINGO-SUB%20id%3D%22lingo-sub-1623872%22%20slang%3D%22en-US%22%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623872%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20week%2C%20we%20bring%20you%20recent%20articles%20by%20Excel%20MVPs%20Mourad%20Louha%2C%20Ismael%20Romero%2C%20and%20Frederic%20Le%20Guen.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.excel-ticker.de%2Fdatentypen-aus-power-bi-in-excel-abrufen%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSTRONG%3EDatentypen%20aus%20Power%20BI%20in%20Excel%20abrufen%3C%2FSTRONG%3E%3C%2FA%3E%3CSTRONG%3E%20(Get%20data%20types%20from%20Power%20BI%20in%20Excel)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EExcel%20MVP%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%20noreferrer%22%3EMourad%20Louha%3C%2FA%3E%20describes%20his%20first%20experience%20with%20Power%20BI%20datatypes%20in%20Excel%20and%20how%20easy%20it%20is%20to%20get%20custom%20datatypes%20into%20Excel%20%E2%80%93%20starting%20with%20an%20introduction%20to%20the%20geography%20datatype%20and%20then%20the%20steps%20to%20create%20custom%20datatype%20from%20an%20existing%20Power%20BI%20dataset.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelforo.blogspot.com%2F2020%2F07%2Fpower-query-repetir-numerar-filas-n-de-N.html'%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSTRONG%3EPower%20Query%3A%20Repetir%20y%20numerar%20filas%20como%20n%20de%20N%3C%2FSTRONG%3E%3C%2FA%3E%3CSTRONG%3E%20(Power%20Query%3A%20Repeat%20and%20number%20rows%20as%20n%20of%20N)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EExcel%20MVP%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%20noreferrer%22%3EIsmael%20Romero%3C%2FA%3E%20describes%20using%20Power%20Query%20to%20obtain%20an%20enumerated%20list%20in%20'n%20of%20N'%20form%20for%20each%20original%20record.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-exercice.com%2Fle-secret-du-raccourci-ctrl-d%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ELe%20secret%20du%20raccourci%20Ctrl%20%2B%20D%3C%2FA%3E%20(The%20Secret%20of%20Ctrl-D)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EExcel%20MVP%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4030588%3FfullName%3DFrederic%2520Le%2520Guen%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFrederic%20Le%20Guen%3C%2FA%3E%20reveals%20the%20%3CEM%3Esecret%3C%2FEM%3E%20of%20Ctrl-D%20when%20working%20with%20graphics%20objects%20in%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFind%20this%20useful%20or%20want%20to%20know%20more%20about%20a%20specific%20Excel%20topic%3F%20Leave%20a%20comment%20below.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1623872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%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%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%3ECheck%20out%20these%20blog%20articles%20by%20our%20Excel%20MVPs%20Mourad%20Louha%2C%20Ismael%20Romero%2C%20and%20Frederic%20Le%20Guen%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1623872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Sep 08 2020 07:49 AM
Updated by: