E19FFLFast LaneFL-E19F1.0<ul> <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><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><li></li></ul> <h5> 2 Using special functions</h5><ul> <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> <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> <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> <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> <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> <h5> 7 Create Pivot Tables</h5><ul> <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> <h5> 8 Importing or exporting data</h5><ul> <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> <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> <h5> 10 Special design options</h5><ul> <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> <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> <h5> 12 Set up Excel individually</h5><ul> <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><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>- 1 Names - 2 Using special functions - 3 Perform time calculations - 4 Edit diagrams individually - 5 Working professionally with diagrams - 6 Combine and consolidate data - 7 Create Pivot Tables - 8 Import or export data - 9 Creating Queries with Power Query - 10 Special design options - 11 Table areas - 12 Set up Excel individually1 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 Using special functions - 2.1 Creating nested functions - 2.2 Working with the What-If Function - 2.3 Using Nested What-If Functions - 2.4 Use of the WENNS function - 2.5 SVERWEIS und WVERWEIS - 2.6 Useful mathematical functions - 2.7 Exercises 3 Perform time calculations - 3.1 Basic knowledge of time calculations - 3.2 Working with date and time functions - 3.3 Practical applications - 3.4 Exercise 4 Edit diagrams individually - 4.1 Basic knowledge of diagram editing - 4.2 Selecting and editing diagram elements - 4.3 Formatting diagram elements - 4.4 Labeling diagrams - 4.5 Labeling data series or data points - 4.6 Change content/formatting of labels - 4.7 Changing the diagram display or structure - 4.8 Printing diagrams - 4.9 Exercise 5 Working professionally with diagrams - 5.1 Formatting the label of the value axis - 5.2 Changing the division of the value axis - 5.3 Format category axis - 5.4 Show secondary axis - 5.5 Show trend lines - 5.6 Display error indicators for data series - 5.7 Diagram templates - 5.8 Exercise 6 Combine and consolidate data - 6.1 Combining data - 6.2 Basic knowledge of table consolidation - 6.3 Consolidate data with formulas - 6.4 Consolidate data by position - 6.5 Consolidate data by heading - 6.6 Edit consolidation results - 6.7 Exercise 7 Create Pivot Tables - 7.1 Basic knowledge of pivot tables - 7.2 Create recommended pivot table from Excel data - 7.3 Creating an individual pivot table from Excel data - 7.4 Changing calculations in the value range - 7.5 Using predefined report layouts and formats - 7.6 Filtering data of a pivot table - 7.7 Filtering Pivot Table Data Using Timelines - 7.8 Create Pivot Table from External Data Source - 7.9 Exercise 8 Importing or exporting data - 8.1 Access-Daten importieren - 8.2 Import text files - 8.3 Importing other foreign formats - 8.4 Exporting Excel data - 8.5 Exercise 9 Creating Queries with Power Query - 9.1 Basic knowledge Power Query - 9.2 Creating Queries with Power Query - 9.3 Update or delete queries - 9.4 Edit queries - 9.5 Editing Query Criteria in the Power Query Editor - 9.6 Create/add queries from multiple database tables - 9.7 Exercise 10 Special design options - 10.1 Basic knowledge of conditional formatting - 10.2 Formatting cells depending on conditions - 10.3 Displaying value distribution with conditional formatting - 10.4 Basic knowledge of format templates - 10.5 Working with style sheets - 10.6 User-defined number formats - 10.7 Formatcodes - 10.8 Data check during input - 10.9 Exercises 11 Table areas - 11.1 Basic knowledge of table areas - 11.2 Converting lists into table areas - 11.3 Editing table areas - 11.4 Sorting and evaluating table areas - 11.5 Filtering table areas with data sections - 11.6 Exercise 12 Set up Excel individually - 12.1 Customizing the toolbar for access - 12.2 Customizing the ribbon - 12.3 Set other default working folder - 12.4 Using document properties - 12.5 Working with custom views - 12.6 ExerciseThis text was automatically translated. Please click here to read the original German version.2 days890.00890.003090.001680.00890.00