Instructions

To use Python to work with Excel, this guide is consisted of 4 tasks:

• Installing Python 3.8.2 and Pycharm
• Configuring Python and downloading libraries
• Writing a basic Python code
• Running code that you have written and fixing some possible bugs

Installing Python 3.8.2 and Pycharm

Python will be doing most our work. We are going to download Python 3.8.2 and Pycharm.

Downloading Python

1) Go to Python download page: Python.

This is the page you are at

2) Click “Download Python 3.8.2”.

3) Click on just downloaded folder “python-3.8.2.exe” at the bottom left corner of the screen.

4) Tick on “Add Python 3.8 to PATH”.

5) Click “Install now”.

Now we are waiting for it to download.

When it finishes, we should encounter this:

6) Click “Close”.

Downloading Pycharm

1) Go to Pycharm download page: Pycharm.

2) Choose your Operating System (Windows/Mac/Linux).

3) Click “Download” in “Professional” column. We will wait for it to download.

4) When it finishes, click “Next >”

5) Browse the location you want to put this folder then click “Next >”.

6) Tick all the boxes in “Installation Options” then click “Next >”.

7) Click “Install”.

8) Click “Finish”.

Conclusion

Installing Python and Pycharm is the primary step of the whole instruction. Once you have downloaded them, you are halfway done.