MS Excel PivotTable Vlookup Xlookup Course

MS Excel PivotTable Vlookup Xlookup Course

Number of lessons 3

Time spent on a lesson 1h

Number of lessons: 3 lessons

Lesson Duration: 1 hour

Course Format։ Face-to-face learning

Course Fee։ 25.000 AMD (Individual)

Venue։ Citadel Business Center, 105/1 Teryan, Yerevan

Who is the course intended for?

MS Excel PivotTable Vlookup Xlookup course is designed for accountants, economists, analysts, marketers, as well as those who want to deepen their knowledge of PivotTable tool and Vlookup, Xlookup formulas. At the end of the course, the participating student will gain in-depth knowledge, that will allow him/her to automate his/her calculations.

Course benefits

• The course includes practical tasks, theoretical materials, video lessons,
• Advanced level training,
• Free consultation on your work files,
• Course participation: online and offline formats,
• There is no age restriction and no prior knowledge is required for the participation in the course. 

Course Content

Lesson 1.

• Data analysis Pivot Table

Lesson 2.

• Data analysis Pivot Table
• Search and hyperlink functions: Vlookup, Xlookup, Match

Lesson 3.

• Data analysis Pivot Table
• Lists Comparison
• Тesting
• Summary