DE EN
Log in 7 days free
Excel course for controlling and sales: assortment list, units, currency & Co Language: German

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

Office, Business, Marketing & Sales · 37 Videos · 2.8 h Video training · German René Fürst 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 Video · 3 minutes
01 Open free of charge

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

3 min

Welcome to the Excel course.

50 MB To the text tutorial: Using Excel for controlling and sales

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

8 min

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

18 MB To the text tutorial: Data entry techniques in Excel
03 Open

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

9 min

Defining content for specific cells

19 MB To the text tutorial: Excel data validation for cells
04 Open

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

4 min

Learn the behavior of the role mode in Excel.

42 MB To the text tutorial: Use roll mode in Excel
05 Open

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

13 min

Highlighting and comparing the content of different worksheets

29 MB To the text tutorial: Compare and merge Excel worksheets
06 Open

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

3 min

Prevent the entry of duplicate values

9 MB To the text tutorial: Prevent duplicate values in Excel
07 Open

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

4 min

Generating a subtotal with the partial result function

10 MB To the text tutorial: Automatic subtotals in Excel for controlling and sales
08 Open

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

4 min

Synchronizing two worksheets with Excel

8 MB To the text tutorial: Comparison of two Excel tables
09 Open

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

4 min

Is a value included in the reference table or not?

8 MB To the text tutorial: Comparing values in Excel

Products & Commerce

12 Videos · 44 minutes
10 Open

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

4 min

Assign a name to individual cells or entire areas

9 MB To the text tutorial: Use cell names in Excel for better clarity
11 Open

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

3 min

Reduce the size of Excel files by compressing the images

7 MB To the text tutorial: Compress images in Excel for reduced storage consumption
12 Open

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

6 min

Exchange rates can be imported using the Excel Web Query

19 MB To the text tutorial: Import exchange rates in Excel
13 Open

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

3 min

Calculate shipping costs according to defined weight categories

6 MB To the text tutorial: Calculate shipping costs in Excel - use VLOOKUP
14 Open

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

4 min

Create singular and plural for user-defined formats

8 MB To the text tutorial: Excel course: Defining singular and plural formats
15 Open

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

6 min

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

14 MB To the text tutorial: Commercial rounding in Excel made easy
16 Open

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

2 min

Display of duplicate values

4 MB To the text tutorial: Detect and highlight duplicate values in Excel
17 Open

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

6 min

Define different cell formatting for units of measurement such as weight

13 MB To the text tutorial: Use units of measurement correctly in Excel
18 Open

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

2 min

Predefined formats for area and volume units

5 MB To the text tutorial: Excel formatting for square meters and cubic meters
19 Open

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

2 min

Format cells with a specific color code

5 MB To the text tutorial: Format cells in Excel effectively with color coding
20 Open

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

3 min

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

7 MB To the text tutorial: Converting units of measurement in Excel: Easy guide
21 Open

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

3 min

Customize visual display of currency symbols and values

6 MB To the text tutorial: Optimize Excel currency formatting course

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

5 min

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

11 MB To the text tutorial: Format large numbers effectively in Excel
23 Open

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

3 min

Enter numbers with leading zeros in cells without them disappearing

5 MB To the text tutorial: Add leading zeros to Excel numbers
24 Open

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

13 min

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

32 MB To the text tutorial: Effectively using VLOOKUP across multiple columns in Excel
25 Open

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

5 min

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

9 MB To the text tutorial: Breaking down numbers into individual components with Excel
26 Open

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

1 min

Display only the last digits of a large number.

3 MB To the text tutorial: Display last digits or characters of a cell in Excel
27 Open

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

5 min

Determine the order without jumbling up the table

10 MB To the text tutorial: Determine sales ranks efficiently - an Excel guide
28 Open

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

4 min

Several options for showing or hiding zero values

8 MB To the text tutorial: Hide zero values in Excel
29 Open

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

1 min

Determine the highest or lowest value in a list

3 MB To the text tutorial: Determine the highest and lowest values in Excel
30 Open

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

3 min

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

6 MB To the text tutorial: Replace formulas in Excel with values
31 Open

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

7 min

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

16 MB To the text tutorial: Use VLOOKUP and INDEX/MATCH in controlling
32 Open

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

4 min

Using SVERWEIS with different methods

9 MB To the text tutorial: Optimization of VLOOKUP in Excel with wildcards

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

6 min

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

15 MB To the text tutorial: Use of names for Excel formulas
34 Open

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

3 min

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

8 MB To the text tutorial: Use of Excel quick tools
35 Open

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

3 min

Monitor the changes to an area

9 MB To the text tutorial: Monitoring changes in Excel using the watch window
36 Open

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

3 min

Protect important cells from being overwritten without applying sheet protection

7 MB To the text tutorial: Protecting Excel cells - simple and effective
37 Open

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

4 min

Highlight delayed delivery dates

8 MB To the text tutorial: Excel course: Highlight late delivery dates in color
Comments (0)

Comment now „Excel course for controlling and sales: assortment list, units, currency & Co“

Other users are also interested

You might also like

Printable Advent calendar: little doors, numbers, vouchers, boxes
new
−40% International price
Go to content  To Printable Advent Calendar – Kit with 7 Template Sets
Printable Advent Calendar – Kit with 7 Template Sets

7 template sets in 4 design lines – A4 PDF with crop marks, plotter SVG, JPG/PNG, PPTX, DOCX and XLSX

200 contents
Sticker & Pop – 100 Photoshop Styles for Promotional Graphics
−40% International price
Go to content  To Sticker & Pop: Photoshop Styles for Promotional Graphics
Sticker & Pop: Photoshop Styles for Promotional Graphics

5 sets of 20 layer styles each · ASL and editable PSD samples

100 contents
Briefing templates for agencies: 5 fillable PDF questionnaires
−40% International price
Go to content  To Briefing Templates for Agencies: 5 Fillable PDFs
Briefing Templates for Agencies: 5 Fillable PDFs

5 sheets of 4 A4 pages each as a fillable PDF – with filling examples and a guide for Acrobat and InDesign

5 contents
The big infographic bundle for technology & B2B
−40% International price
Go to content  To Infographic templates & diagrams for technology & B2B | TutKit
Infographic templates & diagrams for technology & B2B | TutKit

48 editable chart templates in SVG, PDF, EPS, PNG, and PowerPoint – in under a minute in the customer’s corporate identity

48 contents