Windows Excel users use Power Pivot to combine multiple sheets and tabs, but us Mac users don't have this feature available. So instead, I will show you how to use Power Query to achieve the same goal. Not only can we combine similar sheets fast, we can also combine data with a lookup table WITHOUT using a lookup function like vlookup, xlookup or index match.

Want to learn more on Pivot Tables before diving into Power Query? Check out my free tutorials on Pivot Tables: [ Ссылка ]

As of November 15, 2022 - Power Query for Mac is only available on Current Channel Preview or Beta Channel. To turn this on (and yes, you can always return later to Current Channel): Excel -- Help -- Check for Updates -- Advanced -- Update Channel: Current Channel (Preview) -- click OK after reading the agreement -- close window -- check for updates -- download. You may need to restart your computer.

#excel #excelonmac #pivottable #analytics #mac #learnexcel #exceltutorial #excelforbeginners #powerquery

свернуть