Tackle 2024 with new knowledge – take advantage of Learnesys’ fall campaign on the All Courses package. Read more here.
Back to all courses
This course is also available in: Svenska Svenska
Excel for Procurement and Logistic professionals

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.

Take this course
Learnesy
Learnesy
4.9
Based on 138 reviews
powered by Google
js_loader
What you will learn Course contents More about the course

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

Expand All
EXCEL
Excel’s Basic Functionality 6 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/6 Steps
Navigate with the keyboard
Absolute and Relative Cell References
Copy formulas
Freeze panes
Grouping rows and columns
Find and Replace
Tables and Databases 5 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/5 Steps
Format table
Sort
Filter
Duplicates
Flash Fill
Useful Functions 13 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/13 Steps
The IF-function
VLOOKUP
HLOOKUP
Learn the tricks for Date and Time
Extract characters with LEFT, RIGHT and MID
Use MATCH, INDEX, CHOOSE to find values in a list
Use INDEX/MATCH to lookup values in a two-dimensional range
Identify the n:th largest/smallest number with LARGE/SMALL
IFerror
SUMPRODUCT sums the product of a range of cells
Count cells based on a criteria with COUNTIF
Count cells based on multiple criteria with COUNTIFS
Use ROUNDUP/ROUNDDOWN to round numbers
Harness the Pivot Table 7 Lessons
Expand
Chapter Content
0% Complete 0/7 Steps
Using a Table for the Pivot Table
Format Numbers in the Pivot Table
Manage Totals
Manage Subtotals
Renaming Fields
Filtering an Entire Pivot Table
Adding a Calculated Field
Slicers and Charts for Pivot Tables 5 Lessons
Expand
Chapter Content
0% Complete 0/5 Steps
Using Slicers in the Pivot Table
Slicer Options
Create a Pivot Chart
Change the Chart Type
Filter the Pivot Chart
POWER QUERY
Power Query – Get Data 4 Lessons
Expand
Chapter Content
0% Complete 0/4 Steps
Get Data
Get data from a different Excel file
Load as a Connection
Get data from Web page
Power Query – Basics 7 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/7 Steps
Fill up and down
Split by Delimiter
Custom and Conditional columns
Formulas and Functions in Power Query
IF Functions
IF & AND formulas
VLOOKUP in Power Query
Power Query – Manage Data 3 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/3 Steps
Grouping data
Multiple tables
Combine tables with different headers
POWER PIVOT
Power Pivot – Basics 5 Lessons
Expand
Chapter Content
0% Complete 0/5 Steps
Get Power Pivot
Get Data
Power Pivot – Parts of the Window
Relationships
Working with Columns
DAX 8 Lessons | 1 Quiz
Expand
Chapter Content
0% Complete 0/8 Steps
Measures (SUM & SUMX)
FILTER
Date Functions
SWITCH
Logical Functions
RANKX
CALCULATE
Other DAX Functions

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 as well as Pivot Tables.

Choose what suits you best:

Excel for Procurement and Logistic professionals

249 kr / month Billed yearly. VAT will be applied.
  • Choose the course that suits your needs
  • Access to all material 24/7 for 12 months
  • Complete the course at your convenience
  • Repeat freely throughout the access period
  • The course is maintained and updated
  • Personal and digitally shareable diploma
  • Save your favorite lessons
  • Contact us and we will help you choose the right one!
Take this course
Invoice
Pay within 30 days

All courses

Campaign until 31/12-2023
599 kr 499 kr / month
Billed yearly. VAT will be applied.
  • Campaign: gain access until 2024-12-31
  • Access to the entire course catalog
  • Access 24/7 for 12 months
  • Complete the courses at your convenience
  • Repeat freely throughout the access period
  • Courses that are maintained and updated
  • Personal and digitally shareable diploma by course
  • Save your favorite lessons
  • Take full courses or see only the lessons you need
  • Contact us and we will help you get started today!
Take all courses
Invoice
Pay within 30 days

For teams

Offer
  • Personal Account Manager
  • Personal account for all users
  • Choose the courses that suits your needs
  • Multi-user discounts
  • Optional Kickoff at startup
  • Statistics via Data Insight
  • Technical support
  • Unique login domain
Contact for demo / quote

Prices excluding VAT