Summary
A wide selection of actions from both the Excel basic and advanced package has been covered in this chapter. The walk-throughs will have given you the opportunity to build three individual bots all performing different tasks. You should be confident with opening, closing, and saving Excel documents, as well as reading and writing to them. The skills gained should also include working with data within Excel documents, such as sorting, inserting columns, adding formulas, as well as running macros.
The next chapter continues with Microsoft applications. In this case, we will be looking at Microsoft Word. You will learn how to create and edit documents. You will build a role-based bot that will include working with Excel to generate Word documents.