|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-for-excel-xlwings-for-data-science-and-finance/
课程评论：没有评论
课程名称：Python for Excel: 使用xlwings进行数据科学和金融 课程概述：2023年10月新增的Python在Excel中的功能！该课程结合了Python与Excel的优点，推荐使用xlwings这款工具。课程内容旨在帮助学员了解在数据科学、商业和金融领域中，如何有效结合Excel与Python。通过使用xlwings，学员可以在Excel中直接使用Python数据科学库（如Numpy、Pandas、Scipy、Matplotlib、Seaborn和Scikit-learn），从而提升Excel项目的能力。 课程适合对象： - 经验丰富的Python编码者：学习使用Excel作为图形用户界面（GUI），利用Python脚本和Excel面板展示结果。 - Excel用户和Python初学者：通过Python编写清晰和强大的代码，增强Excel项目的功能。 - 混合小组：非编码者也能通过Excel的按钮轻松运行和使用Python代码。 学习收益： - 从基础开始掌握xlwings库。 - 针对Excel用户和完全的Python初学者，课程包含量身定制的Python快速入门教程。 - 提供最全面和实践性强的xlwings在线课程，涵盖三个真实项目。 项目简介： 1. 第一个项目：通过添加Python蒙特卡洛模拟，提升Excel中的金融模型，运行Excel计算10,000次并分析结果。 2. 第二个项目：创建类似Bloomberg的股票仪表板应用，结合Excel的图形用户界面和Python的分析后端。 3. 第三个项目：学习在Excel中直接使用Pandas方法和函数处理数据集。 为什么选择Excel？ - Excel是最优良的图形用户界面（GUI）和报告工具，广泛应用，用户体验直观，维护简单，是金融模型和电子表格计算的最佳选择。 为什么选择Python？ - Python拥有强大的数百个库，是数据科学、机器学习和高级分析的首选，且学习和应用更加简洁。 为什么学习和掌握xlwings？ - xlwings是整合Excel与Python的完美工具，允许用户从Python自动化Excel，编写Python宏，利用NumPy和Pandas等库的强大功能进行数据分析。使在Excel中使用用户自定义函数变得简单，并支持动态数组公式。 课程提供30天无风险退款保证，欢迎所有的学员（包括Mac用户，需注意部分内容在Mac上不可用）。期待在课程中见到你！
Newly added in Oct 2023: The NEW Python in Excel Feature!(Python in Excel and xlwings are complementary tools - get the best of both tools!)Excel vs. Python - what is the best tool for Data Science, Business, and Finance?The answer is: Use Excel and Python together and integrate both tools with xlwings. Get the best of two worlds!With xlwings, you can use Python Data Science libraries like Numpy, Pandas, Scipy, Matplotlib, Seaborn, and Scikit-learn directly in Excel! You can run Python code in Excel and boost your Excel projects! More and more Professionals and Developers useExcel as Frontend Python as analytical Backend. This course is the perfect choice for Experienced Python Coders: Use Excel as Graphical User Interphase (GUI) Run your Python scripts with Excel Present your results with Excel Dashboards Excel Users and complete Python Beginners: Boost your Excel projects with clean and powerful Python code! Mixed Groups: Non-Coders can run and use Python code simply by clicking on buttons in Excel. Why take this course?You will learn and master the xlwings library from scratchFor Excel Users and complete Python Beginners: This course includes a Python Crash Course that is tailor-made for you!It´s the most comprehensive and practical (hands-on) xlwings course on the webIt covers three comprehensive real-world projects.Project 1: You will learn how to boost your financial model in Excel by adding a Python Monte Carlo Simulation - Run your Excel calculation 10,000 times with different sets of inputs and analyze the results!Project 2: You will learn to create Bloomberg-like Stock Dashboard Apps with Excel (Graphical User Interface) and Python (analytical Backend).Project 3: You will learn how to use Pandas methods and functions on your datasets directly in Excel.Why use Excel?There is no better Graphical User Interface (GUI) and Reporting tool than Excel. Excel is widely spread (750 million users) standardizedintuitive to usemost users are well-trained it requires low/zero setupit requires low/zero maintenance and it´s still the best choice for financial models & spreadsheet calculationsWhy use Python?With hundreds of powerful Libraries, Python is the first choice for Data Science, Machine Learning, and advanced analytics in Business and Finance. The Python Ecosystem is way more powerful and versatile than VBA. And it´s cleaner and easier to learn and apply!Why learn and master xlwings?xlwings is the perfect tool to integrate Excel and Python! xlwings allows you toAutomate Excel from Python e.g. to produce reports or to interact with Jupyter Notebooks.Write macros in Python that you can run from buttons in Excel, e.g. to load data from a database or an external API.Write UDFs (user-defined functions) and leverage the power from NumPy, Pandas, and machine learning libraries.Leverage Python's scientific stack for interactive data analysis using Jupyter Notebooks, NumPy, Pandas, scikit-learn, etc.Use xlwings to automate Excel reports with Python.Write Excel tools with Python instead of VBA and call your code directly from within Excel, e.g. via a button on the sheet.This also works great for prototyping web apps.Write (array) UDFs in a breeze by taking advantage of all the functionality already available in libraries like NumPy and Pandas.Dynamic array formulas are supported.As always, there is no risk for you as I offer a 30-day money-back guarantee. I am looking forward to seeing you in the course!(Mac users are welcome! However, please note that 10%-15% of the course content (UDFs) is currently unavailable on Mac!)
