{"course":{"productid":24611,"modality":1,"active":true,"language":"en","title":"Microsoft Excel 2019 for Beginners","productcode":"E19E","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-E19E","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-e19e","contents":"<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>","outline":"<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><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>\n<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>","comments":"<p>This text was automatically translated. Please click <span class=\"cms-link-marked\"><a class=\"fl-href-prod\" href=\"\/ibb\/de\/course\/training-e19e\"><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>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.<\/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>Tailored 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":"- 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","outline_plain":"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 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\n 6 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\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","comments_plain":"This text was automatically translated. Please click here to read the original German version.","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- 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\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":1,"formatted":"1 day"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":490},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":490},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":1700},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":870},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":490}}},"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\/24611","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-e19e"}}