📌 Excel tips Do you often find yourself in need of accurate currency exchange rates while working on your financial spreadsheets? 🤔 Excel has the answer! Simply follow these easy steps to add live currency exchange rates in Excel. 💡 Pro Tip: The process can be automated to refresh the data periodically to ensure the …
“Beyond the Buzzwords” Demystifying APIs, RPA, AI and IoT for Treasury 🤖 Last week, we at Automation Boutique had the exciting opportunity to present our “Beyond the Buzzwords” workshop to the treasury department of one of the world’s largest oil and gas companies, which is facing major changes due its commitment to support the energy …
📢 Attention all #PowerQuery users! Do you want to learn how to work smarter, not harder? 💡 Check out these top #BestPractices for Power Query! #DataManipulation #PowerQuery #Automation #PowerQueryTips
What’s the best fit for automation? After working with both, here’s a quick comparison: UiPath offers advanced features for professional users but comes with a steeper learning curve, while Power Automate seamlessly integrates with Microsoft products. Ultimately, the choice between the two will depend on the specific needs of the project. It’s important to carefully …
Which one should we use❓ With “Select Columns” you specify the columns that you need.With “Remove Columns” you specify the columns that you don’t need.“Select Columns” is usually better and leads to more robust queries. Why❓ 👉 It is more likely for the query to break due to unnecessary errors if you use “Remove Columns”. …
🚨 Power Query Quiz: “Select Columns” vs “Remove Columns” Which one should we use❓ With “Select Columns” you specify the columns that you need. With “Remove Columns” you specify the columns that you don’t need. “Select Columns” is usually better and leads to more robust queries. Why❓ 👉 It is more likely for the query …
