The Curious Engineer

All blogs / Dev tools / editors / IDEs

Get & Transform Data in Excel 2016

learn.microsoft.com/en-us/archive/blogs/gilraviv

Explore cool ways to transform you data in Excel 2016 based on Power Query technology

Dev tools / editors / IDEsDatabasesMicrosoft blogsMSDN archive

’15’16’17’18’19’20’21’22’23’24’25’26
Posts
21 from 2 Jul 2015 to 15 Aug 2016
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/gilraviv/feed.xml

2016 4

  1. Sentiment Analysis in Power BI & Excel
  2. Power Query List.Accumulate, List.Generate, Matrix Multiplication and Nested Loops
  3. Facebook Insights, Excel, Power BI, Presidential Election & Ghostbusters
  4. Facebook Page Insights with Power BI Dekstop

2015 17

  1. Good bye TechNet, hello Data Chant
  2. Star Wars - The Power (BI) Awakens
  3. My Calendar Insights In Excel 2016
  4. Use VBA to enable Fast Combine in Excel 2016
  5. Split and Unpivot Comma-Separated Values
  6. Unpivot ANY nested table and load to Power BI Desktop
  7. Transform ANY nested table to Pivot Table with function query
  8. Transform a nested table to PivotTable
  9. Back to School - Transform class schedule to PivotTable (Power Query)
  10. Transform already-pivoted tables to PivotTable (The Definitive Guide to Unpivot with Power Query in Excel)
  11. Excel for Security Analysts - Episode 2
  12. Excel for Security Analysts Series
  13. Transform multiline records into a table
  14. Excel for Security Analysts - Episode 1
  15. Excel for Security Analysts
  16. LinkedIn, Power Query and a follow up on PowerPivotPro post
  17. Hello World!