{"id":6071,"date":"2020-10-13T17:13:16","date_gmt":"2020-10-13T08:13:16","guid":{"rendered":"https:\/\/www.hpymt.net\/tsu\/?p=6071"},"modified":"2020-11-19T08:47:22","modified_gmt":"2020-11-18T23:47:22","slug":"web-excel-pivot-table2","status":"publish","type":"post","link":"https:\/\/www.hpymt.net\/tsu\/web-excel-pivot-table2\/","title":{"rendered":"Web\u7528Excel\u3067\u5358\u7d14\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\uff08choices\uff09"},"content":{"rendered":"<p><strong>\u5358\u7d14\u96c6\u8a08\uff08GT\u96c6\u8a08\uff1agrand total\uff09\u3092\u5f97\u305f\u3044\u3068\u304d<\/strong><\/p>\n<p><strong>choices\uff08\u9078\u629e\u80a2\uff09\u306b\u3088\u308b\u8abf\u67fb\u7968\u306e\u4f5c\u6210<\/strong><\/p>\n<ol>\n<li>\u4f8b\u3068\u3057\u3066\u3001\u597d\u304d\u306a\u98df\u3079\u7269\u3092\u304d\u304f\u8cea\u554f\u3092\u4f5c\u6210\u3057\u307e\u3059<\/li>\n<li>choices\uff08\u9078\u629e\u80a2\uff09\u3092\u9078\u3073\u307e\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/01a-favorite-food-q.png\" alt=\"01a-favorite-food-q\" \/><\/li>\n<li>1\u756a\u4e0a\u306b\u8cea\u554f\u3092\u5165\u529b\u3001\u4e0b\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u56de\u7b54\u3092\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3059\n<ul>\n<li>\u53c2\u7167\uff1a<a href=\"https:\/\/www.hpymt.net\/tsu\/ms-forms-flow\/\" target=\"_blank\" rel=\"noopener noreferrer\">MS Forms\u3067\u306e\u8abf\u67fb\u7968\u4f5c\u6210\u624b\u9806<\/a><\/li>\n<\/ul>\n<\/li>\n<li>\u56de\u7b54\u3092\u56de\u53ce\u3057\u3001Excel\u5f62\u5f0f\u306b\u4fdd\u5b58\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u7e26\u306b\u597d\u304d\u306a\u679c\u7269\u306e\u540d\u524d\u304c\u4e26\u3073\u307e\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/02-favorite-food-res.png\" alt=\"02-favorite-food-res\" \/><\/li>\n<\/ol>\n<p><strong>Pivot Table\u3078\u306e\u5909\u63db<\/strong><\/p>\n<ol>\n<li>\u8868\u306e\u4e2d\u3092\u30af\u30ea\u30c3\u30af\uff08\u30c7\u30fc\u30bf\u306e\u5165\u3063\u3066\u3044\u308b\u3068\u3053\u308d\u306a\u3089\u3069\u3053\u3067\u3082\uff09<\/li>\n<li>Insert\u3092\u30af\u30ea\u30c3\u30af<\/li>\n<li>PivotTable\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.hpymt.net\/etc\/web-excel\/pivot-web\/04-pivot.png\" alt=\"04-pivot\" \/><\/li>\n<li>OK\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.hpymt.net\/etc\/web-excel\/pivot-web\/05-ok.png\" alt=\"05-ok\" \/><\/p>\n<ul>\n<li>\u53c2\u7167\uff1a<a href=\"https:\/\/www.hpymt.net\/tsu\/web-excel-pivot-table1\/\" target=\"_blank\" rel=\"noopener noreferrer\">Web\u7528Excel\u3067\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\uff11\uff08Pivot table\uff09<\/a><\/li>\n<\/ul>\n<\/li>\n<li>\u8868\u306b\u3057\u305f\u3044\u9805\u76ee\u3092COLUMNS\u306b\u30c9\u30e9\u30c3\u30b0<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/03-drag1.png\" alt=\"03-drag1\" \/><\/li>\n<li>VALUES\u306b\u3082\u30c9\u30e9\u30c3\u30b0<\/li>\n<li>\u8868\u304c\u4f5c\u6210\u3055\u308c\u3001\u305d\u308c\u305e\u308c\u306e\u4eba\u6570\u304c\u8868\u793a\u3055\u308c\u307e\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/04-res1.png\" alt=\"04-res1\" \/><br \/>\n\u3044\u3061\u3054\u304c\u4e00\u756a\u597d\u304d\u3068\u7b54\u3048\u305f\u4eba\u304c\uff13\u4eba\u3001<br \/>\n\u308a\u3093\u3054\u304c\u4e00\u756a\u597d\u304d\u3068\u7b54\u3048\u305f\u4eba\u304c\uff12\u4eba\u3044\u305f\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059<\/li>\n<li>\u30b3\u30d4\u30fc\u3057\u3066\u7a7a\u3044\u3066\u3044\u308b\u3068\u3053\u308d\u306b\u8cbc\u308a\u4ed8\u3051\u307e\u3059<br \/>\n\u540c\u69d8\u306b\u3057\u3066\u3001\u4ed6\u306e\u9805\u76ee\u3082\u8868\u3092\u4f5c\u308c\u307e\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/05-copy.png\" alt=\"05-copy\" \/><\/li>\n<li>\u56de\u7b54\u9805\u76ee\u304c\u3044\u304f\u3064\u3082\u3042\u308b\u5834\u5408\u3001\u4e0b\u306e\uff0b\u3092\u30af\u30ea\u30c3\u30af\u3001<br \/>\n\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u306b\u8cbc\u308a\u4ed8\u3051\u3001\u6574\u7406\u3057\u307e\u3057\u3087\u3046<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/05b-newsheet.png\" alt=\"05b-newsheet\" \/><\/li>\n<\/ol>\n<p><strong>Pivot Table\u306e\u4fee\u6b63<\/strong><\/p>\n<ol>\n<li>\u4f5c\u6210\u3057\u305fPivot Table\u3092\u5831\u544a\u66f8\u306b\u8a18\u8f09\u3067\u304d\u308b\u3088\u3046\u4fee\u6b63\u3057\u307e\u3059<\/li>\n<li>\u3044\u3061\u3054\u3092\u597d\u304d\u3068\u7b54\u3048\u305f\u4eba\uff08\uff13\u4eba\uff09\u3092\uff05\u8868\u793a\u306b\u76f4\u3057\u307e\u3059<\/li>\n<li>\uff13\u306e\u4e0b\u306b=\uff08\u30a4\u30b3\u30fc\u30eb\uff09\u3092\u534a\u89d2\u3067\u5165\u529b<\/li>\n<li>B3\uff08\uff13\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\uff09\u3092\u30af\u30ea\u30c3\u30af<\/li>\n<li>\/\uff08\u30b9\u30e9\u30c3\u30b7\u30e5\uff09\u3092\u534a\u89d2\u3067\u5165\u529b<\/li>\n<li>D3\uff08\uff15\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\uff09\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/06-percent1.png\" alt=\"06-percent1\" \/><\/li>\n<li>Enter\u3092\u62bc\u3059\u3068\u3001\u8a08\u7b97\u3057\u305f\u7d50\u679c\uff080.6\uff09\u304c\u8868\u793a\u3055\u308c\u307e\u3059<\/li>\n<li>\u540c\u69d8\u306b\u3057\u3066\u3001\u308a\u3093\u3054\u3092\u597d\u304d\u3068\u7b54\u3048\u305f\u4eba\uff082\u4eba\uff09\u3092\uff05\u8868\u793a\u306b\u76f4\u3057\u307e\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/07-percent2.png\" alt=\"07-percent2\" \/><\/li>\n<li>\uff12\u3064\u3092\u30c9\u30e9\u30c3\u30b0\u3001\u9078\u629e\u3057\u307e\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/08-drag.png\" alt=\"08-drag\" \/><\/li>\n<li>\uff05\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/09-icon.png\" alt=\"09-icon\" \/><\/li>\n<li>Increase Decimal\uff08\u5c0f\u6570\u70b9\u4ee5\u4e0b\u3092\u5897\u3084\u3059\uff09\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/10-increase-decimal.png\" alt=\"10-increase-decimal\" \/><\/li>\n<li>60.0%\u300140.0%\u3068\u305d\u308c\u305e\u308c\u8868\u793a\u3055\u308c\u307e\u3059<\/li>\n<li>\u3044\u3061\u3054\u3068\u308a\u3093\u3054\u304c\u6a2a\u306b\u4e26\u3073\u3001\u4e00\u756a\u4e0b\u306b\u6bd4\u7387\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u666e\u901a\u3001\u7e26\u306b\u679c\u7269\u306e\u540d\u524d\u3001\u6a2a\u306b\u6bd4\u7387\u304c\u6765\u307e\u3059\u306e\u3067\u3001\u7e26\u3068\u6a2a\u3092\u53cd\u8ee2\u3057\u307e\u3057\u3087\u3046\n<ol>\n<li>\u8868\u3092\u30c9\u30e9\u30c3\u30b0<\/li>\n<li>\u53f3\u30af\u30ea\u30c3\u30af\u3001Copy\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/11-copy.png\" alt=\"11-copy\" \/><\/li>\n<li>\u4e0b\u306e\u7a7a\u3044\u3066\u3044\u308b\u3068\u3053\u308d\u3092\u53f3\u30af\u30ea\u30c3\u30af<\/li>\n<li>Transpose\uff08\u53cd\u8ee2\uff09\u3092\u30af\u30ea\u30c3\u30af<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/12-transrate.png\" alt=\"12-transrate\" \/><\/li>\n<\/ol>\n<\/li>\n<li>\u7e26\u306b\u679c\u7269\u306e\u540d\u524d\u304c\u4e26\u3073\u307e\u3057\u305f<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/13-table.png\" alt=\"13-table\" \/><\/li>\n<li>\u30bf\u30a4\u30c8\u30eb\u306a\u3069\u3092\u5165\u529b\u3057\u3066\u5b8c\u6210\u3067\u3059<br \/>\n<img decoding=\"async\" src=\"..\/..\/etc\/web-excel\/gt\/14-fin.png\" alt=\"14-fin\" \/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u5358\u7d14\u96c6\u8a08\uff08GT\u96c6\u8a08\uff1agrand total\uff09\u3092\u5f97\u305f\u3044\u3068\u304d choices\uff08\u9078\u629e\u80a2\uff09\u306b\u3088\u308b\u8abf\u67fb\u7968\u306e\u4f5c\u6210 \u4f8b\u3068\u3057\u3066\u3001\u597d\u304d\u306a\u98df\u3079\u7269\u3092\u304d\u304f\u8cea\u554f\u3092\u4f5c\u6210\u3057\u307e\u3059 choices\uff08\u9078\u629e\u80a2\uff09\u3092\u9078\u3073\u307e\u3059 1\u756a\u4e0a\u306b\u8cea\u554f\u3092\u5165\u529b\u3001\u4e0b\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.hpymt.net\/tsu\/web-excel-pivot-table2\/\">\u7d9a\u304d\u3092\u8aad\u3080 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,10,11,13,14,16,18,269],"tags":[310,170,309,311],"class_list":{"0":"post-6071","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-ict","7":"category-lecture","8":"category-mac","9":"category-nyumon","10":"category-pctips","11":"category-software","12":"category-web-tips","13":"category-269","14":"tag-excel-web","15":"tag-web","17":"tag-webexcel"},"_links":{"self":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts\/6071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/comments?post=6071"}],"version-history":[{"count":7,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts\/6071\/revisions"}],"predecessor-version":[{"id":6412,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts\/6071\/revisions\/6412"}],"wp:attachment":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/media?parent=6071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/categories?post=6071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/tags?post=6071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}