E365FFLFast LaneFL-E365F1.0<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> 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-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>here</a></span> to read the original German version.</p> <p>This text was automatically translated. Please click <span class="cms-link-marked"><a class="fl-href-prod" href="/ibb/de/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>here</a></span> to read the original German version.</p>- 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 team1 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 text was automatically translated. Please click here to read the original German version.2 days890.00890.003090.001680.00890.00