PowerQuery Can Do That!
0 likes698 views
PowerQuery is a tool in Excel that allows users to import raw data from various sources like Google Sheets and transform it for analysis. It can take data from Google Sheets and import it into Excel where the data can be organized into a dynamic dashboard using PowerQuery. This dashboard can then be shared with clients to provide updates and insights from the source data in a refreshable format.
PowerQuery Can Do That!
- 1. #twinztalk #twinztechtip #twinztalk #twinztechtip Excel PowerQuery Can Do That! #twinztalk #twinztechtip
- 2. #twinztalk #twinztechtip #twinztalk #twinztechtip What Is PowerQuery?
- 3. #twinztalk #twinztechtip #twinztalk #twinztechtip Translate that into what I can do with it?
- 4. #twinztalk #twinztechtip #twinztalk #twinztechtip Raw Data >> Google Sheets
- 5. #twinztalk #twinztechtip #twinztalk #twinztechtip Google Sheets >> PowerQuery >> Excel Rept Easily translate the Google Sheet spreadsheet into a dynamic, refreshable dashboard tool for clients (thats PowerQuery!)
- 6. #twinztalk #twinztechtip #twinztalk #twinztechtip Additional Resources (Topic Specific) Link to Google Sheet List of 26 items I identified!
- 7. #twinztalk #twinztechtip #twinztalk #twinztechtip About The Twinz LinkedIn Twitter Lets Excel Medium Blog Business Learning Institute Instructor LinkedIn Twitter Instagram BillTomoff.com