{"title":"电子表格中的数据结构","authors":"Irina Kulakova","doi":"10.36629/2686-9896-2024-1-144-145","DOIUrl":null,"url":null,"abstract":"The analysis and reorganization of the structure of the table containing data on the organization of compulsory training of employees employed in the petrochemical industry has been carried out. A restructuring of the table is proposed to obtain analytical information in the required sections using the Power Query add-in and pivot tables","PeriodicalId":118758,"journal":{"name":"Modern Technologies and Scientific and Technological Progress","volume":"23 7","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-04-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"DATA STRUCTURE IN SPREADSHEETS\",\"authors\":\"Irina Kulakova\",\"doi\":\"10.36629/2686-9896-2024-1-144-145\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The analysis and reorganization of the structure of the table containing data on the organization of compulsory training of employees employed in the petrochemical industry has been carried out. A restructuring of the table is proposed to obtain analytical information in the required sections using the Power Query add-in and pivot tables\",\"PeriodicalId\":118758,\"journal\":{\"name\":\"Modern Technologies and Scientific and Technological Progress\",\"volume\":\"23 7\",\"pages\":\"\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2024-04-22\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Modern Technologies and Scientific and Technological Progress\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.36629/2686-9896-2024-1-144-145\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Modern Technologies and Scientific and Technological Progress","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.36629/2686-9896-2024-1-144-145","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
对包含石化行业雇员义务培训组织情况数据的表格结构进行了分析和重组。建议对表格进行重组,以便利用 Power Query 插件和数据透视表获得所需部分的分析信息
The analysis and reorganization of the structure of the table containing data on the organization of compulsory training of employees employed in the petrochemical industry has been carried out. A restructuring of the table is proposed to obtain analytical information in the required sections using the Power Query add-in and pivot tables