Post in evidenza

Recovery - Access, Excel, Word, Office and Photo recovery tools and other blog procedures

During these years I had necessity to recover various files (.doc, mdb, .xls, photos...)  I utilized various free tools (here is an exampl...

Microsoft Power Query for Excel

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

i would like to highlight this excel tool that i recently discovered

download:

https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=c2276676-6a86-4e6d-9722-be34ed96503e

Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more.

If you want to go deeper with this tool you can review these articles:

https://www.excelcampus.com/powerquery/power-query-overview/

Power Query italian & English Guide

https://support.office.com/it-it/article/Guida-di-Microsoft-Power-Query-per-Excel-2b433a85-ddfb-420b-9cda-fe0e60b82a94?CorrelationId=44f59a8b-1551-4bc2-86e5-59f17fd0cf64&ui=it-IT&rs=it-IT&ad=IT

https://support.office.com/en-us/article/Introduction-to-Microsoft-Power-Query-for-Excel-6E92E2F4-2079-4E1F-BAD5-89F6269CD605

Power Query M function reference

https://msdn.microsoft.com/library/1ed840b1-7e20-4419-ad2f-d82054c9b2ab

Power Query M Reference

https://msdn.microsoft.com/en-us/library/mt211003.aspx

Introduzione

720check