{"course":{"productid":24594,"modality":1,"active":true,"language":"en","title":"Microsoft Excel 365 for Advanced Users","productcode":"E365F","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-E365F","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-e365f","contents":"<ul>\n<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>","outline":"<h5> 1 Names<\/h5><ul>\n<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>\n<h5> 2 Structure tables<\/h5><ul>\n<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>\n<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>\n<li>4.1 Check formulas for errors<\/li><li>4.2 Monitor cell contents<\/li><li>4.3 Exercise<\/li><\/ul>\n<h5> 5 Special filters<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<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>\n<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>\n<h5>11 Solver<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<h5> 15 Working professionally with diagrams<\/h5><ul>\n<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>\n<h5> 16 Design tables with illustrations<\/h5><ul>\n<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>\n<h5> 17 Importing or exporting data<\/h5><ul>\n<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>\n<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>\n<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>","comments":"<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>\n<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>","summary":"<p>Use names and conditional formatting, work with database functions and the special filter, perform complex analyses using pivot tables and matrices, and much more: With the help of the book &quot;Excel 2019 - Advanced Techniques&quot; you will learn how to analyze and visualize your data quickly and professionally. The advanced Excel techniques required for this are explained in an easy-to-understand manner using concrete practical examples with many visualizations.<\/p>\n<ul>\n<li>Insert name<\/li><li>Structure tables<\/li><li>Use individual conditional formatting<\/li><li>Combine and consolidate data<\/li><li>Create and customize complex pivot tables<\/li><li>Analyze data (e.g. with special filters, trend analyses, data tables, target value search, solver, scenario manager and matrices) Visualize data professionally with charts and illustrations<\/li><li>Import data (e.g. with Power Query) or export data<\/li><\/ul><p>\nTailored to the learning topics in &quot;Excel 2019 - Advanced Techniques&quot;, BuchPlus gives you a comprehensive digital media package with learning videos, companion files, knowledge tests, further exercises, additional learning content and quick overviews of the most important commands.<\/p>","contents_plain":"- 1 Names\n- 2 Structure tables\n- 3 Link formatting to conditions\n- 4 Monitor formulas and cell contents\n- 5 Special filters\n- 6 Excel databases\n- 7 Combine and consolidate data\n- 8 Create Pivot Tables\n- 9 Customize Pivot Tables\n- 10 Trend analyses, data tables, target value search\n- 11 Solver\n- 12 scenarios\n- 13 Matrices\n- 14 Different diagram types\n- 15 Working professionally with diagrams\n- 16 Design tables with illustrations\n- 17 Importing or exporting data\n- 18 Creating Queries with Power Query\n- 19 Working in a team","outline_plain":"1 Names\n\n\n- 1.1 Basic knowledge of names\n- 1.2 Set names\n- 1.3 Insert names in formulas\n- 1.4 Useful techniques when using names\n- 1.5 Manage names\n- 1.6 Exercise\n\n 2 Structure tables\n\n\n- 2.1 Create outlines\n- 2.2 Working with structured tables\n- 2.3 Remove outlines\n- 2.4 Working with partial results\n- 2.5 Exercises\n 3 Link formatting to conditions\n\n\n- 3.1 Individual rules for conditional formatting\n- 3.2 Displaying value distribution with graphical elements\n- 3.3 Formatting cells depending on conditions\n- 3.4 Display and edit rules\n- 3.5 Working with multiple rules\n- 3.6 Exercise\n 4 Monitor formulas and cell contents\n\n\n- 4.1 Check formulas for errors\n- 4.2 Monitor cell contents\n- 4.3 Exercise\n\n 5 Special filters\n\n\n- 5.1 Basic knowledge of special filters\n- 5.2 Search criteria for the special filter\n- 5.3 Using special filters\n- 5.4 Exercise\n 6 Excel databases\n\n\n- 6.1 Basic knowledge of Excel databases\n- 6.2 Remove duplicates\n- 6.3 Using database functions\n- 6.4 Exercise\n 7 Combine and consolidate data\n\n\n- 7.1 Combining data\n- 7.2 Basic knowledge of table consolidation\n- 7.3 Consolidate data with formulas\n- 7.4 Consolidate data by position\n- 7.5 Consolidate data by heading\n- 7.6 Edit consolidation results\n- 7.7 Exercise\n 8 Create Pivot Tables\n\n\n- 8.1 Basic knowledge of pivot tables\n- 8.2 Create recommended pivot table from Excel data\n- 8.3 Creating an individual pivot table from Excel data\n- 8.4 Changing calculations in the value range\n- 8.5 Using predefined report layouts and formats\n- 8.6 Filtering data of a pivot table\n- 8.7 Filtering Pivot Table Data Using Timelines\n- 8.8 Create pivot table from external data source\n- 8.9 Exercise\n 9 Customize Pivot Tables\n\n\n- 9.1 Changing the layout of a pivot table\n- 9.2 Grouping data of a pivot table individually\n- 9.3 Using special display options\n- 9.4 Using calculated fields and elements\n- 9.5 Additional partial results\n- 9.6 PIVOT DATA ASSIGNMENT function\n- 9.7 Updating data in a pivot table\n- 9.8 Create PivotCharts\n- 9.9 Changing properties of pivot tables\n- 9.10 Changing the default layout of pivot tables\n- 9.11 Exercises\n 10 Trend analyses, data tables, target value search\n\n\n- 10.1 Data analysis with Excel\n- 10.2 Basic knowledge trend analyses\n- 10.3 Trend analyses\n- 10.4 Determine\/display trend on a forecast sheet\n- 10.5 Trend analysis with the TREND function\n- 10.6 Basic knowledge of data tables\n- 10.7 Data table with one variable\n- 10.8 Data table with two variables\n- 10.9 Target value search\n- 10.10 Exercise\n\n11 Solver\n\n\n- 11.1 Activate Add-In Solver\n- 11.2 Basic knowledge solver\n- 11.3 Calculating a specific target value\n- 11.4 Defining constraints for the solver\n- 11.5 Calculating the minimum or maximum target value\n- 11.6 Using solver models\n- 11.7 Solver reports\n- 11.8 Exercise\n12 scenarios\n\n\n- 12.1 Basic knowledge of scenarios\n- 12.2 Create and protect scenarios\n- 12.3 Working with scenarios\n- 12.4 Exercise\n13 Matrizen\n\n\n- 13.1 Basic knowledge of matrices\n- 13.2 Creating matrix formulas\n- 13.3 Edit matrix formulas\n- 13.4 Matrix constants\n- 13.5 Exercise\n 14 Different diagram types\n\n\n- 14.1 Bar and column charts\n- 14.2 Line and area diagrams\n- 14.3 Circular and ring diagrams\n- 14.4 Hierarchy diagrams\n- 14.5 Statistics diagrams\n- 14.6 Dot (XY) and bubble charts\n- 14.7 Waterfall and rate diagrams\n- 14.8 Funnel diagrams\n- 14.9 Surface and network diagrams\n- 14.10 Composite diagrams\n- 14.11 Map diagrams\n- 14.12 Exercise\n\n 15 Working professionally with diagrams\n\n\n- 15.1 Formatting the label of the value axis\n- 15.2 Changing the division of the value axis\n- 15.3 Format category axis\n- 15.4 Show secondary axis\n- 15.5 Show trend lines\n- 15.6 Display error indicators for data series\n- 15.7 Diagram templates\n- 15.8 Exercise\n\n 16 Design tables with illustrations\n\n\n- 16.1 Basic knowledge of illustrations\n- 16.2 Inserting illustrations\n- 16.3 Editing illustrations\n- 16.4 Formatting graphics and shapes\n- 16.5 SmartArt graphics\n- 16.6 Exercise\n\n 17 Importing or exporting data\n\n\n- 17.1 Import Access data\n- 17.2 Import text files\n- 17.3 Importing other foreign formats\n- 17.4 Exporting Excel data\n- 17.5 Exercise\n 18 Creating Queries with Power Query\n\n\n- 18.1 Basic knowledge Power Query\n- 18.2 Creating Queries with Power Query\n- 18.3 Update or delete queries\n- 18.4 Edit queries\n- 18.5 Editing Query Criteria in the Power Query Editor\n- 18.6 Creating\/adding queries from multiple database tables\n- 18.7 Exercise\n 19 Working in a team\n\n\n- 19.1 Basic knowledge of teamwork\n- 19.2 Making workbooks available and sharing them online\n- 19.3 Editing workbooks online in a team","comments_plain":"This text was automatically translated. Please click here to read the original German version.\n\nThis text was automatically translated. Please click here to read the original German version.","summary_plain":"Use names and conditional formatting, work with database functions and the special filter, perform complex analyses using pivot tables and matrices, and much more: With the help of the book \"Excel 2019 - Advanced Techniques\" you will learn how to analyze and visualize your data quickly and professionally. The advanced Excel techniques required for this are explained in an easy-to-understand manner using concrete practical examples with many visualizations.\n\n\n- Insert name\n- Structure tables\n- Use individual conditional formatting\n- Combine and consolidate data\n- Create and customize complex pivot tables\n- Analyze data (e.g. with special filters, trend analyses, data tables, target value search, solver, scenario manager and matrices) Visualize data professionally with charts and illustrations\n- Import data (e.g. with Power Query) or export data\n\nTailored to the learning topics in \"Excel 2019 - Advanced Techniques\", BuchPlus gives you a comprehensive digital media package with learning videos, companion files, knowledge tests, further exercises, additional learning content and quick overviews of the most important commands.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":890},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":890},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":3090},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1680},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":890}}},"lastchanged":"2026-02-04T12:37:32+01:00","parenturl":"https:\/\/portal.flane.de\/ibb\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.de\/ibb\/en\/json-course-schedule\/24594","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-e365f"}}