{"course":{"productid":24592,"modality":1,"active":true,"language":"en","title":"Microsoft Excel 365 Compact","productcode":"E365K","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-E365K","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-e365k","contents":"<h5>Microsoft Excel 365 for beginners<\/h5><ul>\n<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>\n<h5>Microsoft Excel 365 for advanced users<\/h5><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>Microsoft Excel 365 for beginners<\/h5><h5> 1 Get to know Excel<\/h5><ul>\n<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>\n<h5> 2 Basic techniques<\/h5><ul>\n<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>\n<h5> 3 Working with formulas<\/h5><ul>\n<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>\n<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>\n<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>\n<h5>6 Edit table view and structure<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<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>\n<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>\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-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>\n<h5>This training includes:<\/h5><ul>\n<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>","summary":"<p>Learn with this compact course quickly and without ballast, how you can easily perform calculations with Excel and create meaningful tables and charts. Supported by easy-to-understand, practical examples and tips, we show you how to work cleverly and goal-oriented with Excel.<\/p>\n<p>Already on the first pages you will learn all the basic aspects of Excel with the help of an easy-to-follow example, e.g. entering, calculating and formatting data, creating descriptive diagrams and saving and printing tables. Thus, after the first chapter, you will not only have understood the basics of working with Excel, but also experienced them in practice.<\/p>\n<p>After this quick sense of achievement and the basic overview of the possibilities of Excel, you will gradually learn all Excel features that can be of importance in later practice - from the use of formulas and functions to sorting and filtering. In this way, you can easily expand your Excel skills step by step according to your personal requirements. In addition, &quot;Excel 2019 - Basic course compact&quot; also provides you with valuable services as a quick reference book time and again.\n<\/p>\n<ul>\n<li>Basics of table editing<\/li><li>Format cells<\/li><li>Working with formulas and functions<\/li><li>Create diagrams<\/li><li>Manage and print workbooks<\/li><li>Sort and filter data<\/li><\/ul><p>\nTailored to the learning topics in &quot;Excel 2019 - Basic course compact&quot;, with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying files, knowledge tests, further exercises, additional learning content and quick overviews of the most important commands.<\/p>","contents_plain":"Microsoft Excel 365 for beginners\n\n\n- 1 Get to know Excel\n- 2 Basic techniques\n- 3 Working with formulas\n- 4 Format cells\n- 5 Fill, Copy and Move\n- 6 Edit table view and structure\n- 7 Working with simple functions\n- 8 Create and design diagrams\n- 9 Print tables with individual settings\n- 10 Use workbooks effectively\n- 11 Sort and filter data\n\nMicrosoft Excel 365 for advanced users\n\n\n- 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":"Microsoft Excel 365 for beginners\n\n 1 Get to know Excel\n\n\n- 1.1 What is Excel\n- 1.2 Excel starten\n- 1.3 Enter and calculate data\n- 1.4 Format data\n- 1.5 Create diagram\n- 1.6 Print table and diagram\n- 1.7 Excel legs\n\n 2 Basic techniques\n\n\n- 2.1 Excel windows at a glance\n- 2.2 Using the ribbon\n- 2.3 Field What would you like to do? use\n- 2.4 Entering data in the spreadsheet\n- 2.5 Entering date and time information\n- 2.6 Modify and delete cell contents\n- 2.7 Changing the column width or row height\n- 2.8 Selecting cells\n- 2.9 Undo actions\n- 2.10 Print worksheets\n- 2.11 Saving and closing workbooks\n- 2.12 Creating and opening workbooks\n- 2.13 Exercise\n\n 3 Working with formulas\n\n\n- 3.1 Structure and input of formulas\n- 3.2 SUM function\n- 3.3 Inserting cell references by pointing in formulas\n- 3.4 Edit formulas\n- 3.5 Exercise\n 4 Format cells\n\n\n- 4.1 Basic knowledge of formatting\n- 4.2 Defining fonts and font properties\n- 4.3 Aligning, indenting and rotating cell contents\n- 4.4 Line breaks and merged cells\n- 4.5 Using frames and lines\n- 4.6 Assign fill color or pattern\n- 4.7 Formatting numbers\n- 4.8 Assign date and time formats\n- 4.9 Formatting tips\n- 4.10 Exercise\n 5 Fill, Copy and Move\n\n\n- 5.1 Repeat and auto complete\n- 5.2 Moving and copying with the mouse\n- 5.3 Moving and copying using the clipboard\n- 5.4 Using the fill-in function\n- 5.5 Working with the flash preview\n- 5.6 Relative, absolute and mixed references\n- 5.7 Exercises\n\n6 Edit table view and structure\n\n\n- 6.1 Hiding or showing columns or rows\n- 6.2 Inserting or deleting columns or rows\n- 6.3 Insert or delete cells\n- 6.4 Exercise\n 7 Working with simple functions\n\n\n- 7.1 Structure and input of functions\n- 7.2 Selection of simple functions\n- 7.3 Calculating with simple functions\n- 7.4 Using the function library\n- 7.5 Exercise\n 8 Create and design diagrams\n\n\n- 8.1 Basic knowledge of diagrams\n- 8.2 Create recommended diagrams\n- 8.3 Creating a diagram with a specific diagram type\n- 8.4 Swapping the arrangement of the diagram data\n- 8.5 Changing the size and position of a diagram object\n- 8.6 Move diagram to a diagram sheet\n- 8.7 Designing a diagram with a quick layout\n- 8.8 Using chart format templates\n- 8.9 Exercise\n 9 Print tables with individual settings\n\n\n- 9.1 Checking print pages with the print preview\n- 9.2 Making basic page layout settings\n- 9.3 Set advanced print settings\n- 9.4 Defining page breaks\n- 9.5 Headers and footers\n- 9.6 Defining column and row titles\n- 9.7 Exercise\n 10 Use workbooks effectively\n\n\n- 10.1 Working with workbooks\n- 10.2 Moving and copying worksheets\n- 10.3 Defining the display of the worksheets\n- 10.4 Cell references to other spreadsheets\n- 10.5 Cell references to other workbooks\n- 10.6 Using links\n- 10.7 Adding comments to tables\n- 10.8 Protect workbooks\n- 10.9 Protecting worksheets and cells\n- 10.10 Exercises\n 11 Sort and filter data\n\n\n- 11.1 Sorting tables\n- 11.2 Sorting tables by formatting\n- 11.3 Basic knowledge AutoFilter\n- 11.4 Using predefined search criteria in AutoFilter\n- 11.5 Using the AutoFilter list\n- 11.6 Filter by formatting\n- 11.7 Exercise\nMicrosoft Excel 365 for advanced users\n\n 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 training includes:\n\n\n- Microsoft Excel 365 for Beginners (E365E)\n- Microsoft Excel 365 for Advanced Users (E365F)","summary_plain":"Learn with this compact course quickly and without ballast, how you can easily perform calculations with Excel and create meaningful tables and charts. Supported by easy-to-understand, practical examples and tips, we show you how to work cleverly and goal-oriented with Excel.\n\nAlready on the first pages you will learn all the basic aspects of Excel with the help of an easy-to-follow example, e.g. entering, calculating and formatting data, creating descriptive diagrams and saving and printing tables. Thus, after the first chapter, you will not only have understood the basics of working with Excel, but also experienced them in practice.\n\nAfter this quick sense of achievement and the basic overview of the possibilities of Excel, you will gradually learn all Excel features that can be of importance in later practice - from the use of formulas and functions to sorting and filtering. In this way, you can easily expand your Excel skills step by step according to your personal requirements. In addition, \"Excel 2019 - Basic course compact\" also provides you with valuable services as a quick reference book time and again.\n\n\n\n- Basics of table editing\n- Format cells\n- Working with formulas and functions\n- Create diagrams\n- Manage and print workbooks\n- Sort and filter data\n\nTailored to the learning topics in \"Excel 2019 - Basic course compact\", with BuchPlus you receive a comprehensive, digital media package with learning videos, accompanying 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":3,"formatted":"3 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1290},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1290},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":4480},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2680},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":1290}}},"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\/24592","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-e365k"}}