📆 14-day money-back guarantee | 🔃 Switch courses anytime | 🔒 Secure payment and fast support

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.

  • Learn Excel tailored for procurement and logistics
  • Work smarter with data, reports, and visualizations
  • Strengthen your CV with a diploma
  • Practice with relevant business scenarios
  • Short lessons – flexible format
  • Learn at your own pace, for 12 months
  • Used by companies and universities
Buy this course
Try for free

Try some lessons in this course for free

Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.

No card required!
Learnesy
4.9
Based on 186 reviews
powered by Google
js_loader
Buy this course
Try for free

Try some lessons in this course for free

Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.

No card required!

Some of the things you will learn in this course:

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.

Discover How AI Streamlines Your Work

Learn how to use AI tools to automate tasks, make smarter decisions, and save time in your daily work. Get practical tools and insights to work more efficiently with AI in Excel.

Course Content

Expand All
EXCEL
Chapter Content
0% Complete 0/5 Steps
Navigate with the keyboard
Absolute and Relative Cell References
Copy formulas
Manage your worksheet
Find and Replace
Chapter Content
0% Complete 0/5 Steps
Format table
Sort
Filter
Duplicates
Flash Fill
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
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
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
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
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
Chapter Content
0% Complete 0/3 Steps
Grouping data
Multiple tables
Combine tables with different headers
POWER PIVOT
Chapter Content
0% Complete 0/5 Steps
Get Power Pivot
Get Data
Power Pivot – Parts of the Window
Relationships
Working with Columns
Chapter Content
0% Complete 0/8 Steps
Measures (SUM & SUMX)
The FILTER-Function
Date Functions
SWITCH
Logical Functions
RANKX
CALCULATE
Other DAX Functions
AI
Chapter Content
0% Complete 0/6 Steps
Copilot and ChatGPT
Copilot in Excel
ChatGPT in Excel
Edit and modify files with ChatGPT
ChatGPT as a mentor
Next step

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.

Download product sheet

certificate of course completion Excel for Procurement and Logistic professionals Sarah Anderson It is hereby certified that Sarah Anderson has with diligence and commendable efforts completed Learnesy's online course Excel for Procurement and Logistic professionals

Invest in your knowledge

One course (Excel for Procurement and Logistic professionals)

2 995 kr

VAT will be applied.

Educate yourself further with an online course in Excel, Power BI, or PowerPoint – to name a few.

Invoice

Course package

5 995 kr

VAT will be applied.

Take your career to the next level with our tailored course packages!

All courses

8 995 kr

VAT will be applied.

When you buy All courses, you get one year's unlimited access to the entire range of courses. This includes, among other things, Excel courses and courses in Power BI, PowerPoint and much more.

Invoice Read more
Educational scheme
  • Access to all material 24/7 for 12 months
  • Complete the course at your convenience
  • Repeat freely during the access period
  • Courses that are maintained and updated
  • Personal and digitally shareable diploma per course
  • Schedule and set goals for your learning
  • Save your favorite lessons
  • Ask your questions in our forum
  • Tech Support
  • Track and test your knowledge
  • Admin features for your team
  • LMS integration
  • Discounts for multiple users

Business groups

With our platform, we focus on improving your company's skills through customized course content, flexible learning times, and tracking tools to track and test employee progress. We offer courses in several languages and for different skill levels, as well as the possibility of hybrid training and integration with your company's LMS system. When you feel ready - contact us for a quote.

  • Personal Account manager
  • Personal User Accounts
  • Select courses
  • Quantity discount
  • Statistics
  • Unique login domain
  • Prior knowledge and follow-up test
  • Compare progress with the group

Prices excluding VAT

How Your Learnesy Course Works

At Learnesy, we believe that education should be accessible and straightforward. That’s why we’ve created a platform with you, the user, at the center. Within the platform, you can easily navigate in and between your online courses.

• My Account – here you’ll find your dashboard, where you can access both ongoing and completed courses. Your dashboard is the starting point for your learning journey.
• Get a glimpse of a Learnesy course – from your dashboard, you can easily click through to an ongoing or completed course.
• Favorite and share lessons – found a particularly useful segment or something you want to review again? You can save these by marking them as favorites. You can also share lessons with others who might benefit from them.
• Quizzes and practice exercises – practice makes perfect. Here, you put your theoretical knowledge into action. All quizzes, as well as all course content, can be repeated.
• Congratulations on your course diploma – upon completing a course, you’ll receive a personal, shareable diploma as proof of your new skills.

Have a question? You might find your answer here. If not, don’t hesitate to contact us.

FAQ

What will I learn in this course?

Learn industry-adapted Excel skills for procurement and logistics, including charts, PivotTables, Power Query, and Power Pivot techniques for importing, modeling, and visualizing large datasets.

How is the course structured?

Development began in collaboration with professionals and organizations in procurement and logistics to ensure real-world relevance.

Is there a free trial available?

Yes, you can try select lessons free for 7 days.

Is group or enterprise licensing available?

Absolutely. You can bundle the course into a cost-effective package for teams, just get in touch for a customized offer.

Who can I contact for additional questions?

If you have any further questions about the course, access, or group licensing, feel free to contact us at support@learnesy.com. We’re happy to help.