SOLVED

Power Query et Power Pivot avec Excel en achat définitif

%3CLINGO-SUB%20id%3D%22lingo-sub-2150030%22%20slang%3D%22fr-FR%22%3EPower%20Query%20and%20Power%20Pivot%20with%20Excel%20in%20final%20purchase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150030%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20buy%20Excel%202019%20on%20Mac%20as%20a%20definitive%20purchase%2C%20without%20going%20through%20a%20Microsoft%20365%20subscription%2C%20for%20use%20in%20management%20control.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20this%20version%2C%20will%20I%20be%20able%20to%20use%20the%20advanced%20functions%20of%20TCD%20as%20well%20as%20Power%20Query%2C%20Power%20Pivot%20supplements%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20feedback.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20evening%20to%20you%20all.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2150030%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151191%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20et%20Power%20Pivot%20avec%20Excel%20en%20achat%20d%C3%A9finitif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151191%22%20slang%3D%22en-US%22%3EPower%20Query%20et%20Power%20Pivot%20sont%20inclus%20dans%20Excel%202019%3CBR%20%2F%3E%3CBR%20%2F%3E(traduit%20avec%20google)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151316%22%20slang%3D%22fr-FR%22%3ERe%3A%20Power%20Query%20and%20Power%20Pivot%20with%20Excel%20in%20final%20purchase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151316%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins!%3C%2FA%3E%3C%2FP%3E%3CP%3EThanks%20a%20lot%20for%20your%20answer.%3C%2FP%3E%3CP%3EI%20am%20reassured%20I%20will%20be%20able%20to%20buy%20the%20software.%3C%2FP%3E%3CP%3EHave%20a%20nice%20day.%3C%2FP%3E%3CP%3EIt's%20cordially.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151370%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20et%20Power%20Pivot%20avec%20Excel%20en%20achat%20d%C3%A9finitif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F972594%22%20target%3D%22_blank%22%3E%40Aurelien1745%3C%2FA%3E%26nbsp%3BYou%20tagged%20your%20question%20with%20%22Excel%20on%20Mac%22.%20Power%20Query%20and%20Power%20Pivot%20are%20NOT%20available%20on%20that%20platform.%20Some%20limited%20PQ%20functions%20are%20available%2C%20but%20you%20can%20not%20create%20or%20edit%20queries%20in%20Excel%20for%20the%20Mac.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153323%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20et%20Power%20Pivot%20avec%20Excel%20en%20achat%20d%C3%A9finitif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153323%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F972594%22%20target%3D%22_blank%22%3E%40Aurelien1745%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcellent%20point%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E.%26nbsp%3B%20Apologies%20I%20did%20not%20notice%20the%20Mac%20part.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153330%22%20slang%3D%22fr-FR%22%3ERe%3A%20Power%20Query%20and%20Power%20Pivot%20with%20Excel%20in%20final%20purchase%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153330%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20thank%20you%20for%20your%20answer.%3C%2FP%3E%3CP%3EIf%20I%20understand%20Power%20functionalities%20are%20not%20swallowable%20in%20Excel%20for%20Mac%2C%20isn't%20it%3F%3C%2FP%3E%3CP%3EIf%20I%20would%20like%20to%20use%20these%20I%20had%20to%20use%20Excel%20for%20Windows%3F%3C%2FP%3E%3CP%3EAnd%20what%20about%20Excel%20online%3F%20In%20my%20browser%3F%3C%2FP%3E%3CP%3EAur%C3%A9lien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Bonjour à tous,

 

Je souhaite acheter Excel 2019 sur Mac en achat définitif, sans passer par un abonnement Microsoft 365, pour une utilisation dans le contrôle de gestion.

 

Sur cette version, est-ce que je pourrai utiliser les fonctions avancées des TCD ainsi que les compléments Power Query, Power Pivot ...

 

Je vous remercie de vos retours.

 

Bonne soirée à tous.

9 Replies
Power Query et Power Pivot sont inclus dans Excel 2019

(traduit avec google)

Hi @Wyn Hopkins !

Thanks a lot for your answer.

I am reassured I will be able to buy the software.

Have a nice day.

Cordially.

best response confirmed by Wyn Hopkins (MVP)
Solution

@Aurelien1745 You tagged your question with "Excel on Mac". Power Query and Power Pivot are NOT available on that platform. Some limited PQ functions are available, but you can not create or edit queries in Excel for the Mac.

@Aurelien1745 

 

Excellent point by @Riny_van_Eekelen.  Apologies I did not notice the Mac part.

 

 

@Riny_van_Eekelen thank you for your answer.

If I understand Power functionalities are not avalable in Excel for Mac, isn’t it ?

If I would like to use these I had to use Excel for Windows ?

And what about Excel online ? In my browser ?

Aurélien

@Aurelien1745 Nope! You'll need a desktop Excel version for Windows. But, you can run Windows on a Mac using Bootcamp (starts-up your Mac with either MacOs or Windows) or products like VMWare or Parallels (these allow you to swap between both systems without restarting).

I'm using the last option on a fairly old MacBook Pro (late 2012). It's a bit slow if you handle very large data sets, but still acceptable for me.

 

@Riny_van_Eekelen alright I understand. so i can use a mac and use a virtual machine to emulate windows. what is the configuration of your macbook pro please?

Here you have the specs:

Screenshot 2021-02-21 at 18.39.50.png

 

 

@Riny_van_Eekelen Thank you so much.

I think I will buy a similar macbook pro and follow your solution, a good compromise.
Thank you again, have a nice day.