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.
.

ANYONE CAN JOIN - Most of IDA's events are open to everyone, but you must have an IDA user profile in order to participate. It's free and non-binding - create a user profile now. As a member of IDA, you get a discount on many of our events, so please sign in with your member login when you sign up for an event. Read more about the benefits of an IDA membership here.

Information
  • When

    21. sep. 2022 18:30 - 20:00
  • Where

    Webinar - In front of your pc/tablet/phone

  • Registration Deadline

    21. sep. 2022 - 15:00

  • Organizer

    IEF-Fonden

  • Available Seats

    258

  • Event Number

    344600

Price
  • Participant, not a member of IDA

    0 kr.

  • Vacant

    0 kr.

  • Member

    0 kr.