Python in Coding Classes
🧠Module 1: Introduction to Python in Excel
What is Python in Excel (Microsoft 365 integration)
Use cases of Python in Excel
Setting up Excel for Python (Excel Labs, Anaconda, or xlwings)
📂 Module 2: Python Basics for Excel Users
Variables, data types, and operators
Conditional logic (if, else)
Loops (for, while)
Functions and lambda expressions
Lists, tuples, dictionaries
📊 Module 3: Working with Excel Data
Reading and writing Excel files using:
DataFrames and Excel Tables
Accessing cell values, ranges, and sheets
📉 Module 4: Data Cleaning & Analysis
Handling missing values
Filtering and sorting data
Grouping and summarizing (pivot-like operations)
Merging and joining tables
Date and time functions
📈 Module 5: Data Visualization in Excel with Python
Line, bar, pie charts using matplotlib & seaborn
Embedding plots inside Excel sheets
Styling charts (colors, labels, legends)
Exporting plots to Excel or images
🧾 Module 6: Excel Automation using Python
Automating repetitive tasks (reports, formatting)
Sending emails with Excel attachments
Scheduling tasks with Python
Interacting with Excel formulas
🛠 Module 7: Advanced Excel-Python Integration
Interactive Excel dashboards with Python
Custom Python functions in Excel cells
Excel buttons triggering Python scripts
Scripting with Office Scripts (bonus)
📦 Module 8: Real-World Projects
Sales Dashboard with Python & Excel
Inventory Management System
Excel Reporting Tool with auto-mailing
Forecasting and prediction using Excel + Python (basic ML)
📁 Module 9: Sharing and Deployment
Protecting Excel files with embedded Python
Exporting Excel+Python solutions to clients
Sharing via OneDrive/SharePoint with Python support
Introduction to Power BI integration (optional)
🎓 Final Assessment & Certificate
Capstone Project
Q&A / Viva
Feedback & Certification
About the Instructor
MR. Sujit Kumar Singh
MIS & Data Analyst
Sujit Kumar Singh is a seasoned Excel and MIS (Management Information Systems) trainer with over 21 years of
experience in the field. He has worked as an MIS Executive and VBA Developer across more than 10 companies
and currently serves as a report consultant for over 40 organizations. His teaching approach emphasizes
practical, real-world applications, aiming to equip learners with skills directly applicable to their professional
tasks
In 2007, Sujit founded IPT Excel School, one of the pioneering institutes in New Delhi offering online live classes in Advanced Excel and MIS training. The institute
caters to working professionals, providing courses that cover Advanced Excel, VBA Macros, Dashboard creation, and Power BI.
Sujit also maintains an active presence on platforms like YouTube and LinkedIn, where he shares tutorials and insights on Excel and related tools. His YouTube
channel, Sujeet Kumar Advanced Excel Training in Hindi, offers a range of videos aimed at enhancing Excel proficiency.
For more information or to enroll in his courses, you can visit IPT Excel School's website or contact him directly at +91 8802579388.
IPT Excel School
IPT Excel School - Arijpur , Rrjla, Kurhani , Muzaffarpur Bihar-844120
+91 8802579388 , +91 8826828093 +91 9525256051
[email protected] Subscribe to our WhatsAPP Grouphttps://chat.whatsapp.com/ITgEd0sKgso7PHTOqGFPKB
