by Gil Raviv | Dec 14, 2016 | Salesforce
As a special gift to you for the coming holidays, I am about to share a FREE Excel template that analyzes Salesforce opportunities. While the template is going to be available to all readers by end of 2016, you can be to first to try it, by subscribing to my blog. The...
by Gil Raviv | Jan 13, 2016 | Popular, Unpivot - The definitive guide
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following challenge: How to split comma-separated values in Power Query. We have a table of event names, dates and...
by Gil Raviv | Jan 3, 2016 | Uncategorized
(Originally published here) The demo I will share with you today is something that I was itching to try for a while. Before I joined Microsoft and Excel team, I had spent 14 years in developing Network & cyber Security products. Whether we had been developing...
by Gil Raviv | Dec 9, 2015 | Uncategorized
This week we have announced on Office Blogs the release of 3 new Excel templates that harness advanced data analytics technologies in Excel 2016: Power Query (Excel 2016 new get-data and transformation features that are available in the Get & Transform section of...
