E365EFLFast LaneFL-E365E1.0<ul> <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><h5> 1 Get to know Excel</h5><ul> <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> <h5> 2 Basic techniques</h5><ul> <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> <h5> 3 Working with formulas</h5><ul> <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> <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> <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> <h5>6 Edit table view and structure</h5><ul> <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> <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> <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> <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> <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> <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><p>This text was automatically translated. Please click <span class="cms-link-marked"><a class="fl-href-prod" href="/ibb/de/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>here</a></span> to read the original German version.</p>- 1 Get to know Excel - 2 Basic techniques - 3 Working with formulas - 4 Format cells - 5 Fill, Copy and Move - 6 Edit table view and structure - 7 Working with simple functions - 8 Create and design diagrams - 9 Print tables with individual settings - 10 Use workbooks effectively - 11 Sort and filter data1 Get to know Excel - 1.1 What is Excel - 1.2 Excel starten - 1.3 Enter and calculate data - 1.4 Format data - 1.5 Create diagram - 1.6 Print table and diagram - 1.7 Excel legs 2 Basic techniques - 2.1 Excel windows at a glance - 2.2 Using the ribbon - 2.3 Field What would you like to do? use - 2.4 Entering data in the spreadsheet - 2.5 Entering date and time information - 2.6 Modify and delete cell contents - 2.7 Changing the column width or row height - 2.8 Selecting cells - 2.9 Undo actions - 2.10 Print worksheets - 2.11 Saving and closing workbooks - 2.12 Creating and opening workbooks - 2.13 Exercise 3 Working with formulas - 3.1 Structure and input of formulas - 3.2 SUM function - 3.3 Inserting cell references by pointing in formulas - 3.4 Edit formulas - 3.5 Exercise 4 Format cells - 4.1 Basic knowledge of formatting - 4.2 Defining fonts and font properties - 4.3 Aligning, indenting and rotating cell contents - 4.4 Line breaks and merged cells - 4.5 Using frames and lines - 4.6 Assign fill color or pattern - 4.7 Formatting numbers - 4.8 Assign date and time formats - 4.9 Formatting tips - 4.10 Exercise 5 Fill, Copy and Move - 5.1 Repeat and auto complete - 5.2 Moving and copying with the mouse - 5.3 Moving and copying using the clipboard - 5.4 Using the fill-in function - 5.5 Working with the flash preview - 5.6 Relative, absolute and mixed references - 5.7 Exercises 6 Edit table view and structure - 6.1 Hiding or showing columns or rows - 6.2 Inserting or deleting columns or rows - 6.3 Insert or delete cells - 6.4 Exercise 7 Working with simple functions - 7.1 Structure and input of functions - 7.2 Selection of simple functions - 7.3 Calculating with simple functions - 7.4 Using the function library - 7.5 Exercise 8 Create and design diagrams - 8.1 Basic knowledge of diagrams - 8.2 Create recommended diagrams - 8.3 Creating a diagram with a specific diagram type - 8.4 Swapping the arrangement of the diagram data - 8.5 Changing the size and position of a diagram object - 8.6 Move diagram to a diagram sheet - 8.7 Designing a diagram with a quick layout - 8.8 Using chart format templates - 8.9 Exercise 9 Print tables with individual settings - 9.1 Checking print pages with the print preview - 9.2 Making basic page layout settings - 9.3 Set advanced print settings - 9.4 Defining page breaks - 9.5 Headers and footers - 9.6 Defining column and row titles - 9.7 Exercise 10 Use workbooks effectively - 10.1 Working with workbooks - 10.2 Moving and copying worksheets - 10.3 Defining the display of the worksheets - 10.4 Cell references to other spreadsheets - 10.5 Cell references to other workbooks - 10.6 Using links - 10.7 Adding comments to tables - 10.8 Protect workbooks - 10.9 Protecting worksheets and cells - 10.10 Exercises 11 Sort and filter data - 11.1 Sorting tables - 11.2 Sorting tables by formatting - 11.3 Basic knowledge AutoFilter - 11.4 Using predefined search criteria in AutoFilter - 11.5 Using the AutoFilter list - 11.6 Filter by formatting - 11.7 ExerciseThis text was automatically translated. Please click here to read the original German version.1 day490.00490.001700.00870.00490.00