Language: German

Excel course for controlling and sales: assortment list, units, currency & Co

Office, Business, Marketing & Sales 37 Videos · 2.8 h Video training · English

by René Fürst

One small mistake and the result is wrong. So do the math with René Fürst. In this 2.5-hour Excel course, your Office trainer will show you how to calculate shipping costs, include current exchange rates for currencies, work with large numbers and compare tables. The goal: Avoid unnecessary errors in accounting, secretarial, controlling and sales with the help of Excel functions.

2.5-hour course on Excel with tips and tricks for accounting, controlling and sales
Use the Excel functions to avoid unnecessary errors
Calculate shipping costs based on weight and prices
Units and currencies: including converting units and how to take current exchange rates into account
Make comparisons with VLOOKUP, COMPARE, INDEX and matrix function
Learn how to work efficiently with very large and negative numbers
Particularly useful for creating product and assortment lists, for controlled data entry

Convert units, make comparisons, check data... Take an Excel course that will make your calculations even better!

content

37 Videos, 167 minutes

Intro

1 Videos · 3 minutes

01 Open free of charge

Excel course for controlling and sales: Assortment list, units, currency & Co - 1 Intro

Welcome to the Excel course.

50 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 1 Intro

3 min Open

50 MB

Data entry and comparisons

8 Videos · 49 minutes

02 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.1 Control data entry more efficiently

How you can enter data more easily side by side or on top of each other.

18 MB

03 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.2 Data validation for cells

Defining content for specific cells

19 MB

04 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.3 Keyboard mode "Roles"

Learn the behavior of the role mode in Excel.

42 MB

05 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.4 Compare contents of different worksheets

Highlighting and comparing the content of different worksheets

29 MB

06 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.5 Preventing duplicate values

Prevent the entry of duplicate values

9 MB

07 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.6 Automatic subtotals

Generating a subtotal with the partial result function

10 MB

08 Open

Excel course for controlling and sales: assortment list, units, currency, etc. - 2.7 Comparing two Excel spreadsheets

Synchronizing two worksheets with Excel

8 MB

09 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.8 Comparing values in a reference table

Is a value included in the reference table or not?

8 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.1 Control data entry more efficiently

8 min Open

18 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.2 Data validation for cells

9 min Open

19 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.3 Keyboard mode "Roles"

4 min Open

42 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.4 Compare contents of different worksheets

13 min Open

29 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.5 Preventing duplicate values

3 min Open

9 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.6 Automatic subtotals

4 min Open

10 MB

Excel course for controlling and sales: assortment list, units, currency, etc. - 2.7 Comparing two Excel spreadsheets

4 min Open

8 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 2.8 Comparing values in a reference table

4 min Open

8 MB

Products & Commerce

12 Videos · 44 minutes

10 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.1 Cell names

Assign a name to individual cells or entire areas

9 MB

11 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.2 Reduce images

Reduce the size of Excel files by compressing the images

7 MB

12 Open

Excel course for controlling and sales: product range list, units, currency & co - 3.3 Importing current exchange rates directly into Excel

Exchange rates can be imported using the Excel Web Query

19 MB

13 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.4 Calculate shipping costs

Calculate shipping costs according to defined weight categories

6 MB

14 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.5 Assigning single and multiple number forms

Create singular and plural for user-defined formats

8 MB

15 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.6 Rounding up commercially

Rounded values are important if you do not want to see a result up to the last decimal place

14 MB

16 Open

Excel course for controlling and sales: Assortment list, units, currency, etc. - 3.7 Highlighting duplicate values

Display of duplicate values

4 MB

17 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.8 Using units of measurement

Define different cell formatting for units of measurement such as weight

13 MB

18 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.9 Square meters and cubic meters

Predefined formats for area and volume units

5 MB

19 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.10 Color code formatting of cells

Format cells with a specific color code

5 MB

20 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.11 Converting units of measurement

How many meters are actually a nautical mile etc. - Excel automatically takes over the conversion factor

7 MB

21 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.12 Formatting currencies left- and right-aligned

Customize visual display of currency symbols and values

6 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.1 Cell names

4 min Open

9 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.2 Reduce images

3 min Open

7 MB

Excel course for controlling and sales: product range list, units, currency & co - 3.3 Importing current exchange rates directly into Excel

6 min Open

19 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.4 Calculate shipping costs

3 min Open

6 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.5 Assigning single and multiple number forms

4 min Open

8 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.6 Rounding up commercially

6 min Open

14 MB

Excel course for controlling and sales: Assortment list, units, currency, etc. - 3.7 Highlighting duplicate values

2 min Open

4 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.8 Using units of measurement

6 min Open

13 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.9 Square meters and cubic meters

2 min Open

5 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.10 Color code formatting of cells

2 min Open

5 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.11 Converting units of measurement

3 min Open

7 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 3.12 Formatting currencies left- and right-aligned

3 min Open

6 MB

Working with numbers, index, VLOOKUP, and comparison

11 Videos · 51 minutes

22 Open

Excel course for controlling and sales: Assortment list, units, currency & co - 4.1 Formatting large numbers

Round cells with the largest numbers to the nearest thousand with a custom Excel format

11 MB

23 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.2 Display numbers with leading zeros

Enter numbers with leading zeros in cells without them disappearing

5 MB

24 Open

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.3 VLOOKUP across multiple columns

Instead of searching in just one column, it is possible to search across several columns.

32 MB

25 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.4 Break down figures into individual parts

With long EAN codes or article numbers, you often only need part of the number.

9 MB

26 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.5 Outputting the last figures of a large number

Display only the last digits of a large number.

3 MB

27 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.6 Sequence of a list

Determine the order without jumbling up the table

10 MB

28 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.7 Show or hide zero values

Several options for showing or hiding zero values

8 MB

29 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.8 Determine highest and lowest values

Determine the highest or lowest value in a list

3 MB

30 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.9 Replacing formulas with numerical values

When passing on an Excel document, it can be useful to replace the formulas with existing values.

6 MB

31 Open

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.10 REFERENCE or INDEX/ COMPARISON

Options for searching for data in a list and outputting the result

16 MB

32 Open

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.11 Extending the SVERWEIS search function

Using SVERWEIS with different methods

9 MB

Excel course for controlling and sales: Assortment list, units, currency & co - 4.1 Formatting large numbers

5 min Open

11 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.2 Display numbers with leading zeros

3 min Open

5 MB

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.3 VLOOKUP across multiple columns

13 min Open

32 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.4 Break down figures into individual parts

5 min Open

9 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.5 Outputting the last figures of a large number

1 min Open

3 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.6 Sequence of a list

5 min Open

10 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.7 Show or hide zero values

4 min Open

8 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.8 Determine highest and lowest values

1 min Open

3 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 4.9 Replacing formulas with numerical values

3 min Open

6 MB

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.10 REFERENCE or INDEX/ COMPARISON

7 min Open

16 MB

Excel course for controlling and sales: Assortment list, units, currency, etc. - 4.11 Extending the SVERWEIS search function

4 min Open

9 MB

Tips & Tricks: Work faster with Excel

5 Videos · 19 minutes

33 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.1 Defining names for formulas

Instead of long formulas, we can define names for formulas that we can use.

15 MB

34 Open

Excel course for controlling and sales: Assortment list, units, currency, etc. - 5.2 Adding a new quick tool

With the quick tool, frequently required functions can be implemented with a single click.

8 MB

35 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.3 Monitoring window

Monitor the changes to an area

9 MB

36 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.4 Protect cells from being overwritten

Protect important cells from being overwritten without applying sheet protection

7 MB

37 Open

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.5 Highlighting missed deadlines

Highlight delayed delivery dates

8 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.1 Defining names for formulas

6 min Open

15 MB

Excel course for controlling and sales: Assortment list, units, currency, etc. - 5.2 Adding a new quick tool

3 min Open

8 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.3 Monitoring window

3 min Open

9 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.4 Protect cells from being overwritten

3 min Open

7 MB

Excel course for controlling and sales: Assortment list, units, currency & Co - 5.5 Highlighting missed deadlines

4 min Open

8 MB

Details of the content

Use Excel even more effectively in controlling and sales
Do you juggle all kinds of cells, columns and rows in your job? Would you like to work with Excel in a more targeted and secure way? Then improve your application knowledge with this Excel course from trainer René Fürst .

The contents of the course: from units, currencies, comparisons and shipping costs

The 2.5-hour Excel course is divided into 37 lessons. The focus is on the use of Excel in the areas of accounting, controlling and sales. Your trainer will provide you with numerous tips and tricks, including how to

Calculating shipping costs, rounding commercially, highlighting missed deadlines
Using units: Converting units of measurement, using predefined formats
Currencies : include current exchange rates, format currencies left- and right-aligned
How to work with VLOOKUP, COMPARE and INDEX
Compare different worksheets, Excel tables and values in a reference table
Learn how to prevent or highlight duplicate values
Automatically display subtotals, protect cells from being overwritten
How to use the Scroll keyboard mode and define content for specific cells
Assign a name to cells or entire ranges, store color codes for cells
Determine maximum and minimum values, format large numbers, replace formulas with numbers

Tips and tricks for working efficiently with Excel

The course is aimed at all those who want to go beyond the basics of Excel and use the spreadsheet program more efficiently. The content is particularly useful for professionals working in secretarial, controlling, accounting and sales roles. Application scenarios for the tips and tricks can be found, for example, in the creation of product and assortment lists or in the calculation of shipping costs.

For example, René Fürst explains how to calculate shipping costs based on weight or price and how to include free shipping above a certain value. You will learn how to break down long EAN codes or article numbers so that you can only work with the really relevant number parts. You will learn how to convert units and use current exchange rates for currencies.

Concrete help for specific challenges in your everyday work - work even more confidently with Microsoft Excel in the future!

Note

Usable with: Microsoft Excel
Licence: private and commercial Rights of use

Created with love by

René Fürst

Passionate IT consultant! I have been working in IT for over 16 years and have been confronted with a wide variety of tasks. My focus is on server system administration and user software. Course topics that I cover include: System Administration, Office Software, User Software and Server Architecture. I would like to pass on my knowledge from all areas of my professional life, in which I have been able to gain experience over several years.

Products