Skip to content Skip to sidebar Skip to footer

Take the Leap From Excel to Python: A Hands-On Guide

Take the Leap From Excel to Python: A Hands-On Guide

Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz
Language: English | VTT | Size: 4.06 GB | Duration: 8h 15m

What you'll learn
You will know how to use "notebooks" to create well-documented and re-usable data analysis.
You will know how to re-create major Excel features like cell formulas and pivot tables in Python.
You will know how to use Python and pandas to perform VLOOKUP style operations
You will know how to use matplotlib to re-create Excel charts.
You will know how Python packages and functions are used
You will know how to build Excel pivot tables in Python

Familiarity with basic data analysis in Microsoft Excel.
No prior experience with programming is required — this course is geared for beginners.

This course will use hands-on exercises to teach you how to apply your Excel knowledge in Python.

Several years ago, I was in your shoes. I tried learning Python but would go back to do things in Excel because I was more comfortable with it. My goal in this course is to help you become as comfortable in Python as you are in Excel. To become comfortable, you need to have opportunities to participate in hands-on exercises and projects. You will have the chance to do both in this course.

This course is designed for students who want to grow their careers or improve their analysis by using Python.

What will you learn:

How to use Google Colab to begin using Python without installing software

How to use Python packages and functions

How to import and export data from Python

How to perform basic tasks like data cleaning

How Python can save time by creating scripts which can be re-run easily

How notebooks can be used to create well-documented analysis

How to replicate many Excel features

Excel features we will replicate in Python:

Pivot tables



Cell formulas like SUM( ), IF( ) and CONCATENATE( )

Filtering rows

Performing text to columns splits

and more!



Use Brave Browser that helps when download from Uploadrar

you must be registered member to see linkes Register Now

Leave a comment