en

At the request of many employees, we are launching two Excel webinars with functions that a lot of people have to use on the job but are not very easy to master.

Excel: Vlookup & Pivot tables – webinar

• List vs Table
• Functions
• VLOOKUP()
• COUNTIF() and SUMIFS()
• IF() and IFS()
• Pivot table

Minimum requirements to be able to participate:

• Familiar with standard functions such as SOM(), AVERAGE(), MAX(),…
• Familiar with absolute and relative references
• =$A$1
• =\$A1
• English desktop version (preferably), not the online version & worked with Excel 2016 of later version

Excel: PowerQuery – webinar

• PowerQuery
• Get and Transform Data
• Queries & Connections

Minimum requirements to be able to participate:

• Very familiar with pivot tables
• Worked with Excel 2016 or later version

Details

Language: Dutch
Excel Vlookup & Pivot tables – October 8, from 17:30 to 19:00
Excel PowerQueries – October 15, from 17:30 to 19:00