In this live webinar, you will learn how you can use Excel to analyze large datasets.
You will learn to combine functions in Excel in order to develop more complex data models and analyses.
You will gain experience in using Pivot Tables and Pivot Charts, which are effective tools for calculating, summarizing and analyzing data.
In addition, you will get tips and tricks on how to structure your Excel sheets.
It will be possible to ask questions to the instructor during the webinar.
Who is this course for?
This webinar is for everyone who has already taken the course 'Excel for beginners' or for those of you who have practical experience with Excel
After completing this course, you will be able to:
NB: If you are already familiar with the above mentioned functionality, our recommendation is that you check out our other courses. At the course "Excel Advanced" you will learn how to build Pivot tables and use more advanced functions for data analysis
IDA Studynow now offers online live webinars. The webinars are hosted on Zoom and you will follow the instructor live as he presents and demonstrates the program. During the webinar you get the opportunity to ask questions and receive guidance on your potential challenges with Excel.
Online courses at Studynow
IDA Studynow offers online video courses. You can start, pause and review the course as many times as you would like. All you have to do is create a free Studynow user on:
Before you register on https://ida.studynow.dk/users/sign_up make sure to collect your discount code in the IDA app ‘Hello Fellow’ under the section ‘Fordele’ (benefits).
After doing this you are ready to watch all of our courses.
Marc Madsen works as a Senior Analyst in Nykredit. On a daily basis Marc works with complex data analysis as well as developing and optimizing cost allocation models.
Marc is educated Cand. Merc. ASC (Accounting, Strategy and Control) from CBS and for the past 6 years he has worked with financial management in some of the largest public and private Danish companies. Marc has extensive experience with Excel, VBA and Power BI
This webinar is a collaboration between IDA and Studynow. The list of participants is therefore available to both IDA and Studynow.
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 StudyNow at firstname.lastname@example.org
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
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: The Danish Society of Engineers, IDA
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. In addition, at some events, name tags are provided, where your name, title and company appear. If you unsubscribe from the event, your information will not appear in the attendance list.
When you are registered as a participant at this webinar, you will also automatically receive info about the next webinar within the same subject area.
Vigtig oplysning vedr. persondata på deltagerlister: Dit navn, titel og firma vil optræde på deltagerlisten til dette arrangement. Deltagerlisten er tilgængelig for arrangøren og de øvrige deltagere på selve arrangementet i form af en online deltagerliste. Ved nogle arrangementer udleveres endvidere navneskilt, hvor dit navn, titel og firma fremgår. Hvis du afmelder dig arrangementet, vil dine oplysninger ikke fremgå af deltagerlisten.
Når du er tilmeldt som deltager på dette webinar, vil du også automatisk modtage info om næste webinar indenfor samme fagområde.