Entdecken Sie, was
Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Überall verfügbar
Lernen Sie am PC oder mobil auf Tablet oder Smartphone.

Tempo

Eigenes Lerntempo
Wiederholen Sie, sooft Sie wollen.

Schneller Lernerfolg
Lernvideos, Übungen und Quizfragen bringen Sie ans Ziel.

Microsoft Excel: Profit and Loss Calculations (EN)

Von 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

Inhalte

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

Enthaltene Vorträge: 16
Laufzeit: 0:42 h
Enthaltene Lernmaterialien: 29

Diese Kurse könnten Sie interessieren

Medicine Flat Rate

Diverse Dozenten

(10168)

~~1.284,37 € mtl.~~ 49,99 € mtl.

Sie sparen 96 %

Microsoft Excel 2016 (EN)

365 Careers

(1)

~~27,73 € mtl.~~ 14,99 € mtl.

Sie sparen 46 %

Dozenten des Kurses 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.

Rezensionen

(1)
5,0 von 5 Sternen

5 Sterne		5
4 Sterne		0
3 Sterne		0
2 Sterne		0
1 Stern		0