Excel course for Controlling & Sales

Language: German

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

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!

Details

Usable with:
content: 3 h Video training
Licence: private and commercial Rights of use
Bonus: including working material

Intro

free of charge

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

Welcome to the Excel course.

download project file

Data entry and comparisons.

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.

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

Defining content for specific cells

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.

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

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

Prevent the entry of duplicate values

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

Generating a subtotal with the partial result function

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

Synchronizing two worksheets with Excel

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?

Products & Commerce

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

Assign a name to individual cells or entire areas

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

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

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

Calculate shipping costs according to defined weight categories

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

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

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

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

Display of duplicate values

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

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

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

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

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

Working with numbers, index, VLOOKUP, and comparison.

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

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

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.

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.

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.

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

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

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

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.

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

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

Using SVERWEIS with different methods

Tips & Tricks: Working faster with Excel

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.

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.

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

Monitor the changes to an area

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

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

Highlight delayed delivery dates

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!