Excel for professionals working within procurement and logisticians
In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those who work in the field of procurement and logistics. After you complete the course, you will be able to manage and transform data sources, as well as model and visualize big data.
Some of the things you will learn in this course:
Excel Basics
Learn the menu system and keyboard shortcuts for efficient navigation. Once the basics are in place, you’ll feel comfortable using the program and won’t need to ask colleagues or Google for help!
Functions and Pivot Tables
Functions may initially feel quite alien, but after going through this course you will be able to work with many useful functions such as VLOOKUP, IF, and SUMIF. You will also learn how to work with PivotTables, which will let you analyse all kinds of data.
Power Query
Power Query, or Get and Transform, is Excel’s data management tool, which is used to import, process, and combine data, among many other things.
Power Pivot
Power Pivot is an Excel add-in. With Power Pivot and DAX, you can model and visualise big data as well as easily and efficiently create analyses to gain important insights.
Course Content
More about the course
In our online excel course for Purchasing & Logistics, you will learn the basic functionalities of Excel. You will learn how to create a chart, make a table, add data, and freeze cells. We will then gradually move towards more advanced use, where you will learn more about formula management, Power Query, Power Pivot as well as PivotTables.