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