Detailed Course Outline
Microsoft Excel 2019 for Beginners
1 Get to know Excel
- 1.1 What is Excel
- 1.2 Excel starten
- 1.3 Enter and calculate data
- 1.4 Format data
- 1.5 Create diagram
- 1.6 Print table and diagram
- 1.7 Excel legs
2 Basic techniques
- 2.1 Excel windows at a glance
- 2.2 Using the ribbon
- 2.3 Field What would you like to do? use
- 2.4 Entering data in the spreadsheet
- 2.5 Entering date and time information
- 2.6 Modify and delete cell contents
- 2.7 Changing the column width or row height
- 2.8 Selecting cells
- 2.9 Undo actions
- 2.10 Print worksheets
- 2.11 Saving and closing workbooks
- 2.12 Creating and opening workbooks
- 2.13 Exercise
3 Working with formulas
- 3.1 Structure and input of formulas
- 3.2 SUM function
- 3.3 Inserting cell references by pointing in formulas
- 3.4 Edit formulas
- 3.5 Exercise
4 Format cells
- 4.1 Basic knowledge of formatting
- 4.2 Defining fonts and font properties
- 4.3 Aligning, indenting and rotating cell contents
- 4.4 Line breaks and merged cells
- 4.5 Using frames and lines
- 4.6 Assign fill color or pattern
- 4.7 Formatting numbers
- 4.8 Assign date and time formats
- 4.9 Formatting tips
- 4.10 Exercise
5 Fill, Copy and Move
- 5.1 Repeat and auto complete
- 5.2 Moving and copying with the mouse
- 5.3 Moving and copying using the clipboard
- 5.4 Using the fill-in function
- 5.5 Working with the flash preview
- 5.6 Relative, absolute and mixed references
- 5.7 Exercises
6 Edit table view and structure
- 6.1 Hiding or showing columns or rows
- 6.2 Inserting or deleting columns or rows
- 6.3 Insert or delete cells
- 6.4 Exercise
7 Working with simple functions
- 7.1 Structure and input of functions
- 7.2 Selection of simple functions
- 7.3 Calculating with simple functions
- 7.4 Using the function library
- 7.5 Exercise
8 Create and design diagrams
- 8.1 Basic knowledge of diagrams
- 8.2 Create recommended diagrams
- 8.3 Creating a diagram with a specific diagram type
- 8.4 Swapping the arrangement of the diagram data
- 8.5 Changing the size and position of a diagram object
- 8.6 Move diagram to a diagram sheet
- 8.7 Designing a diagram with a quick layout
- 8.8 Using chart format templates
- 8.9 Exercise
9 Print tables with individual settings
- 9.1 Checking print pages with the print preview
- 9.2 Making basic page layout settings
- 9.3 Set advanced print settings
- 9.4 Defining page breaks
- 9.5 Headers and footers
- 9.6 Defining column and row titles
- 9.7 Exercise
10 Use workbooks effectively
- 10.1 Working with workbooks
- 10.2 Moving and copying worksheets
- 10.3 Defining the display of the worksheets
- 10.4 Cell references to other spreadsheets
- 10.5 Cell references to other workbooks
- 10.6 Using links
- 10.7 Adding comments to tables
- 10.8 Protect workbooks
- 10.9 Protecting worksheets and cells
- 10.10 Exercises
11 Sort and filter data
- 11.1 Sorting tables
- 11.2 Sorting tables by formatting
- 11.3 Basic knowledge AutoFilter
- 11.4 Using predefined search criteria in AutoFilter
- 11.5 Using the AutoFilter list
- 11.6 Filter by formatting
- 11.7 Exercise
Microsoft Excel 2019 Advanced
1 Names
- 1.1 Basic knowledge of names
- 1.2 Set names
- 1.3 Insert names in formulas
- 1.4 Useful techniques when using names
- 1.5 Manage names
- 1.6 Exercise
2 Using special functions
- 2.1 Creating nested functions
- 2.2 Working with the What-If Function
- 2.3 Using Nested What-If Functions
- 2.4 Use of the WENNS function
- 2.5 SVERWEIS und WVERWEIS
- 2.6 Useful mathematical functions
- 2.7 Exercises
3 Perform time calculations
- 3.1 Basic knowledge of time calculations
- 3.2 Working with date and time functions
- 3.3 Practical applications
- 3.4 Exercise
4 Edit diagrams individually
- 4.1 Basic knowledge of diagram editing
- 4.2 Selecting and editing diagram elements
- 4.3 Formatting diagram elements
- 4.4 Labeling diagrams
- 4.5 Labeling data series or data points
- 4.6 Change content/formatting of labels
- 4.7 Changing the diagram display or structure
- 4.8 Printing diagrams
- 4.9 Exercise
5 Working professionally with diagrams
- 5.1 Formatting the label of the value axis
- 5.2 Changing the division of the value axis
- 5.3 Format category axis
- 5.4 Show secondary axis
- 5.5 Show trend lines
- 5.6 Display error indicators for data series
- 5.7 Diagram templates
- 5.8 Exercise
6 Combine and consolidate data
- 6.1 Combining data
- 6.2 Basic knowledge of table consolidation
- 6.3 Consolidate data with formulas
- 6.4 Consolidate data by position
- 6.5 Consolidate data by heading
- 6.6 Edit consolidation results
- 6.7 Exercise
7 Create Pivot Tables
- 7.1 Basic knowledge of pivot tables
- 7.2 Create recommended pivot table from Excel data
- 7.3 Creating an individual pivot table from Excel data
- 7.4 Changing calculations in the value range
- 7.5 Using predefined report layouts and formats
- 7.6 Filtering data of a pivot table
- 7.7 Filtering Pivot Table Data Using Timelines
- 7.8 Create Pivot Table from External Data Source
- 7.9 Exercise
8 Import or export data
- 8.1 Access-Daten importieren
- 8.2 Import text files
- 8.3 Importing other foreign formats
- 8.4 Exporting Excel data
- 8.5 Exercise
9 Creating Queries with Power Query
- 9.1 Basic knowledge Power Query
- 9.2 Creating Queries with Power Query
- 9.3 Update or delete queries
- 9.4 Edit queries
- 9.5 Editing Query Criteria in the Power Query Editor
- 9.6 Create/add queries from multiple database tables
- 9.7 Exercise
10 Special design options
- 10.1 Basic knowledge of conditional formatting
- 10.2 Formatting cells depending on conditions
- 10.3 Displaying value distribution with conditional formatting
- 10.4 Basic knowledge of format templates
- 10.5 Working with style sheets
- 10.6 User-defined number formats
- 10.7 Formatcodes
- 10.8 Data check during input
- 10.9 Exercises
11 Table areas
- 11.1 Basic knowledge of table areas
- 11.2 Converting lists into table areas
- 11.3 Editing table areas
- 11.4 Sorting and evaluating table areas
- 11.5 Filtering table areas with data sections
- 11.6 Exercise
12 Set up Excel individually
- 12.1 Customizing the toolbar for access
- 12.2 Customizing the ribbon
- 12.3 Set other default working folder
- 12.4 Using document properties
- 12.5 Working with custom views
- 12.6 Exercise