25 Amazing Power Query Tips and Tricks

1. Delete Steps Until End 2. Preview or Navigate to Table Objects 3. Double Click to Edit a Query 4. Automatically Add a Row Index to any Query Loaded to a Table 5. Change the Default Load Options 6. Display a Monospaced Font in the Query Editor 7. Navigate Columns with the Arrow Keys 8. Comments in Power Query Formula Language 9. Add Comments Without Opening the Advanced Editor 10. Add Comments that Stay Visible in the Formula Bar 11. Add Comments with the Query Step Properties 12. Create a Sequential List 13. Avoid Case Sensitivity with Filters 14. Double Click to Rename a Column 15. Rename a Column with a Keyboard Shortcut 16. Navigate Through Complex Query Dependencies 17. Drill Down to a Single Value 18. Enable Fast Data Load in Power Query 19. Disable the Auto Detect Data Type Feature 20. Explore Power Query’s Function Library 21. Split a Query into Two Parts 22. Copy and Paste Queries to a New Workbook 23. Double Click to Rename a Query 24. Double Click to Hide or Show the Query Editor Ribbon 25. Disable Relationship Detection For the full written tutorial check out my website: www.howtoexcel.org/power-query/power-query-tips-an… 👇 Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/ DOWNLOAD the example workbook here 📖 www.howtoexcel.org/downloads/ SUBSCRIBE & get my 3 FREE eBooks 📧 www.howtoexcel.org/newsletter/ CONNECT with me on social Facebook: www.facebook.com/howtoexcelblog Twitter: twitter.com/howtoexcelblog LinkedIn: www.linkedin.com/in/john-macdougall/ Thanks for all your supp

• #
• #microsoft_excel
• #excel
• #microsoft
• #tutorials
• #power_query
• #get_and_transform