Python for Excel Users - Conducted in English - webinar
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.
Webinar Objective
Excel is an excellent program, which is shown by its continued use over many decades in many different situations.
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 is limited which is not the case with Python.
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.
Benefits of Python
- 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
The webinar takes 1½ hours and the pace is high, but after the webinar it is possible for you to view a reording og the webinar as many times as you want at your own pace.
Agenda
- Introduction
- Jupyter Lab // Visual Studio Code
- Pandas, Numpy
- Data Import - CSV and Excel
- SUM, COUNT, IF, Lookup functions Pivot Tables
- Diagrams
- Openpyxl and xlwings
It will be possible to ask questions to the instructor, and these will be answered at the end, time permitting.
If you have any questions about the contents of this webinar you can contact Lone Jelgren of Jelgren Consult, by phone - 22 24 00 75 or by email - lj@jelgrenconsult.dk.
Background Knowledge
We expect for you to be familiar with the basic functions of Excel. It is not necessary to have VBA experience or other programming experience. It is an opportunity to learn something new and receive an introduction to programming.
This webinar will be recorded. Link to the recording will be sent to all registered 2-3 days after the webinar.
Registration procedure for the webinar: Once you have registered you will receive a confirmation e-mail. At the bottom of this mail you will find a link to the webinar. You log in through this link and are forwarded to the site where the webinar is shown.
Should you have any problems logging in, you are welcome to contact us at: webinarsupport@ida.dk
Also check out our FAQ site where you can get answers to the most frequently asked questions in connection with webinars: FAQ about IDA webinars
Privacy info: If you would like to participate anonymously, we recommend you join by browser instead of using the Zoom software client or app, and when Zoom asks you to provide your name you can enter "Anon" or another pseudonym. Zoom processes personal information in global datacenters including USA and processing is carried out according to EU Commission standard data protection clauses. For further details, we refer you to the Zoom privacy policy available here: https://zoom.us/privacy
It is not allowed to share the zoom link or the video link with others, or to record audio and images of the webinar.
Organizer: IEF-Fonden
Sign up: Not a member? In order to sign up, you must create a user profile. Note, when creating a user profile, you will be able to access IDA's online services - you will not become a member of IDA.
Important information regarding personal data on participant lists: Your name, title and company will appear on the attendance list for this event. The participant list is available to the organizer and the other participants on the event itself, in the form of an online attendance list. If you unsubscribe from the event, your information will not appear in the attendance list.
.
This event is closed for registration.
Information