Excel tutorial: Pivot, charts and table design for clear data presentation
- Over 3-hour Excel tutorial for the clear and informative preparation of data
- Pivot table in Excel: How to keep an overview at all times, even with large amounts of data
- Table design: Use functions such as conditional formatting for a better overview
- Excel presentation: Create, for example, a traffic light that switches at different values
- Excel charts: How to set up an informative speedometer chart, among other things
- Many more tips and tricks for working efficiently with Microsoft Excel
All your data can be so beautifully presented and therefore even more informative! Give your tables a design boost with this Excel tutorial - for a better overview and clarity.
44 Videos, 190 minutes
Intro
Excel tutorial: Pivot, charts and table design for clear data presentation - 1 intro
Welcome to the Excel tutorial! Find out briefly and concisely what you can expect here.
Excel tutorial: Pivot, charts and table design for clear data presentation - 1 intro
1 min OpenEvaluations and data overview
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.1 Times with the numeric keypad
How you can still enter times in the numeric keypad, despite the missing colon.
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.2 Evaluating specific cells
Totalize every second or any other line
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.3 Copying formulas automatically
Copying and using a formula
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.4 Mixing text, data and formulas in a cell
Combining different formatting in one cell
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.5 Displaying formulas
Identify cells where there are no fixed values but formulas
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.6 Worksheet in a new Excel file
Copying and moving worksheets to another Excel file
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.7 Day of the week in conditional formatting
Division of a schedule using weekdays with conditional formatting
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.8 Managing conditional formatting
Get an overview of the different conditional formatting of a worksheet
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.9 Highlighting filled cells
We use conditional formatting to select all cells that contain values.
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.10 Fractions in Excel
Calculate and correctly display fractions in Excel
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.11 Swapping columns and rows
Get to know the "Transpose" insertion option.
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.12 Database mask in Excel
Entering data in tables using the mask
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.13 Help for formulas
How to enter formulas using the help function
Excel tutorial: Pivot, charts and table design for clear data presentation - 2.1 Times with the numeric keypad
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.2 Evaluating specific cells
9 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.3 Copying formulas automatically
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.4 Mixing text, data and formulas in a cell
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.5 Displaying formulas
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.6 Worksheet in a new Excel file
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.7 Day of the week in conditional formatting
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.8 Managing conditional formatting
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.9 Highlighting filled cells
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.10 Fractions in Excel
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.11 Swapping columns and rows
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.12 Database mask in Excel
5 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 2.13 Help for formulas
6 min OpenPresentation and print
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.1 Coloring every second row
How to highlight every second row in Excel in color
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.2 Create slanted headings
How to create a heading in an Excel spreadsheet and format it
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.3 Sparklines in Excel
Use sparklines for the graphical evaluation of data.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.4 Tachograph chart in Excel
Display numbers in a special form with the tachodiagram
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.5 Customizing Excel tables visually
Use an Excel spreadsheet design to create the presentation.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.6 Create traffic light function
Let's create a simple traffic light that we can light up differently using numbers.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.7 Print settings on all worksheets
Apply the print settings to other worksheets as well.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.8 Printing multiple worksheets on one page
Save paper by putting several worksheets on one page.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.9 Manual page break when printing
Add page breaks manually.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.10 Excel table on a single page
Put your tables on a single page.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.11 Hide error messages when printing
Errors that are actually suggestions can be easily hidden in Excel.
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.12 Format codes in headers and footers
Insert header and footer elements such as file name, date or page number
Excel tutorial: Pivot, charts and table design for clear data presentation - 3.1 Coloring every second row
6 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.2 Create slanted headings
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.3 Sparklines in Excel
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.4 Tachograph chart in Excel
14 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.5 Customizing Excel tables visually
6 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.6 Create traffic light function
7 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.7 Print settings on all worksheets
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.8 Printing multiple worksheets on one page
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.9 Manual page break when printing
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.10 Excel table on a single page
1 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.11 Hide error messages when printing
1 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 3.12 Format codes in headers and footers
6 min OpenPivot 1x1
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.1 Pivot: basics
Pivot tables can be created very quickly in Excel. In this step-by-step guide, you will learn how to do this.
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.2 Pivot: calculations/field settings
Calculating fields in pivot tables is one of the most powerful features. Here you will learn how we can summarize sales and compare them as a percentage.
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.3 Pivot: Timelines and data slicing
Calculate sales based on time data and only select sales at certain times.
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.4 Pivot: Filtering
Filtering specific data records in pivot tables
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.5 Pivot: Charts
Get to know the pivot charts. Create charts from the pivot template.
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.6 Pivot: Layout
Adjustments to the design and layout of a pivot table
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.7 Pivot: Options
Overview of the options of a pivot table
Excel tutorial: Pivot, charts and table design for clear data presentation - 4.1 Pivot: basics
12 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 4.2 Pivot: calculations/field settings
6 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 4.3 Pivot: Timelines and data slicing
6 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 4.4 Pivot: Filtering
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 4.5 Pivot: Charts
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 4.6 Pivot: Layout
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 4.7 Pivot: Options
3 min OpenTips & Tricks for faster working
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.1 Secret selection
Suggestions as soon as you enter the first letter
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.2 New text lines within a cell
Create line breaks within a cell.
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.3 Lines in cells
Cells can be formatted with different lines.
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.4 Changing the capitalization of text in Excel
Use a function to display all values of a cell in upper or lower case.
Excel tutorial: Pivot, charts and table design for clear data presentation - Convert 5.5 hours into minutes
Simple trick to display hours in minutes.
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.6 Automatically generate ranked lists
Depending on your requirements, you can now number the placement according to the largest or smallest value without changing the original arrangement of the cells.
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.7 Calculating with the status bar
Results appear in the status bar
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.8 Totaling by cell range criteria
Totaling a cell range according to criteria
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.9 Counting by cell range criteria
ZÄHLENWENNS applies criteria to cells in several areas and counts how often all criteria apply.
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.10 Calculate mean value
Use a function to calculate the number in the middle of a number line.
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.11 Important Excel macros for everyday use
Master the most common tasks in Excel with clever macros
Excel tutorial: Pivot, charts and table design for clear data presentation - 5.1 Secret selection
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.2 New text lines within a cell
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.3 Lines in cells
3 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.4 Changing the capitalization of text in Excel
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - Convert 5.5 hours into minutes
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.6 Automatically generate ranked lists
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.7 Calculating with the status bar
2 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.8 Totaling by cell range criteria
7 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.9 Counting by cell range criteria
5 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.10 Calculate mean value
4 min OpenExcel tutorial: Pivot, charts and table design for clear data presentation - 5.11 Important Excel macros for everyday use
11 min OpenYou might also like
With flyer, business card & Co.
Faster results in your tables
Create, set up & optimize online advertising
This saves you time and effort!
Comment now „Excel tutorial: Pivot, charts and table design for clear data presentation“