Tag: excel

PowerQuery and PowerPivot, the two new powerful features for the latest Excel

PowerQuery and PowerPivot, the two new powerful features for the latest Excel

You are a proficient Microsoft Excel user – vlookup is an appetizer, pivot-table is the main course, and VBA/Macro is your dessert.   And your company just gave you an upgraded Microsoft 365 subscription, and a brand new version of Excel is just being served.  You are wondering – “What’s new?”

As an analyst living and breathing with Excel, PowerPivot and PowerQuery are the two killer features, period.  I’d like to share my story on how you can save time and make your spreadsheet work more efficient.

Continue Reading