{"id":166798,"date":"2023-05-16T15:45:19","date_gmt":"2023-05-16T12:45:19","guid":{"rendered":"https:\/\/trainings.eduhouse.fi\/?post_type=product&p=166798"},"modified":"2026-02-24T14:15:39","modified_gmt":"2026-02-24T12:15:39","slug":"excel-advanced-1-importing-data-and-calculations","status":"publish","type":"product","link":"https:\/\/trainings.eduhouse.fi\/en\/koulutukset\/excel-advanced-1-importing-data-and-calculations\/","title":{"rendered":"Excel advanced 1 \u2013 importing data and calculations"},"content":{"rendered":"

In Excel advanced 1 training, we get familiar with the most important features of Excel,\u00a0 including importing data from different sources and calculation and functions.<\/span>\u00a0<\/span><\/p>\n

This training is the first part of the Excel advanced course. Second 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 import data from different sources and analyze it with functions. We take a look at Xlookup, Vlookup and Sumifs \u2013 functions and how to use functions inside of a function.<\/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<\/span>\u00a0<\/span><\/h3>\n

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

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

Advanced use of Excel<\/span>\u00a0<\/span><\/h4>\n
    \n
  • Rehearsing the basics. Cell formating, calculating with excel and absolute references.<\/span>\u00a0<\/span><\/li>\n
  • Importing updating information from different sources. PowerQuery and Queries<\/span>\u00a0<\/span><\/li>\n
  • How to handle information in and between cells. Dividing information into cells and combining them with a formula.<\/span>\u00a0<\/span><\/li>\n
  • Go to special \u2013 feature. Conditional selection of cells. <\/span>\u00a0<\/span><\/li>\n<\/ul>\n

    Advanced calculating\u00a0<\/span>\u00a0<\/span><\/h4>\n
      \n
    • Format as a table in calculating.\u00a0<\/span>\u00a0<\/span><\/li>\n
    • Conditional calculation with functions. If and Sumifs.<\/span>\u00a0<\/span><\/li>\n
    • Fetching and connecting information with functions like Lookup, Vlookup and new Xlookup.\u00a0<\/span>\u00a0<\/span><\/li>\n
    • Combining functions: Sort\/Unique and Iferror\/AverageIfs<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

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

      Excel, advanced, advance, table calculus, importing of data, PowerQuery, Csv, Reference, cell reference, Function, Vlookup, XLookup, If, Calculation, calculus, condition<\/span>\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      In Excel advanced 1 training, we get familiar with the most important features of Excel,\u00a0 including importing data from different sources and calculation and functions.\u00a0 This training is the first part of the Excel advanced course. Second part is its own separate training, that focuses on dynamic calculations and Pivot.\u00a0\u00a0 Goal\u00a0 You 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":[8112,8111,8120,8121,8118,8122,8116,1205,2881,6850,8114,8115,8117,8113,2921,8119],"class_list":{"0":"post-166798","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-cell-reference","12":"product_tag-condition","13":"product_tag-csv-2","14":"product_tag-excel-en","15":"product_tag-function","16":"product_tag-if-2","17":"product_tag-importing-of-data","18":"product_tag-powerquery-2","19":"product_tag-reference","20":"product_tag-table-calculus","21":"product_tag-vlookup-en","22":"product_tag-xlookup-2","24":"first","25":"instock","26":"sold-individually","27":"taxable","28":"shipping-taxable","29":"purchasable","30":"product-type-variable","31":"has-default-attributes"},"acf":[],"_links":{"self":[{"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product\/166798","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=166798"}],"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=166798"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product_cat?post=166798"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainings.eduhouse.fi\/en\/wp-json\/wp\/v2\/product_tag?post=166798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}