Power Automate

the Boring Stuff (PAtBS)

Focus on the important stuff. Automate the rest!

Learn about low-code, AI automation with Power Automate for Free!

Email Address

Eliminate mundane tasks and embrace the power of Power Automate.

Explore this e-book, "Power Automate the Boring Stuff” (PAtBS) and empower yourself with streamlined processes, improved efficiency, and boundless innovation. Let's revolutionize productivity together!

(Power Automate Explainer Video. Source: Microsoft)

Power Automate for absolute beginners

Have you ever considered how long it takes to complete business processes manually?

Tasks like data entry and record-keeping alone demand a full day's work. In today's rapid business world, speed and precision are non-negotiable. However, what if you could accomplish repetitive, mundane tasks quickly and easily, all thanks to the power of automation?

Introducing Power Automate

Power Automate is an easy-to-use process automation tool that can revolutionize your business processes and workflows. It can eliminate the tedium from your workdays and even offers many AI capabilities that will astound you. Embark on a journey into the world of Power Automate and discover how you can effortlessly streamline your various business processes with this low-code automation tool.

Power Automate use cases

Imagine the hours saved when you automate repetitive tasks involving monotonous mouse clicks, keystrokes, and the eternal "save" or "discard" dilemmas. With Power Automate, your computer becomes your tireless assistant, meticulously handling all the boring activities in your work day. Power Automate is "automation in action" and at your command.

See Sample Use Cases

In this e-book, you'll learn how to use Power Automate to create "bots" that will complete tasks in minutes that would take you hours to do by hand—no prior programming experience is required! Once you've mastered the basics of Power Automate, you'll create automations that effortlessly perform useful and impressive feats such as:

Search for text in a file or across multiple files
Create, update, move, and rename files and folders
Search the Web and download online content
Update and format data in Excel spreadsheets of any size
Split, merge, watermark, and encrypt PDFs
Send reminder emails and text notifications
Fill out online forms

Our step-by-step instructions will walk you through how to build each automation, and practice projects included at the end of each chapter will challenge you to improve and use your newfound skills to automate similar tasks.

Don't spend your valuable time doing repetittive, mundane work a well-trained monkey could do. Even if you've never written a line of computer code, you can make your computer do the boring work.

Start learning today how to Power Automate the boring stuff!

Don't spend your valuable time doing repetittive, mundane work a well-trained monkey could do. Even if you've never written a line of computer code, you can make your computer do the boring work.

Start learning today how to Power Automate the boring stuff!

What you will learn in the e-book

Process Automation Fundamentals

Understand the basics of Power Automate to build efficient automations.

Chapters included:

Ch.0 Dedication to Al Sweigart, author of Automate the Boring Stuff
Ch.1 Power Automate Basics
Ch.2 Flow Control
Ch.3 Subflows
Ch.4 Lists
Ch.5 Data Tables & Custom Objects

Basic Process Automation

Learn to manipulate various data types and how to handle operations for different file formats like Excel, Google Spreadsheets, PDFs, Word documents, CSV files, and JSON data.

Chapters included:

Ch.6 Text Manipulation
Ch.7 Matching the Pattern in Regular Expressions
Ch.8 Input Validation
Ch.9 Reading and Writing Files
Ch.10 Organizing Files

Intermediate Process Automation

Gain skills in web scraping, scheduling tasks, automating emails and text messages, image manipulation, and controlling the computer keyboard and mouse for GUI automation.

Chapters included:

Ch.11 Debugging
Ch.12 Web Scraping
Ch.13 Working with Excel Spreadsheets
Ch.14 Working with Google Spreadsheets
Ch.15 Working with PDF and Word Documents
Ch.16 Working with CSV Files and JSON Data
Ch.17 Keeping Time, Scheduling Tasks, and Launching Programs
Ch.18 Sending Email and Text Messages
Ch.19 Manipulating Images
Ch.20 Controlling the Keyboard and Mouse with GUI Automation

Advanced Automation Techniques and Tools

Master advanced automation techniques and leverage the use of AI tools to enhance your automation solutions with artificial intelligence, adding a layer of smart processing to your workflows.

BONUS chapters included: