Import and Presentation of Data in Excel - Conducted in English - København


Analysis and presentation of data are probably the tasks that are performed most in Excel. This seminar will show you some of the tools and functions you can use to do it in an efficient way.

Seminar Objective:
You will work with an example from importing data through data customisation to the final presentation of your data.

Agenda:

Import of Data
• Text (CSV)
• Database (Access - a little Database theory)

Lookup Functions
• VLOOKUP, HLOOKUP, INDEKS, MATCH
• PowerQuery - Introduction

Tables
• Creation and Use
• Data Extraction

Presentation of Data
• Types of Diagram - and selection based on the natur of the data
• PowerView - Introduction

If you have any questions about the contents of this seminar, you can contact Lone Jelgren of Jelgren Consult, by phone - 22 24 00 75 or by email - lj@jelgrenconsult.dk

Background Knowledge:
You are using Excel in your work, it is by no means necessary to be an expert, but you must know the basic features of Excel.

N.B.
The seminar is for Windows PC users - NOT Mac. You must bring a laptop with Microsoft Office 2016, 2013 or 2010 UK installed and an extension lead.
It is Excel version 2016 UK that will be used in the seminar. You will get the best benefit, if you have this version. You can attend with other versions, but there will be "functions" that are not supported.

Email
Remember to input your email address in connection with your registration. Your email address will be forwarded to Jelgren Consult. Your email address will only be used in connection with sending out relevant files.

Catering
There will be served ice water, fruit, sandwiches, mixed soda, coffee / tea and cake

Seminar Provider
Jelgren Consult

Forwarding of Personal Data to Jelgren Consult
The attendance list for this event will be passed on to Jelgren Consult, as it is necessary for the arrangement f the vent to send out relevant files.
The attendance list contains your name, title, company and email address as you provided as part of your registration.
This information is solely for this arrangement. If you unsubscribe from the event, the information will not be retained by Jelgren Consult.



Information
  • When

    2. okt. 2019 17:00 - 21:30
  • Where

    IDA Conference, Kalvebod Brygge 31, 1780 København V

  • Registration Deadline

    29. sep. 2019 - 23:59

  • Organizer

    IEF-Fonden

  • Available Seats

    12

  • Event Number

    332350