What you’ll learn
-
Automate Excel with clean and powerful Python Code
-
Learn and master the xlwings library from 0 to 100
-
Use Excel as Graphical User Interface (GUI) and run your Python code with Excel
-
Create powerful Dashboard Apps with Excel (frontend) and Python (backend)
-
Use powerful Data Visualization Tools (Matplotlib, Seaborn) in Excel
-
Learn Python from scratch with a taylor-made Crash Course (For Python beginners)
-
Write UDFs (user defined functions) and use Numpy, Pandas and Machine Learning Libraries directly in Excel
-
Write Excel tools with Python instead of VBA and call your code directly from within Excel
-
Use xlwings to automate Excel reports with Python
-
Prototype Web apps
-
Write and use Dynamic Arrays with xlwings
-
Run your financial model 10,000 times & more with a Python Monte Carlo Simulation
-
Load (financial) data from Web APIs directly into Excel
-
Run Python Scripts from within Excel with Run main and RunPython
-
Replace VBA macros with clean and powerful Python code
Who this course is for:
- Data Scientist and Finance Professionals seeking to use Excel as Frontend and Python as analytical Backend in their Projects.
- Excel professionals seeking to write Excel tools with clean Python code instead of VBA/Marcos.
- Python Beginners are welcome as the course includes a Python Crash Course designed for Excel Professionals.
- Python Developers seeking to work with Excel as GUI (Graphical User Interface).
Deal Score+1
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.