What did I learn today: Power Query Preview Hyperlink
What a brilliant feature, which was lying right in front of me for months, but I did not notice it. In Power Query Preview dialog, every field name has a
What a brilliant feature, which was lying right in front of me for months, but I did not notice it. In Power Query Preview dialog, every field name has a
The Need: Trace Dependents Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file
A new way of Filtering Pivot Tables by time is now available (2013) – called Timeline. It allows filtering of one or more pivot tables by years, months and quarters
Just one button to press. Data – Remove Duplicate. Data should be a table (or like a table – column headings with data below). If it is a table choose
Lot has been written about it. With Excel 2013, Microsoft did the smartest thing. They added a chart type called Recommended Chart. Now Excel is smart enough to look at
It is a powerful but often ignored feature of Power Pivot. It allows you to describe the meaning of the data column – independent of its field name. Estimated
Single row of data which is split into two rows! Trying to clean-up such data is a frustrating experience. Here is how you do it – faster and smarter! 3 min
[youtube https://www.youtube.com/watch?v=KzQiY0OFTLw?rel=0] Share data from Head Office to field staff or vice versa. All using the powerful List feature of SharePoint. Zero Programming. Anyone can do it in minutes. Try
Capturing data from multiple people without using Excel: [youtube https://www.youtube.com/watch?v=KbdTCYARmj4?rel=0] This is a single most useful feature of SharePoint. No programming. Just create a list and get started. Much better
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.
