Automate the Boring Stuff is a great book geared towards knowledge works and how to improve your daily work, by finding clever ways to deliver the most boring tasks.
The entire book is free to read on the website.
A few things you could automate:
- 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