{"id":2702,"date":"2020-10-02T09:00:29","date_gmt":"2020-10-02T00:00:29","guid":{"rendered":"https:\/\/www.n-create.co.jp\/pr\/column\/?p=2702"},"modified":"2024-11-07T10:45:19","modified_gmt":"2024-11-07T01:45:19","slug":"excel-technique_7","status":"publish","type":"column","link":"https:\/\/www.n-create.co.jp\/pr\/column\/other\/excel-technique_7\/","title":{"rendered":"\u7b2c7\u56de \u899a\u3048\u3066\u304a\u304f\u3068\u91cd\u5b9d\u3059\u308bExcel\u30c6\u30af\u30cb\u30c3\u30af"},"content":{"rendered":"

\"\u7b2c7\u56de<\/p>\n

\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u306e\u554f\u3044\u5408\u308f\u305b\u30d5\u30a9\u30fc\u30e0\u3067\u90fd\u9053\u5e9c\u770c\u3084\u751f\u5e74\u6708\u65e5\u3092\u5165\u529b\u3059\u308b\u3068\u304d\u306b\u3001\u9078\u629e\u5f0f\u306e\u30e1\u30cb\u30e5\u30fc\u304c\u5229\u7528\u3055\u308c\u3066\u3044\u308b\u306e\u3092\u898b\u304b\u3051\u308b\u3068\u601d\u3044\u307e\u3059\u3002
\n\u300c\u30d7\u30eb\u30c0\u30a6\u30f3\u30e1\u30cb\u30e5\u30fc\u300d\u3084\u300c\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u300d\u3068\u547c\u3070\u308c\u307e\u3059\u304c\u3001\u540c\u3058\u3082\u306e\u3092\u30a8\u30af\u30bb\u30eb\u3067\u3082\u4f5c\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u7269\u4ef6\u306e\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u72b6\u6cc1\u306e\u9032\u6357\u7ba1\u7406\u3084\u3001\u304a\u554f\u3044\u5408\u308f\u305b\u306e\u5bfe\u5fdc\u72b6\u6cc1\u306a\u3069\u3092\u30a8\u30af\u30bb\u30eb\u3067\u7ba1\u7406\u3057\u3066\u3044\u308b\u5834\u5408\u306b\u3001\u5bfe\u5fdc\u72b6\u6cc1\u3084\u9032\u6357\u3092\u5165\u529b\u3059\u308b\u3068\u3053\u308d\u306b\u9078\u629e\u5f0f\u30e1\u30cb\u30e5\u30fc\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u7d20\u65e9\u304f\u6b63\u78ba\u306b\u767b\u9332\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\u4eca\u56de\u306f\u3053\u306e\u9078\u629e\u5f0f\u30e1\u30cb\u30e5\u30fc\u3092\u30a8\u30af\u30bb\u30eb\u3067\u4f5c\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002
\n\u203bExcel2003\u4ee5\u964d\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u9078\u629e\u80a2\u3092\u76f4\u63a5\u5165\u529b\u3057\u3066\u4f5c\u308b<\/h2>\n

\u2460 \u9078\u629e\u5f0f\u30e1\u30cb\u30e5\u30fc\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u7bc4\u56f2\u3092\u9078\u3073\u307e\u3059\u3002<\/p>\n

\u2461 \uff3b\u30c7\u30fc\u30bf\uff3d\u30bf\u30d6\u2192\uff3b\u30c7\u30fc\u30bf\u30c4\u30fc\u30eb\uff3d\u30b0\u30eb\u30fc\u30d7\u306e\uff3b\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247\uff3d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\n\u203bExcel2003\u306f\u30e1\u30cb\u30e5\u30fc\u30d0\u30fc\u306e\uff3b\u30c7\u30fc\u30bf\uff3d\u2192\uff3b\u5165\u529b\u898f\u5247\uff3d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n

\"Excel7-1\"<\/p>\n

\u2462 \u300c\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\uff3b\u8a2d\u5b9a\uff3d\u30bf\u30d6\u306e\uff3b\u5165\u529b\u5024\u306e\u7a2e\u985e\uff3d\u306e\u300c\u25bc\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u300c\u30ea\u30b9\u30c8\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n

\u2463 \uff3b\u5143\u306e\u5024\uff3d\u6b04\u306b\u9078\u629e\u80a2\u3068\u306a\u308b\u5358\u8a9e\u3092\u3001\u300c,\u300d\uff08\u534a\u89d2\u30ab\u30f3\u30de\uff09\u3067\u533a\u5207\u308a\u306a\u304c\u3089\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n

\u2464 \uff3bOK\uff3d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n

\"Excel7-2\"<\/p>\n

\u2465 \u9078\u629e\u30ea\u30b9\u30c8\u3092\u8a2d\u5b9a\u3057\u305f\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30bb\u30eb\u306e\u53f3\u5074\u306b\u300c\u25bc\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002
\n\u300c\u25bc\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u2463\u3067\u5165\u529b\u3057\u305f\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n

\"Excel7-3\"<\/p>\n

 <\/p>\n

\u5165\u529b\u6e08\u307f\u306e\u30c7\u30fc\u30bf\u3092\u9078\u629e\u80a2\u306b\u5229\u7528\u3059\u308b<\/h2>\n

\u3059\u3067\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u30ea\u30b9\u30c8\u306b\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002
\n\u90fd\u9053\u5e9c\u770c\u306a\u3069\u9805\u76ee\u6570\u304c\u591a\u3044\u5834\u5408\u306f\u76f4\u63a5\u5165\u529b\u3059\u308b\u3088\u308a\u3082\u3001\u4e88\u3081\u30a8\u30af\u30bb\u30eb\u306b\u5165\u529b\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3059\u308b\u307b\u3046\u304c\u767b\u9332\u304c\u3050\u3063\u3068\u697d\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\u2460 \u4e88\u3081\u9078\u629e\u80a2\u306b\u3057\u305f\u3044\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u3066\u304a\u304d\u307e\u3059\u3002\uff08\u2605\u30ea\u30b9\u30c8\u306b\u3059\u308b\u7bc4\u56f2\uff09<\/p>\n

\u2461 \u9078\u629e\u30ea\u30b9\u30c8\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u3073\u307e\u3059\u3002<\/p>\n

\u2462[\u30c7\u30fc\u30bf]\u30bf\u30d6\u2192[\u30c7\u30fc\u30bf\u30c4\u30fc\u30eb]\u30b0\u30eb\u30fc\u30d7\u306e[\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247]\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\n\u203bExcel2003\u306f\u30e1\u30cb\u30e5\u30fc\u30d0\u30fc\u306e[\u30c7\u30fc\u30bf]\u2192[\u5165\u529b\u898f\u5247]\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n

\"Excel7-4\"<\/p>\n

\u2463\u300c\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001[\u8a2d\u5b9a]\u30bf\u30d6\u306e[\u5165\u529b\u5024\u306e\u7a2e\u985e]\u306e\u300c\u25bc\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u300c\u30ea\u30b9\u30c8\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n

\"Excel7-5\"<\/p>\n

\u2464 [\u5143\u306e\u5024]\u6b04\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u300c\u2605\u30ea\u30b9\u30c8\u306b\u3059\u308b\u7bc4\u56f2\u300d\u3092\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<\/p>\n

\u203b\u6307\u5b9a\u3067\u304d\u308b\u7bc4\u56f2\u306f\uff11\u5217\u306e\u307f\u3067\u3059\u3002<\/p>\n

\u2465\uff3bOK\uff3d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n

\u2466\u9078\u629e\u30ea\u30b9\u30c8\u3092\u8a2d\u5b9a\u3057\u305f\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30bb\u30eb\u306e\u53f3\u5074\u306b\u300c\u25bc\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\u300c\u25bc\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u2463\u3067\u5165\u529b\u3057\u305f\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n

\"Excel7-6\"<\/p>\n","protected":false},"featured_media":12856,"template":"","column_category":[588,594],"column_tag":[609,640,693,785,786,799,800,826,857,1033,1188,1194],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column\/2702"}],"collection":[{"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column"}],"about":[{"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/types\/column"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/media\/12856"}],"wp:attachment":[{"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/media?parent=2702"}],"wp:term":[{"taxonomy":"column_category","embeddable":true,"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column_category?post=2702"},{"taxonomy":"column_tag","embeddable":true,"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column_tag?post=2702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}