Automating Microsoft Office (Windows) with Python
This course provides in-depth training on automating Microsoft Office applications using Python. Participants will gain proficiency in leveraging Python libraries to streamline workflows, enhance data management, and create customized solutions. By mastering these skills, individuals can significantly increase efficiency and productivity within their organizations.
Last Updated Oct 2024
- Use python-docx to automate Microsoft Word - Formatting, updating, editing tables, inserting images and exporting as PDF
- Use python-pptx to automate Microsoft Powerpoint - Amend text, replace image, update tables, create charts, formatting
- Use pywin32 to automate Microsoft Outlook - Read, send and delete emails. Move emails to folders and create meetings
- Manipulate files in Windows - Move and delete files, create folders, run task scheduler
Dates:01 Dec 2024 to 10 Jan 2025
Time:Every Tuesday and Thursday 7pm to 8pm
Mode:01 Dec 2024 to 10 Jan 2025
Lesson 1: Manipulate text in Microsoft Word with python-docx
- Understand usage of python-docx. Install and walk through basic usage and examples
- Use python-docx to create new documents, open existing and save documents in different formats
- Add, replace, delete and format text in word document
- Manipulate paragraph properties such as spacing and alignment
Lesson 1.5: Practices
Lesson 2: Handle tables and images Microsoft in Word with python-docx
- Working with tables in word document - create table, insert rows, merge and split cells, format cells
- Add images, resize them and position images
- Amend document properties
- Customizing styles and themes
Lesson 2.5: Practices
Lesson 3: Mange slides and text Microsoft Powerpoint with python-pptx
- Introduction to python-pptx and installation
- Add slides, delete slides and reorder slides
- Add text to slides, replace text, delete text and formatting text
- Amend presentation properties
Lesson 3.5: Practices
Lesson 4: Work with shapdes, images and tables in Microsoft Powerpoint with python-pptx
- Add shapes to slides, resize and position shapes and format shapes
- Manipulate images - add, resize and apply image effects
- Create new tables, insert and delete cells, format cells
- Add charts to slide and customize its appearance
Lesson 4.5: Practices
Lesson 5: Introduction to automating outlook using pywin32
- Understand pywin32 capabilities and limit. Learn about Windows API
- Create Outlook application object
- Access different folders in Outlook (inbox, sent, etc), create and delete folders
- Move items between folders
- Access email messages, contacts and appointments
- Create new email and modify subject, title, body, message etc
Lesson 5.5: Practices
Lesson 6: Working with appointments and receiving email using pywin32
- Access upcoming appointment information
- Create new appointment, modify appointments and search for appointments
- Retrieve new emails from folders
- Filter and search for emails based on criteria
Lesson 6.5: Practices
Lesson 7: Manipulate files and folders in Windows
- Find, rename and delete files. Move files to other folders
- Create new folders, merge folders and delete them
- Run task scheduler to automate running of python script
Lesson 7.5: Practices
- Basic knowledge of Python
Price
$750 nett
Classes
15
Assignment
Yes
Language
English
Duration
7 weeks
Students
4 to 5
Level
Intermediate