{"course":{"productid":24612,"modality":1,"active":true,"language":"en","title":"Microsoft Excel 2019 for Advanced Users","productcode":"E19F","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-E19F","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-e19f","contents":"<ul>\n<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>","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><li><\/li><\/ul>\n<h5> 2 Using special functions<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<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>\n<h5> 7 Create Pivot Tables<\/h5><ul>\n<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>\n<h5> 8 Importing or exporting data<\/h5><ul>\n<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>\n<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>\n<h5> 10 Special design options<\/h5><ul>\n<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>\n<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>\n<h5> 12 Set up Excel individually<\/h5><ul>\n<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>","comments":"<p>This text was automatically translated. Please click <span class=\"cms-link-marked\"><a class=\"fl-href-prod\" href=\"\/ibb\/de\/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>here<\/a><\/span> to read the original German version.<\/p>","summary":"<p>Use names and special functions, create professional charts, perform complex analyses using pivot tables and Microsoft Query queries, and much more: With the help of this book, 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>Use names and table ranges<\/li><li>Use special functions (e.g. IF and VERWEIS)<\/li><li>Perform time calculations<\/li><li>Create professional diagrams<\/li><li>Combine and consolidate data<\/li><li>Working with Pivot Tables<\/li><li>Import or export data<\/li><li>Creating Power Query Queries<\/li><\/ul><p>\nTailored to the learning topics in &quot;Excel 2019 - Advanced course compact&quot;, with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying files, knowledge tests, further exercises, supplementary learning content and quick overviews of the most important commands.<\/p>","contents_plain":"- 1 Names\n- 2 Using special functions\n- 3 Perform time calculations\n- 4 Edit diagrams individually\n- 5 Working professionally with diagrams\n- 6 Combine and consolidate data\n- 7 Create Pivot Tables\n- 8 Import or export data\n- 9 Creating Queries with Power Query\n- 10 Special design options\n- 11 Table areas\n- 12 Set up Excel individually","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\n 2 Using special functions\n\n\n- 2.1 Creating nested functions\n- 2.2 Working with the What-If Function\n- 2.3 Using Nested What-If Functions\n- 2.4 Use of the WENNS function\n- 2.5 SVERWEIS und WVERWEIS\n- 2.6 Useful mathematical functions\n- 2.7 Exercises\n 3 Perform time calculations\n\n\n- 3.1 Basic knowledge of time calculations\n- 3.2 Working with date and time functions\n- 3.3 Practical applications\n- 3.4 Exercise\n 4 Edit diagrams individually\n\n\n- 4.1 Basic knowledge of diagram editing\n- 4.2 Selecting and editing diagram elements\n- 4.3 Formatting diagram elements\n- 4.4 Labeling diagrams\n- 4.5 Labeling data series or data points\n- 4.6 Change content\/formatting of labels\n- 4.7 Changing the diagram display or structure\n- 4.8 Printing diagrams\n- 4.9 Exercise\n 5 Working professionally with diagrams\n\n\n- 5.1 Formatting the label of the value axis\n- 5.2 Changing the division of the value axis\n- 5.3 Format category axis\n- 5.4 Show secondary axis\n- 5.5 Show trend lines\n- 5.6 Display error indicators for data series\n- 5.7 Diagram templates\n- 5.8 Exercise\n 6 Combine and consolidate data\n\n\n- 6.1 Combining data\n- 6.2 Basic knowledge of table consolidation\n- 6.3 Consolidate data with formulas\n- 6.4 Consolidate data by position\n- 6.5 Consolidate data by heading\n- 6.6 Edit consolidation results\n- 6.7 Exercise\n\n 7 Create Pivot Tables\n\n\n- 7.1 Basic knowledge of pivot tables\n- 7.2 Create recommended pivot table from Excel data\n- 7.3 Creating an individual pivot table from Excel data\n- 7.4 Changing calculations in the value range\n- 7.5 Using predefined report layouts and formats\n- 7.6 Filtering data of a pivot table\n- 7.7 Filtering Pivot Table Data Using Timelines\n- 7.8 Create Pivot Table from External Data Source\n- 7.9 Exercise\n\n 8 Importing or exporting data\n\n\n- 8.1 Access-Daten importieren\n- 8.2 Import text files\n- 8.3 Importing other foreign formats\n- 8.4 Exporting Excel data\n- 8.5 Exercise\n 9 Creating Queries with Power Query\n\n\n- 9.1 Basic knowledge Power Query\n- 9.2 Creating Queries with Power Query\n- 9.3 Update or delete queries\n- 9.4 Edit queries\n- 9.5 Editing Query Criteria in the Power Query Editor\n- 9.6 Create\/add queries from multiple database tables\n- 9.7 Exercise\n\n 10 Special design options\n\n\n- 10.1 Basic knowledge of conditional formatting\n- 10.2 Formatting cells depending on conditions\n- 10.3 Displaying value distribution with conditional formatting\n- 10.4 Basic knowledge of format templates\n- 10.5 Working with style sheets\n- 10.6 User-defined number formats\n- 10.7 Formatcodes\n- 10.8 Data check during input\n- 10.9 Exercises\n 11 Table areas\n\n\n- 11.1 Basic knowledge of table areas\n- 11.2 Converting lists into table areas\n- 11.3 Editing table areas\n- 11.4 Sorting and evaluating table areas\n- 11.5 Filtering table areas with data sections\n- 11.6 Exercise\n\n 12 Set up Excel individually\n\n\n- 12.1 Customizing the toolbar for access\n- 12.2 Customizing the ribbon\n- 12.3 Set other default working folder\n- 12.4 Using document properties\n- 12.5 Working with custom views\n- 12.6 Exercise","comments_plain":"This text was automatically translated. Please click here to read the original German version.","summary_plain":"Use names and special functions, create professional charts, perform complex analyses using pivot tables and Microsoft Query queries, and much more: With the help of this book, 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- Use names and table ranges\n- Use special functions (e.g. IF and VERWEIS)\n- Perform time calculations\n- Create professional diagrams\n- Combine and consolidate data\n- Working with Pivot Tables\n- Import or export data\n- Creating Power Query Queries\n\nTailored to the learning topics in \"Excel 2019 - Advanced course compact\", with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying files, knowledge tests, further exercises, supplementary 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\/24612","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-e19f"}}