Microsoft Excel Tips and Tricks
In this video I share 3 hidden tips for Microsoft Excel Power Pivot that will make your data modeling life easier. We’ll cover how you can easily copy your data model (together with queries, measures and relationships) from one Excel file to another. I’ll also show you how you can setup a dedicated measures table that will be used by default.
Credit Leila Gharani