Excel Sunday Consulting

09/11/2016

October 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful new set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce three new data transformation and connectivity features that have been requested by our customers. —Read on for details.

09/11/2016

PowerPoint 2016 has an amazing feature of Presentation Mode where you can view your notes and your participants can't. Read More below:

Learn about Presenter View in PowerPoint 2016.

09/11/2016

Visual Studio 2015 Community edition can be used instead of R studio or other great

Windows installation of Microsoft R Client.

09/11/2016

Download an enhanced version of R from Microsoft

The MRAN website offers info about R and its packages as well as archives of past R package versions and downloads of Microsoft R Open.

30/08/2016

http://chandoo.org/wp/2016/08/30/visualizing-financial-metrics/?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+PointyHairedDilbert+%28Chandoo.org+-+Learn+Excel+%26+Charting+Online%29

Around 2 months back, I asked you to visualize multiple variable data for 4 companies using Excel.  30 of you responded to the challenge with several interesting and awesome charts, dashboards and …

24/08/2016

Faster OLAP PivotTables in Excel 2016

If you work with connections to OLAP servers, query and cache improvements to this powerful feature now make your PivotTables even faster.

25/05/2016

This has annoyed me years. How about you? Please leave your comments.

19/05/2016

Power Pivot and Power Query for Dummies datapigApril 11, 2016April 11, 2016 Training No Comments Need to get a quick ramp-up on Power Pivot and Power Query? Good news…A new book just dropped on Amazon. Learn how to: Create your own database right in Excel with Power Pivot Make pivot tables that use…

29/03/2016

http://datapigtechnologies.com/blog/index.php/lock-slicers-before-sending-out-your-dashboards/

29/03/2016

http://datapigtechnologies.com/blog/index.php/adding-dynamic-annotations-for-your-charts/

06/02/2016

Learnt something new about PowerQuery: I share with you -

22/01/2016

Interesting Updates: