Category: Other Tutorials

Python in Excel


Free Download Python in Excel
Released 8/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 25m | Size: 71 MB
If you work with data, you know that Excel is one of the most popular and powerful tools at your disposal. Depending on your industry or field, you may also use Python for data analysis, forecasting, running machine learning models, and more. For many people who deal with data, it’s common to use both tools in the same workflow, and moving your data between the two can be a hassle. Good news! In the new public preview of Excel, you can now use Python directly in Excel, eliminating the need to move your data between the tools. In this course, Scott Simpson explores the Python features launched in the public preview, showing you how to manage your entire data workflow directly inside an Excel worksheet. Join Scott to learn about exciting and powerful features-referencing Excel values in Python, using pandas to analyze data in an Excel worksheet, using Python plotting modules, and more-and see how you can leverage the power of Python in your Excel sheets to gain insights from your data.

(more…)

Python Statistics Essential Training (2023)


Free Download Python Statistics Essential Training (2023)
Released 8/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 2h 39m | Size: 392 MB
The field of statistics has become increasingly dependent on data analysis and interpretation using Python. With the rise of big data and data science, the demand for professionals who can effectively analyze and interpret data using Python has skyrocketed. In this course, Matt Harrison teaches you how to collect, clean, analyze, and visualize data using the powerful tools of the Python programming language. Join Matt as he gives into the various techniques that form the backbone of statistics and helps you understand the data with summary statistics and visualizations. He explains how to create predictive models using both linear regression andXGBoost, and wraps up the course with a look at hypothesis testing. If you’re interested in exploring statistics using a code-first approach, join Matt in this course as he shows you how to use Python to unlock the power of data.

(more…)