These built-in add-ins are powerful and useful. Power Pivot, Power Maps, and Inquire. Learn how to enable and use them. Contents Related videos Handle millions of rows in Excel –
I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already
Power Pivot Data Model adds database like features to Excel. Power Pivot allows you to handle millions of rows of data, from multiple data sources and lightening fast analysis. It
Here is a quick listing of the key differences from a usage point of view. It will help you choose the right type based upon the analytical objectives.
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here. [youtube https://youtu.be/W2sP3n7LYMo]
Redundant or unwanted columns can confuse the users of Pivot Table. Here is how you can hide unwanted columns from appearing in the Pivot Table field list. This setting is
Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify
Excel Table seems like a trivial feature. But if used correctly, it transforms and improves the way you use Excel dramatically. Here is a set of articles (the entire knowledge
Presentation download with reference links Download the Presentation (3 MB). I have added lots of links to related articles and external references including books written by stalwarts in Excel analytics
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
