Enterprise Automation with Python: Automate Excel

500% improvement in productivity by automating tedious chores

Key Features

● Contains numerous automation projects, including excel sheets, word documents, pdf files, websites, and messenger.

● Provides a strong understanding of Automation, its fundamentals, and strategies to implement it across organizations.

● Nurtures various techniques to improvise operational efficiency around repetitive business processes.
Description

Written by ZappyAI's founder, this book gives real-world examples of how readers can implement automation in their businesses and business-as-usual tasks. Through a series of real-world examples and live demonstrations, this book shows how to automate various tasks using Python scripts.

This book gives solutions to everyday automation needs and repetitive tasks at work every day. Readers will be able to discover the most typical business process that can be automated and write simple Python scripts to turn them automated. This book will teach you how to create, read, change, and extract data from Excel documents using Python programming. Readers can extract data from websites, PDF documents, Gmail, Outlook, and WhatsApp chats. Text extraction from photos and scanned documents is also smartly accomplished in this book.

The final section will examine techniques for extending your Python scripting skills and constructing complicated end-to-end process automation. Throughout the book, readers will be utterly captivated by how to automate their tedious tasks and enhance their organisations' productivity by 500 percent.

What you will learn

● Learn to write automation scripts by learning how to use different Python scripts.

● Find out how to look at the business process to automate it.

● Create, read, edit, and extract data from spreadsheets, documents, and PDFs.

● Control mouse and keyboard activities, as well as automate several desktop apps.

● Examine strategies for automating the downloading and extraction of data from the Internet and websites.

● Organize the real-time transfer and reading of Gmail, Outlook, and WhatsApp messages.

Who this book is for

Software Engineers, Business Analysts, Automation Engineers, QA Engineers, and anyone who wants to simplify and automate their tedious work with simple yet powerful Python scripts. Readers with little or no technical experience can also use the strategies discussed in this book to automate day-to-day tasks.

Table of Contents

1.Setting up the automation environment

2. Fundamentals of Python

3. Automation mindset – Python as a tool for automation

4. Automating Excel-based tasks

5. Automating Web-based tasks

6. Automating File-based tasks

7. Automating Email, Messenger Applications and Messages

8. GUI - Keyboard and Mouse Automation

9. Image based Automations

10. Creating Time and Event-based Automations

11. Writing Complex Automations