CANCELLED - CANCELLED - Import and Presentation of Data in Excel - Conducted in English

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.

The seminar is for Windows PC users - NOT Mac. You must bring a laptop with Microsoft Excel 2016, 2013 or 2010 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.

Seminar Outline

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

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

Email
Remember to state your email in connection with the registration. Your email will be given to Jelgren Consult. Your email will only be used in connection with the transmission of educational material.

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

Seminar Provider
Jelgren Consult

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


Information

  • When

    4. jun. 2019 17:00 - 21:30

  • Where

    Comwell Aarhus, Værkmestergade 2, 8000 Aarhus C

  • Registration Deadline

    1. jun. 2019 - 23:59

  • Organizer

    IEF-Fonden

  • Available Seats

    18

  • Event Number

    330222