Summary

This chapter was built on our previous knowledge of linking Excel to our decision service using Power Query. We added three other ways of achieving this link – using VBA, using Microsoft Script Lab, and using Office Scripts. For each option, you saw a fully working example that you can extend for your day-to-day work. Just as important, we gave a summary of which linking technique might be the best to use depending on your current project.

You’ll notice that while we introduced Power Automate as a tool to link Excel and our decision service, we haven’t (yet) covered it in detail. In the next chapter, we complete the set of deep-dive instructions by looking at Power Automate workflows and how we can use our decision service as part of them.