{"id":14601,"date":"2022-12-29T08:24:17","date_gmt":"2022-12-29T07:24:17","guid":{"rendered":"https:\/\/www.itta.net\/formations\/icdl-base-spreadsheets-bm4\/"},"modified":"2025-10-16T12:59:18","modified_gmt":"2025-10-16T10:59:18","slug":"icdl-base-spreadsheets-bm4","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/","title":{"rendered":"ICDL BASE &#8211; Spreadsheets &#8211; BM4"},"content":{"rendered":"<p data-start=\"0\" data-end=\"390\">The ECDL BASE &#8211; Spreadsheet &#8211; BM4 training teaches you the essential foundations of spreadsheet software. It helps you better understand how to organize, calculate, and present data clearly and efficiently. You will learn how to create structured tables, use precise formulas, and design relevant charts. The goal is to master the key tools needed to handle numerical data professionally.<\/p>\n<h3 data-start=\"392\" data-end=\"445\">A practical learning experience on spreadsheets<\/h3>\n<p data-start=\"447\" data-end=\"831\" data-is-last-node=\"\" data-is-only-node=\"\">This course is designed for anyone looking to strengthen their spreadsheet skills and obtain the ECDL BASE certification. It covers spreadsheet management, data sorting and editing, the creation of logical and arithmetic formulas, as well as page layout and print preparation. The concepts are introduced progressively to ensure easy understanding and immediate practical application.<\/p>\n","protected":false},"featured_media":0,"parent":0,"menu_order":0,"template":"","editeurs":[1532,1534],"domaine":[1265,1266],"class_list":["post-14601","formations","type-formations","status-publish","hentry","editeurs-ecdl","editeurs-modules-base-ecdl","domaine-office-automation","domaine-office-automation-certifications"],"acf":{"reference":"ECDL1-BM4","duree_nombre":2,"duree_unite":"jour","prix_virtuel":1200,"prix_presentiel":1300,"prix_blended":"","prix_elearning":"","views":1958,"niveau":["Fondamental"],"role":"","certifiant":["Certifiant"],"pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Optionnel","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"Spreadsheet Training \u2013 ECDL BASE \u2013 BM4","objectifs":"<ul>\r\n \t<li>Work with spreadsheets and save them in different file formats, locally or in the cloud<\/li>\r\n \t<li>Use available help resources, shortcuts and the go to tool to enhance productivity<\/li>\r\n \t<li>Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data<\/li>\r\n \t<li>Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets<\/li>\r\n \t<li>Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas<\/li>\r\n \t<li>Format numbers and text content in a spreadsheet and use available autoformat\/table styles<\/li>\r\n \t<li>Choose suitable charts, and create and format charts to communicate information meaningfully<\/li>\r\n \t<li>Adjust spreadsheet page settings and check and correct spreadsheet content before printing<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>Basic knowledge of Windows<\/li>\r\n \t<li>Have worked with Excel<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n  <li>Office employees wishing to certify their spreadsheet skills<\/li>\r\n  <li>Administrative assistants or accountants handling numerical data<\/li>\r\n  <li>Students and trainers preparing for the ECDL certification<\/li>\r\n  <li>Professionals seeking to improve their mastery of calculation tools<\/li>\r\n<\/ul>\r\n","examen":"<ul>\r\n \t<li>This course prepares to the exam ICDL Base - Spreadsheets (BM4). If you wish to take this exam, please contact our secretariat who will let you know the cost of the exam and will take care of all the necessary administrative procedures for you<\/li>\r\n<\/ul>","documentation":"<ul>\r\n \t<li>Digital courseware included<\/li>\r\n<\/ul>","lab__exercices":"<ul>\r\n<li>This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.<\/li>\r\n\r\n<\/ul>","contenu_cours":"<strong>Using the Application<\/strong>\r\n\r\nModule 1: Working with Spreadsheets\r\n<ul>\r\n \t<li>Open, close a spreadsheet application. Open, close spreadsheet(s)<\/li>\r\n \t<li>Create a new spreadsheet based on default template, other available template locally or online<\/li>\r\n \t<li>Save a spreadsheet to a location on a local, online drive. Save a spreadsheet under another name to a location on a local, online drive<\/li>\r\n \t<li>Save a spreadsheet as another file type like: text file, pdf, csv, software specific file extension<\/li>\r\n \t<li>Switch between open spreadsheets<\/li>\r\n<\/ul>\r\nModule 2: Enhancing Productivity\r\n<ul>\r\n \t<li>Set basic options\/preferences in the application: user name, default folder to open, save documents<\/li>\r\n \t<li>Use available help resources<\/li>\r\n \t<li>Use magnification\/zoom tools<\/li>\r\n \t<li>Display, hide built-in toolbars. Restore, minimise the ribbon<\/li>\r\n \t<li>Recognise good practice in navigating within a document: use shortcuts, go to tool<\/li>\r\n \t<li>Use go to tool to navigate to a specific page<\/li>\r\n<\/ul>\r\n<strong>Cells<\/strong>\r\n\r\nModule 1: Insert, Select\r\n<ul>\r\n \t<li>Understand that a cell in a worksheet should contain only one element of data, for example, quantity in one cell, description in adjacent cell<\/li>\r\n \t<li>Recognise good practice in creating lists: avoid blank rows and columns in the main body of list, ensure cells bordering list are blank<\/li>\r\n \t<li>Enter a number, date, text in a cell<\/li>\r\n \t<li>Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet<\/li>\r\n<\/ul>\r\nModule 2: Edit, Sort\r\n<ul>\r\n \t<li>Edit cell contents<\/li>\r\n \t<li>Use the undo, redo command<\/li>\r\n \t<li>Use a simple search command for specific content in a worksheet<\/li>\r\n \t<li>Use a simple replace command for specific content in a worksheet<\/li>\r\n \t<li>Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order<\/li>\r\n<\/ul>\r\nModule 3: Copy, Move, Delete\r\n<ul>\r\n \t<li>Copy the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets<\/li>\r\n \t<li>Use the autofill tool\/copy handle tool to copy, increment data, formula, function<\/li>\r\n \t<li>Move the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets<\/li>\r\n \t<li>Delete cell contents<\/li>\r\n<\/ul>\r\n<strong>Managing Worksheets<\/strong>\r\n\r\nModule 1: Rows and Columns\r\n<ul>\r\n \t<li>Select a row, range of adjacent rows, range of non-adjacent rows<\/li>\r\n \t<li>Select a column, range of adjacent columns, range of non-adjacent columns<\/li>\r\n \t<li>Insert, delete rows and columns<\/li>\r\n \t<li>Modify column width, row height to a specified value, to optimal width or height<\/li>\r\n \t<li>Freeze, unfreeze row and\/or column titles<\/li>\r\n<\/ul>\r\nModule 2: Worksheets\r\n<ul>\r\n \t<li>Insert a new worksheet, delete a worksheet<\/li>\r\n \t<li>Recognise good practice in naming worksheets: use meaningful worksheet names rather than the default names<\/li>\r\n \t<li>Copy, move a worksheet within a spreadsheet, between spreadsheets. Rename a worksheet<\/li>\r\n<\/ul>\r\n<strong>Formulas and Functions<\/strong>\r\n\r\nModule 1: Arithmetic\r\n<ul>\r\n \t<li>Recognise good practice in formula creation: use cell references rather than numbers in formulas<\/li>\r\n \t<li>Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division)<\/li>\r\n \t<li>Identify and understand standard error values associated with formulas: #NAME?, #DIV\/0!, #REF!, #VALUE!<\/li>\r\n \t<li>Understand and use relative, absolute cell referencing in formulas<\/li>\r\n<\/ul>\r\nModule 2: Functions\r\n<ul>\r\n \t<li>Use sum, average, minimum, maximum, count, counta, round functions<\/li>\r\n \t<li>Use the logical function if (yielding one of two specific values) with comparison operator: =, &gt;, &lt;<\/li>\r\n<\/ul>\r\n<strong>Formatting<\/strong>\r\n\r\nModule 1: Numbers\/Dates\r\n<ul>\r\n \t<li>Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands<\/li>\r\n \t<li>Format cells to display date style, currency symbol<\/li>\r\n \t<li>Format cells to display numbers as percentages<\/li>\r\n<\/ul>\r\nModule 2: Contents\r\n<ul>\r\n \t<li>Apply text formatting to cell contents: font size, font type<\/li>\r\n \t<li>Apply text formatting to cell contents: bold, italic, underline, double underline<\/li>\r\n \t<li>Apply different colours to cell contents, cell background<\/li>\r\n \t<li>Apply an autoformat\/table style to a cell range<\/li>\r\n \t<li>Copy the formatting from a cell, cell range to another cell, cell range<\/li>\r\n<\/ul>\r\nModule 3: Alignment, Border Effects\r\n<ul>\r\n \t<li>Apply, remove text wrapping to contents within a cell, cell range<\/li>\r\n \t<li>Align cell contents: horizontally, vertically. Adjust orientation of cell contents<\/li>\r\n \t<li>Merge and centre cell contents in a merged cell. Unmerge cells<\/li>\r\n \t<li>Apply, remove border effects to a cell, cell range: lines, colours<\/li>\r\n<\/ul>\r\n<strong>Charts<\/strong>\r\n\r\nModule 1: Create\r\n<ul>\r\n \t<li>Understand the uses of different types of chart: column chart, bar chart, line chart, pie chart<\/li>\r\n \t<li>Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart<\/li>\r\n \t<li>Select a chart<\/li>\r\n \t<li>Change the chart type<\/li>\r\n \t<li>Move, resize, delete a chart<\/li>\r\n<\/ul>\r\nModule 2: Edit\r\n<ul>\r\n \t<li>Add, remove, edit a chart title<\/li>\r\n \t<li>Add, remove a chart legend<\/li>\r\n \t<li>Add, remove data labels in a chart: values\/numbers, percentages<\/li>\r\n \t<li>Change chart area background colour, legend fill colour<\/li>\r\n \t<li>Change the column, bar, line, pie slice colours in the chart<\/li>\r\n \t<li>Change font size and colour of chart title, chart axes, chart legend text<\/li>\r\n<\/ul>\r\n<strong>Preparing to print<\/strong>\r\n\r\nModule 1: Setup\r\n<ul>\r\n \t<li>Change worksheet margins: top, bottom, left, right<\/li>\r\n \t<li>Change worksheet orientation: portrait, landscape. Change paper size<\/li>\r\n \t<li>Adjust page setup to fit worksheet contents on a specified number of pages<\/li>\r\n \t<li>Add, edit, delete text in headers, footers in a worksheet<\/li>\r\n \t<li>Insert, delete fields: page numbering, date, time, file name, worksheet name into headers, footers<\/li>\r\n<\/ul>\r\nModule 2: Check and Print\r\n<ul>\r\n \t<li>Check and correct spreadsheet calculations and text<\/li>\r\n \t<li>Turn on, off display of gridlines, display of row and column headings for printing purposes<\/li>\r\n \t<li>Apply automatic title row(s) printing on every page of a printed worksheet<\/li>\r\n \t<li>Preview a worksheet<\/li>\r\n \t<li>Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart<\/li>\r\n<\/ul>","cours_recommandes":[14598,14599,14600],"infos_additionnelles":"<h3>Developing strong spreadsheet skills for the professional world<\/h3>\r\nMastering spreadsheet software is now an essential skill in most professions. The ECDL BASE - Spreadsheet - BM4 course helps you gain an in-depth understanding of the key functions while developing a methodical approach to data handling. By learning how to structure worksheets and automate calculations, you increase your efficiency and accuracy. These skills are highly valued in fields such as management, accounting, marketing, and administration.\r\n\r\nIn this training, you will learn how to organize complex information and create clear, reliable reports. The logic of a spreadsheet relies on a structured approach: each cell, formula, and chart must serve a specific purpose. Understanding this logic allows you to optimize your workflow and ensure data consistency.\r\n<h3>Understanding the importance of formulas and functions<\/h3>\r\nSpreadsheet functions and formulas are much more than simple calculation tools. They are at the heart of data automation. Knowing how to use functions such as SUM, AVERAGE, or IF enables you to perform quick and accurate analyses. The training teaches you to create logical formulas capable of handling large volumes of information without errors. This mastery is a major asset for anyone working on financial tables, statistical reports, or project tracking sheets.\r\n\r\nYou will also learn how to identify common errors, such as missing references or division by zero. You\u2019ll develop professional reflexes to diagnose and correct formulas efficiently. This practical approach prepares you for real-world spreadsheet use in a professional setting.\r\n<h3>Creating effective charts for visual communication<\/h3>\r\nA good spreadsheet is not just about numbers. The ability to turn data into visual charts is essential for communicating results effectively. This course guides you in creating charts suited to different contexts: bar, pie, or line charts. You will learn to choose the most relevant visual representations according to your data type and message.\r\n\r\nYou will also understand how to harmonize colors, adjust legends, and highlight key elements in a chart. These skills will enable you to produce clear, professional-quality visuals that enhance your work and make your analyses easier to interpret.\r\n<h3>Optimizing presentation and print layout<\/h3>\r\nA well-designed spreadsheet should be readable, balanced, and easy to interpret. This course emphasizes formatting and print preparation. You will learn to adjust margins, configure headers and footers, and use print preview options to ensure a professional layout. This attention to detail is essential for any report or presentation intended for internal or external audiences.\r\n\r\nMastering these technical aspects strengthens your credibility and ensures the delivery of impeccable documents. The spreadsheet becomes a true communication tool, beyond simple data processing.\r\n<h3>Enhancing your profile with the ECDL BASE certification<\/h3>\r\nObtaining the ECDL BASE certification validates your spreadsheet skills and demonstrates your ability to use digital tools effectively. This certification is recognized across Europe and provides a concrete advantage in your professional journey. It proves your structured know-how and practical mastery of essential spreadsheet functions.\r\n\r\nIn a context where digital transformation is changing work methods, the ability to analyze and manage data precisely is a strategic skill. The ECDL certification enhances your employability and strengthens your professional credibility.\r\n<h3>FAQ<\/h3>\r\n<strong>Why learn to use a spreadsheet in 2025?<\/strong>\r\nSpreadsheets remain fundamental tools for data management, dashboard creation, and performance tracking. Their use extends to all professions, far beyond accounting.\r\n\r\n<strong>Is the ECDL certification still recognized?<\/strong>\r\nYes, the ECDL certification is an international standard that validates your core digital skills. It is widely recognized by companies and public institutions.\r\n\r\n<strong>What\u2019s the difference between ECDL BASE and other office certifications?<\/strong>\r\nECDL BASE evaluates essential skills across several IT domains, including spreadsheets. It\u2019s a comprehensive and rigorous certification suitable for beginners and professionals seeking to validate their knowledge.\r\n\r\n<strong>What are the concrete benefits for employees or students?<\/strong>\r\nThe course improves productivity, precision, and analytical skills. For students, it offers solid preparation for professional requirements.\r\n\r\n<strong>Is the training focused only on Excel?<\/strong>\r\nThe content applies to any spreadsheet software following industry standards, including Excel, LibreOffice Calc, and Google Sheets. The goal is to understand the core principles to adapt easily across platforms.\r\n\r\n<strong>How long does it take to master the basics?<\/strong>\r\nMost participants achieve good autonomy within a few days, provided they regularly practice the exercises included in the course.","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>Exam fee (Skills Card not included)<\/li>\r\n \t<li>Pre-training level evaluation<\/li>\r\n \t<li>Digital documentation<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>Exam fee (Skills Card not included)<\/li>\r\n \t<li>Pre-training level evaluation<\/li>\r\n \t<li>Digital documentation<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SpreadsheetsTraining - ICDL BASE - BM4 - ITTA<\/title>\n<meta name=\"description\" content=\"Master spreadsheets with the ECDL BASE - BM4 course and boost your certified office and data management skills.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-base-spreadsheets-bm4\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-base-spreadsheets-bm4\\\/\",\"name\":\"SpreadsheetsTraining - ICDL BASE - BM4 - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2022-12-29T07:24:17+00:00\",\"dateModified\":\"2025-10-16T10:59:18+00:00\",\"description\":\"Master spreadsheets with the ECDL BASE - BM4 course and boost your certified office and data management skills.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-base-spreadsheets-bm4\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-base-spreadsheets-bm4\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-base-spreadsheets-bm4\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Office Automation\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Office Automation Certifications\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"ICDL BASE &#8211; Spreadsheets &#8211; BM4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SpreadsheetsTraining - ICDL BASE - BM4 - ITTA","description":"Master spreadsheets with the ECDL BASE - BM4 course and boost your certified office and data management skills.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/","url":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/","name":"SpreadsheetsTraining - ICDL BASE - BM4 - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2022-12-29T07:24:17+00:00","dateModified":"2025-10-16T10:59:18+00:00","description":"Master spreadsheets with the ECDL BASE - BM4 course and boost your certified office and data management skills.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-base-spreadsheets-bm4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"Office Automation","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/"},{"@type":"ListItem","position":3,"name":"Office Automation Certifications","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/"},{"@type":"ListItem","position":4,"name":"ICDL BASE &#8211; Spreadsheets &#8211; BM4"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14600"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14599"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14598"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=14601"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14601"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}