{"id":168462,"date":"2023-05-31T16:00:24","date_gmt":"2023-05-31T13:00:24","guid":{"rendered":"https:\/\/trainings.eduhouse.fi\/?post_type=product&p=168462"},"modified":"2026-02-24T14:17:44","modified_gmt":"2026-02-24T12:17:44","slug":"excel-advanced-2-dynamic-calculations-and-pivot","status":"publish","type":"product","link":"https:\/\/trainings.eduhouse.fi\/en\/koulutukset\/excel-advanced-2-dynamic-calculations-and-pivot\/","title":{"rendered":"Excel advanced 2 \u2013 dynamic calculations and Pivot"},"content":{"rendered":"

In Excel advanced 2-training we become familiar with the most important advanced features of Excel, including dynamic calculations and Pivot.<\/span>\u00a0<\/span><\/p>\n

This training includes the second part of Excel advanced. First part is its own separate training, that focuses on dynamic calculations and Pivot.\u00a0<\/span>\u00a0<\/span><\/p>\n

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

You learn how to do dynamic functions and how to do effective and visual reports with Pivot. You learn how to use dynamic references and how to produce reports and analysis with Pivot tools.<\/span>\u00a0<\/span><\/p>\n

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

The training is suitable for Excel users who already know the basics of Excel like how to use tables and how to calculate with different formulas.<\/span>\u00a0<\/span><\/p>\n

Program version<\/h3>\n

This training is suitable for Excel 2013, 2016, 2019, and 2022 for Windows and Excel 2016 on Mac.<\/span>\u202f<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

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

Advanced calculating\u00a0<\/span>\u00a0<\/span><\/h4>\n
    \n
  • Format as a table in calculating.\u00a0<\/span>\u00a0<\/span><\/li>\n
  • What does the spread of formulas to multiple cells mean? Dynamic references #, @ and UNIQUE-function.<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

    Advanced information handling<\/span>\u00a0<\/span><\/h4>\n
      \n
    • Rehearse of basics of databases.\u00a0<\/span>\u00a0<\/span><\/li>\n
    • How to hide useless information? Managing your view with Grouping.<\/span>\u00a0<\/span><\/li>\n
    • What is Pivot? Introducing Pivot tool.<\/span>\u00a0<\/span><\/li>\n
    • Reportage and information analysis with Pivot.<\/span>\u00a0<\/span><\/li>\n
    • Grouping tools in Pivot<\/span>\u00a0<\/span><\/li>\n
    • How can I Pivot multiple Excel-tables or import information from outside sources to Pivot? Look in to Excels Power Pivot tool and how to build a working database.<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

      Keywords<\/h3>\n

      Excel, advanced, advance, table calculus, Calculation, Dynamic Functions, calculus, #, @, Unique, Pivot, report, Reportage, PowerPivot<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      In Excel advanced 2-training we become familiar with the most important advanced features of Excel, including dynamic calculations and Pivot.\u00a0 This training includes the second part of Excel advanced. First part is its own separate training, that focuses on dynamic calculations and Pivot.\u00a0\u00a0 Goal\u00a0 You learn how to do dynamic functions and how to do […]\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":[8112,8111,8120,8121,8377,1205,2928,8380,3380,8379,8113,8378],"class_list":{"0":"post-168462","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-scheduled-online-trainings","7":"product_tag-advance-2","8":"product_tag-advanced","9":"product_tag-calculation","10":"product_tag-calculus","11":"product_tag-dynamic-functions","12":"product_tag-excel-en","13":"product_tag-pivot-en","14":"product_tag-powerpivot-2","15":"product_tag-report","16":"product_tag-reportage-2","17":"product_tag-table-calculus","18":"product_tag-unique-2","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\/168462","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=168462"}],"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=168462"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product_cat?post=168462"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product_tag?post=168462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}