Excel is an excellent program, which is shown by its continued use over many decades in many different situations. Excel is a Microsoft program that is very helpful and saves many people a lot of time. It is being utilized for the past several years, and Excel has been updated on a yearly basis, where it gets new advanced features. One of the reasons why Excel is so compelling is that it can be utilized everywhere. It can be utilized for business tasks, analysis, finance, data management etc.  

However, one of the recurrent problems with Excel is "error and chaos", where it is very easy by accident to corrupt complex spreadsheets. Also, the amount of data that Excel can handle can be very limited, which is not the case with Python. Python has a lot of benefits that Excel does not have, but it can be difficult to shift from Excel to Python and it can lead to some different questions such as: Can I use Python with Excel? Is it hard to learn Python? What is Python used for? What are the benefits with Python? What is the difference between Python and Excel?

All these questions and more will be answered and shown in this webinar ‘Python for Excel Users’. This webinar provides an introduction as to how, as an Excel user, you can start to use Python. This webinar takes Excel commands that you know and shows you how these commands can by performed in Python.

What is the difference between Python and Excel?

In the business world the most standard program to use, for all kinds of different data analysis tasks, is Excel spreadsheet. Excel has a lot of features and simplicity, which makes it so commonplace, but the program also has a lot of limitations with handling data. On the other hand, Python, is a programming language, which is commonly used for different data analysis and data science and has no limitations with data.

Python has a lot of benefits compared with Excel, and some of the benefits are: 

•        Python is Open Source
  
  
•        Python can handle very large data sets
  
  
•        Python can perform calculations faster
  
  
•        Python can automate data handling
  
  
•        Python code can be reproduced
  
  
•        Python has more and more advanced diagrams
  
  

Python has a lot of benefits because it provides the tools and processing power, which Excel in many situations lacks. When you need to analyze a dataset, Excel can be a great and easy tool to use. However, with large datasets and complex analytics, Python provides more benefits.

The webinar has a high pace, but it is possible for you to view the webinar as many times as you want at your own pace.

Agenda for the webinar ‘Python for Excel users’

•        Introduction
  
  
•        Jupyter Lab // Visual Studio Code
  
  
•        Pandas, Numpy
  
  
•        Data Import - CSV and Excel
  
  
•        SUM, COUNT, IF, Lookup functions Pivot Tables
  
  
•        Diagrams
  
  
•        Openpyxl and xlwings