Python for Excel: Use xlwings for Data Science and Finance

Integrate Excel and Python and get the best of two Worlds! Python Beginners welcome. Use Pandas, Seaborn & co. in Excel

Created by: Alexander Hagmann
Data Scientist | Finance Professional | Entrepreneur

What Will I 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

Requirements

• A desktop computer (Windows or Mac) capable of storing and running Python/Anaconda. The course will walk you through installing the necessary free software.
• An internet connection capable of streaming HD Videos.
• A working installation of Microsoft Excel.
• Mac users are welcome. Please note that 10%-15% of the course content (UDFs) work on Windows only!
• Willingness to code and work with Python.

Target audience

• 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).