Discover what you can learn.

With video courses for work, study and leisure.

Available everywhere
Learn on PC, tablet or smartphone.

Pace

Own pace,
replay as often as you want.

Quick learning success,
instructional videos, exercises and quizzes get you closer to your goal.

Microsoft Excel: Profit and Loss Calculations (EN)

By 365 Careers

In this course you will learn about the Profit and Loss Calculations in Microsoft Excel 2016.

This includes:

Using Vlookup
Creating the Structure of an P&L Statement
Calculating Year-on-Year-Growth

Content

Introduction to the Profit and Loss Calculation	00:51
Profit and Loss Calculation: Case Study	01:06
Profit and Loss Calculation: Data of the Case Study	02:42
Profit and Loss Calculation: Create a Clear Structure for the Case Study	02:16
Profit and Loss Calculation: Codes for the Case Study	01:59
Profit and Loss Calculation: Databases for the Case Study	01:58
Using Vlookup in Order to Transfer Data	05:29
Applying SUMIF in Order to Populate the Database with Numbers	04:06
Demonstrating How Index and Match Can Successfully Replace VLOOKUP	03:51
Mapping the Items Within a Database	02:16
Mapping Exercise in the Data Sheet	01:41
Creating the Structure of the Profit and Loss Statement	02:21
Formatting Excel Sheets	03:17
Populating the Profit and Loss Sheet with Figures	02:47
Finding Mistakes	02:14
Calculating Year on Year Growth and Percentage Incidence	03:08

Details

Included lectures: 16
Duration: 0:42 h
Available documents: 29

These courses may be of interest to you

Medicine Flat Rate

Several lecturers

(10009)

~~€1,275.47 per month~~ €49.99 per month

You save 96 %

Microsoft Excel 2016 (EN)

365 Careers

(1)

~~€27.73 per month~~ €14.99 per month

You save 46 %

Authors of course Microsoft Excel: Profit and Loss Calculations (EN)

365 Careers

365 Careers specializes in online courses in Finance, Management, Data Science and other fields. The company's courses produced have been taken by more than 400,000 students across 210 countries.

Customer reviews

(1)
5,0 of 5 stars

5 Stars		5
4 Stars		0
3 Stars		0
2 Stars		0
1 Star		0