E365KFLFast LaneFL-E365K1.0<h5>Microsoft Excel 365 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 365 for advanced users</h5><ul> <li>1 Names</li><li>2 Structure tables</li><li>3 Link formatting to conditions</li><li>4 Monitor formulas and cell contents</li><li>5 Special filters</li><li>6 Excel databases</li><li>7 Combine and consolidate data</li><li>8 Create Pivot Tables</li><li>9 Customize Pivot Tables</li><li>10 Trend analyses, data tables, target value search</li><li>11 Solver</li><li>12 scenarios</li><li>13 Matrices</li><li>14 Different diagram types</li><li>15 Working professionally with diagrams</li><li>16 Design tables with illustrations</li><li>17 Importing or exporting data</li><li>18 Creating Queries with Power Query</li><li>19 Working in a team</li></ul><h5>Microsoft Excel 365 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 365 for advanced users</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></ul> <h5> 2 Structure tables</h5><ul> <li>2.1 Create outlines</li><li>2.2 Working with structured tables</li><li>2.3 Remove outlines</li><li>2.4 Working with partial results</li><li>2.5 Exercises</li></ul><h5> 3 Link formatting to conditions</h5><ul> <li>3.1 Individual rules for conditional formatting</li><li>3.2 Displaying value distribution with graphical elements</li><li>3.3 Formatting cells depending on conditions</li><li>3.4 Display and edit rules</li><li>3.5 Working with multiple rules</li><li>3.6 Exercise</li></ul><h5> 4 Monitor formulas and cell contents</h5><ul> <li>4.1 Check formulas for errors</li><li>4.2 Monitor cell contents</li><li>4.3 Exercise</li></ul> <h5> 5 Special filters</h5><ul> <li>5.1 Basic knowledge of special filters</li><li>5.2 Search criteria for the special filter</li><li>5.3 Using special filters</li><li>5.4 Exercise</li></ul><h5> 6 Excel databases</h5><ul> <li>6.1 Basic knowledge of Excel databases</li><li>6.2 Remove duplicates</li><li>6.3 Using database functions</li><li>6.4 Exercise</li></ul><h5> 7 Combine and consolidate data</h5><ul> <li>7.1 Combining data</li><li>7.2 Basic knowledge of table consolidation</li><li>7.3 Consolidate data with formulas</li><li>7.4 Consolidate data by position</li><li>7.5 Consolidate data by heading</li><li>7.6 Edit consolidation results</li><li>7.7 Exercise</li></ul><h5> 8 Create Pivot Tables</h5><ul> <li>8.1 Basic knowledge of pivot tables</li><li>8.2 Create recommended pivot table from Excel data</li><li>8.3 Creating an individual pivot table from Excel data</li><li>8.4 Changing calculations in the value range</li><li>8.5 Using predefined report layouts and formats</li><li>8.6 Filtering data of a pivot table</li><li>8.7 Filtering Pivot Table Data Using Timelines</li><li>8.8 Create pivot table from external data source</li><li>8.9 Exercise</li></ul><h5> 9 Customize Pivot Tables</h5><ul> <li>9.1 Changing the layout of a pivot table</li><li>9.2 Grouping data of a pivot table individually</li><li>9.3 Using special display options</li><li>9.4 Using calculated fields and elements</li><li>9.5 Additional partial results</li><li>9.6 PIVOT DATA ASSIGNMENT function</li><li>9.7 Updating data in a pivot table</li><li>9.8 Create PivotCharts</li><li>9.9 Changing properties of pivot tables</li><li>9.10 Changing the default layout of pivot tables</li><li>9.11 Exercises</li></ul><h5> 10 Trend analyses, data tables, target value search</h5><ul> <li>10.1 Data analysis with Excel</li><li>10.2 Basic knowledge trend analyses</li><li>10.3 Trend analyses</li><li>10.4 Determine/display trend on a forecast sheet</li><li>10.5 Trend analysis with the TREND function</li><li>10.6 Basic knowledge of data tables</li><li>10.7 Data table with one variable</li><li>10.8 Data table with two variables</li><li>10.9 Target value search</li><li>10.10 Exercise</li></ul> <h5>11 Solver</h5><ul> <li>11.1 Activate Add-In Solver</li><li>11.2 Basic knowledge solver</li><li>11.3 Calculating a specific target value</li><li>11.4 Defining constraints for the solver</li><li>11.5 Calculating the minimum or maximum target value</li><li>11.6 Using solver models</li><li>11.7 Solver reports</li><li>11.8 Exercise</li></ul><h5>12 scenarios</h5><ul> <li>12.1 Basic knowledge of scenarios</li><li>12.2 Create and protect scenarios</li><li>12.3 Working with scenarios</li><li>12.4 Exercise</li></ul><h5>13 Matrizen</h5><ul> <li>13.1 Basic knowledge of matrices</li><li>13.2 Creating matrix formulas</li><li>13.3 Edit matrix formulas</li><li>13.4 Matrix constants</li><li>13.5 Exercise</li></ul><h5> 14 Different diagram types</h5><ul> <li>14.1 Bar and column charts</li><li>14.2 Line and area diagrams</li><li>14.3 Circular and ring diagrams</li><li>14.4 Hierarchy diagrams</li><li>14.5 Statistics diagrams</li><li>14.6 Dot (XY) and bubble charts</li><li>14.7 Waterfall and rate diagrams</li><li>14.8 Funnel diagrams</li><li>14.9 Surface and network diagrams</li><li>14.10 Composite diagrams</li><li>14.11 Map diagrams</li><li>14.12 Exercise</li></ul> <h5> 15 Working professionally with diagrams</h5><ul> <li>15.1 Formatting the label of the value axis</li><li>15.2 Changing the division of the value axis</li><li>15.3 Format category axis</li><li>15.4 Show secondary axis</li><li>15.5 Show trend lines</li><li>15.6 Display error indicators for data series</li><li>15.7 Diagram templates</li><li>15.8 Exercise</li></ul> <h5> 16 Design tables with illustrations</h5><ul> <li>16.1 Basic knowledge of illustrations</li><li>16.2 Inserting illustrations</li><li>16.3 Editing illustrations</li><li>16.4 Formatting graphics and shapes</li><li>16.5 SmartArt graphics</li><li>16.6 Exercise</li></ul> <h5> 17 Importing or exporting data</h5><ul> <li>17.1 Import Access data</li><li>17.2 Import text files</li><li>17.3 Importing other foreign formats</li><li>17.4 Exporting Excel data</li><li>17.5 Exercise</li></ul><h5> 18 Creating Queries with Power Query</h5><ul> <li>18.1 Basic knowledge Power Query</li><li>18.2 Creating Queries with Power Query</li><li>18.3 Update or delete queries</li><li>18.4 Edit queries</li><li>18.5 Editing Query Criteria in the Power Query Editor</li><li>18.6 Creating/adding queries from multiple database tables</li><li>18.7 Exercise</li></ul><h5> 19 Working in a team</h5><ul> <li>19.1 Basic knowledge of teamwork</li><li>19.2 Making workbooks available and sharing them online</li><li>19.3 Editing workbooks online in a team</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-e365k"><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-e365e"><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 365 for Beginners <span class="fl-prod-pcode">(E365E)</span></a></span></li><li><span class="cms-link-marked"><a class="fl-href-prod" href="/ibb/en/course/training-e365f"><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 365 for Advanced Users <span class="fl-prod-pcode">(E365F)</span></a></span></li></ul>Microsoft Excel 365 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 365 for advanced users - 1 Names - 2 Structure tables - 3 Link formatting to conditions - 4 Monitor formulas and cell contents - 5 Special filters - 6 Excel databases - 7 Combine and consolidate data - 8 Create Pivot Tables - 9 Customize Pivot Tables - 10 Trend analyses, data tables, target value search - 11 Solver - 12 scenarios - 13 Matrices - 14 Different diagram types - 15 Working professionally with diagrams - 16 Design tables with illustrations - 17 Importing or exporting data - 18 Creating Queries with Power Query - 19 Working in a teamMicrosoft Excel 365 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 365 for advanced users 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 Structure tables - 2.1 Create outlines - 2.2 Working with structured tables - 2.3 Remove outlines - 2.4 Working with partial results - 2.5 Exercises 3 Link formatting to conditions - 3.1 Individual rules for conditional formatting - 3.2 Displaying value distribution with graphical elements - 3.3 Formatting cells depending on conditions - 3.4 Display and edit rules - 3.5 Working with multiple rules - 3.6 Exercise 4 Monitor formulas and cell contents - 4.1 Check formulas for errors - 4.2 Monitor cell contents - 4.3 Exercise 5 Special filters - 5.1 Basic knowledge of special filters - 5.2 Search criteria for the special filter - 5.3 Using special filters - 5.4 Exercise 6 Excel databases - 6.1 Basic knowledge of Excel databases - 6.2 Remove duplicates - 6.3 Using database functions - 6.4 Exercise 7 Combine and consolidate data - 7.1 Combining data - 7.2 Basic knowledge of table consolidation - 7.3 Consolidate data with formulas - 7.4 Consolidate data by position - 7.5 Consolidate data by heading - 7.6 Edit consolidation results - 7.7 Exercise 8 Create Pivot Tables - 8.1 Basic knowledge of pivot tables - 8.2 Create recommended pivot table from Excel data - 8.3 Creating an individual pivot table from Excel data - 8.4 Changing calculations in the value range - 8.5 Using predefined report layouts and formats - 8.6 Filtering data of a pivot table - 8.7 Filtering Pivot Table Data Using Timelines - 8.8 Create pivot table from external data source - 8.9 Exercise 9 Customize Pivot Tables - 9.1 Changing the layout of a pivot table - 9.2 Grouping data of a pivot table individually - 9.3 Using special display options - 9.4 Using calculated fields and elements - 9.5 Additional partial results - 9.6 PIVOT DATA ASSIGNMENT function - 9.7 Updating data in a pivot table - 9.8 Create PivotCharts - 9.9 Changing properties of pivot tables - 9.10 Changing the default layout of pivot tables - 9.11 Exercises 10 Trend analyses, data tables, target value search - 10.1 Data analysis with Excel - 10.2 Basic knowledge trend analyses - 10.3 Trend analyses - 10.4 Determine/display trend on a forecast sheet - 10.5 Trend analysis with the TREND function - 10.6 Basic knowledge of data tables - 10.7 Data table with one variable - 10.8 Data table with two variables - 10.9 Target value search - 10.10 Exercise 11 Solver - 11.1 Activate Add-In Solver - 11.2 Basic knowledge solver - 11.3 Calculating a specific target value - 11.4 Defining constraints for the solver - 11.5 Calculating the minimum or maximum target value - 11.6 Using solver models - 11.7 Solver reports - 11.8 Exercise 12 scenarios - 12.1 Basic knowledge of scenarios - 12.2 Create and protect scenarios - 12.3 Working with scenarios - 12.4 Exercise 13 Matrizen - 13.1 Basic knowledge of matrices - 13.2 Creating matrix formulas - 13.3 Edit matrix formulas - 13.4 Matrix constants - 13.5 Exercise 14 Different diagram types - 14.1 Bar and column charts - 14.2 Line and area diagrams - 14.3 Circular and ring diagrams - 14.4 Hierarchy diagrams - 14.5 Statistics diagrams - 14.6 Dot (XY) and bubble charts - 14.7 Waterfall and rate diagrams - 14.8 Funnel diagrams - 14.9 Surface and network diagrams - 14.10 Composite diagrams - 14.11 Map diagrams - 14.12 Exercise 15 Working professionally with diagrams - 15.1 Formatting the label of the value axis - 15.2 Changing the division of the value axis - 15.3 Format category axis - 15.4 Show secondary axis - 15.5 Show trend lines - 15.6 Display error indicators for data series - 15.7 Diagram templates - 15.8 Exercise 16 Design tables with illustrations - 16.1 Basic knowledge of illustrations - 16.2 Inserting illustrations - 16.3 Editing illustrations - 16.4 Formatting graphics and shapes - 16.5 SmartArt graphics - 16.6 Exercise 17 Importing or exporting data - 17.1 Import Access data - 17.2 Import text files - 17.3 Importing other foreign formats - 17.4 Exporting Excel data - 17.5 Exercise 18 Creating Queries with Power Query - 18.1 Basic knowledge Power Query - 18.2 Creating Queries with Power Query - 18.3 Update or delete queries - 18.4 Edit queries - 18.5 Editing Query Criteria in the Power Query Editor - 18.6 Creating/adding queries from multiple database tables - 18.7 Exercise 19 Working in a team - 19.1 Basic knowledge of teamwork - 19.2 Making workbooks available and sharing them online - 19.3 Editing workbooks online in a teamThis text was automatically translated. Please click here to read the original German version. This training includes: - Microsoft Excel 365 for Beginners (E365E) - Microsoft Excel 365 for Advanced Users (E365F)3 days1290.001290.004480.002680.001290.00