{"id":168469,"date":"2023-05-31T16:37:23","date_gmt":"2023-05-31T13:37:23","guid":{"rendered":"https:\/\/trainings.eduhouse.fi\/?post_type=product&p=168469"},"modified":"2026-02-24T14:22:04","modified_gmt":"2026-02-24T12:22:04","slug":"excel-basic-2-functions-databases-and-graphics","status":"publish","type":"product","link":"https:\/\/trainings.eduhouse.fi\/en\/koulutukset\/excel-basic-2-functions-databases-and-graphics\/","title":{"rendered":"Excel basic 2 \u2013 functions, databases and graphics"},"content":{"rendered":"

Excel Basics training will introduce you to the basics of spreadsheets and get you started in using the software. This is the first part of Excel Basics as a whole.<\/span>\u00a0<\/span><\/p>\n

Goal<\/span>\u00a0<\/span><\/h3>\n

In this training you will learn the basics of advanced calculation, i.e. the use of functions, get acquainted with databases and learn how to create visually pleasing and clear diagrams.<\/span>\u00a0<\/span><\/p>\n

In addition, you will become familiar with table objects and the basics of DAX calculation.<\/span>\u00a0<\/span><\/p>\n

Target audience<\/span>\u00a0<\/span><\/h3>\n

The training is suitable for novice Excel users, as well as for users who want to improve the efficiency of their work.<\/span>\u00a0<\/span><\/p>\n

Program version<\/h3>\n

This training is suitable for Windows versions of Excel 2013, 2016, 2019, and 2022, as well as for the 2016 version of Excel for Mac.\u00a0<\/span>\u00a0<\/span><\/p>\n

Content<\/span>\u00a0<\/span><\/h3>\n

Basics of Function calculations<\/span>\u00a0<\/span><\/h4>\n
    \n
  • What’s a function? Create and use Excel functions.<\/span>\u00a0<\/span><\/li>\n
  • What is DAX? Calculations in a Table-object.<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

    Manage and analyze large data packages<\/span><\/h4>\n
      \n
    • How do I sort the data in a table in the order I want? Sort and arrange a table<\/span>\u00a0<\/span><\/li>\n
    • How do I show only the part of my table that I want? Use the filter feature.<\/span>\u00a0<\/span><\/li>\n
    • How do I display the table header bar when browsing a table? Pin a title bar or rows.<\/span>\u00a0<\/span><\/li>\n
    • How do I print a large table? Automatically fit a table to a specific number of pages, and table page layouts, such as margins and orientation.<\/span>\u00a0<\/span><\/li>\n
    • What does Format as a Table mean? The most important features of the tool Format as a table.<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

      Visual and clear table<\/span>\u00a0<\/span><\/h4>\n
        \n
      • How do I visualize content as a chart? Visualize data using column, pie, and line charts.<\/span>\u00a0<\/span><\/li>\n
      • How do I automatically separate the essential amounts from the mass? Apply conditional formatting.<\/span>\u00a0<\/span><\/li>\n
      • Can I view changes in values with trendlines? Take advantage of Sparklines<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

        Keywords<\/span>\u00a0<\/span><\/h3>\n

        Excel, Basics, Spreadsheet, Beginners, Reference, Cell Reference, Functions, Calculation, Table, Chart, Print, Graphics<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

        Excel Basics training will introduce you to the basics of spreadsheets and get you started in using the software. This is the first part of Excel Basics as a whole.\u00a0 Goal\u00a0 In this training you will learn the basics of advanced calculation, i.e. the use of functions, get acquainted with databases and learn how to […]\n","protected":false},"featured_media":238550,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false},"product_cat":[1081],"product_tag":[8169,8383,8120,8118,1388,1205,2920,1385,8384,8117,8382,4926],"class_list":{"0":"post-168469","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-scheduled-online-trainings","7":"product_tag-basics","8":"product_tag-beginners","9":"product_tag-calculation","10":"product_tag-cell-reference","11":"product_tag-chart","12":"product_tag-excel-en","13":"product_tag-functions","14":"product_tag-graphics","15":"product_tag-print","16":"product_tag-reference","17":"product_tag-spreadsheet","18":"product_tag-table","20":"first","21":"instock","22":"sold-individually","23":"taxable","24":"shipping-taxable","25":"purchasable","26":"product-type-variable","27":"has-default-attributes"},"acf":[],"_links":{"self":[{"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product\/168469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/comments?post=168469"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/media\/238550"}],"wp:attachment":[{"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/media?parent=168469"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product_cat?post=168469"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product_tag?post=168469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}