{"id":1402,"date":"2018-10-24T09:00:44","date_gmt":"2018-10-24T00:00:44","guid":{"rendered":"https:\/\/www.n-create.co.jp\/pr\/column\/?p=1402"},"modified":"2024-11-07T10:53:40","modified_gmt":"2024-11-07T01:53:40","slug":"excel-technique_5","status":"publish","type":"column","link":"https:\/\/www.n-create.co.jp\/pr\/column\/other\/excel-technique_5\/","title":{"rendered":"\u7b2c5\u56de \u899a\u3048\u3066\u304a\u304f\u3068\u91cd\u5b9d\u3059\u308bExcel\u30c6\u30af\u30cb\u30c3\u30af"},"content":{"rendered":"

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

\u7279\u6b8a\u6587\u5b57\u3092\u3054\u5b58\u77e5\u3067\u3059\u304b\uff1f<\/span><\/h2>\n

\u329e\u3084\u329f\u306a\u3069\u3001\u8a18\u53f7\u3068\u6587\u5b57\u304c\u7d44\u307f\u5408\u308f\u3055\u3063\u305f\u6587\u5b57\u306e\u3053\u3068\u3092\u300c\u7279\u6b8a\u6587\u5b57\u300d\u3068\u547c\u3073\u307e\u3059\u3002<\/span><\/p>\n

\u666e\u6bb5\u304b\u3089\u30d3\u30b8\u30cd\u30b9\u6587\u66f8\u306a\u3069\u3067\u898b\u304b\u3051\u308b\u3053\u3068\u3082\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u3044\u3056\u81ea\u5206\u304c\u6587\u66f8\u3092\u4f5c\u308b\u3068\u306a\u3063\u305f\u3068\u304d\u306b\u3001\u5165\u529b\u306e\u4ed5\u65b9\u304c\u5206\u304b\u3089\u306a\u304f\u3066\u56f0\u3063\u305f\u65b9\u3082\u3044\u3089\u3063\u3057\u3083\u308b\u306e\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/span><\/p>\n

\"Excel1\"<\/p>\n

Excel<\/span>\u306b\u306f\u7279\u6b8a\u6587\u5b57\u3084\u30ad\u30fc\u30dc\u30fc\u30c9\u304b\u3089\u5165\u529b\u3067\u304d\u306a\u3044\u8a18\u53f7\u3092\u5165\u529b\u3059\u308b\u305f\u3081\u306e\u5c02\u7528\u306e\u30b3\u30de\u30f3\u30c9\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u329e\u3082\u329f\u3082\u7c21\u5358\u306b\u5165\u529b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

\u7279\u6b8a\u6587\u5b57\u3092\u5165\u529b\u3057\u3088\u3046<\/span><\/h2>\n
\n
    \n
  1. \u7279\u6b8a\u6587\u5b57\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u6240\uff08\u30bb\u30eb\uff09\u3092\u9078\u629e\u3057\u307e\u3059\u3002\"Excel2\"<\/li>\n
  2. \u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span>
    \n\"Excel3\"<\/span><\/p>\n
      \n
    1. \u203b1.Excel2002\u30012003\u3092\u3054\u5229\u7528\u306e\u5834\u5408\u306f\u3001\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u633f\u5165\u300d\u2192\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span><\/span><\/li>\n
    2. \u203b2.Excel2007\u4ee5\u964d\u3092\u3054\u5229\u7528\u3067\u3001\u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u4e2d\u306b\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u306f\u3001\u4e0b\u8a18\u306e\u8a2d\u5b9a\u3092\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002<\/span><\/span>\n
        \n
      1. \uff081\uff09\u30ea\u30dc\u30f3\u4e0a\u306e\u3069\u3053\u304b\u306b\u30de\u30a6\u30b9\u30dd\u30a4\u30f3\u30bf\u3092\u7f6e\u3044\u3066\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u30e1\u30cb\u30e5\u30fc\u306e\u4e2d\u304b\u3089\u300c\u30ea\u30dc\u30f3\u306e\u30e6\u30fc\u30b6\u30fc\u8a2d\u5b9a\uff08R\uff09…\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002
        \n\u300cExcel\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/span><\/span><\/li>\n
      2. \uff082\uff09\u53f3\u5074\u306e\u300c\u30ea\u30dc\u30f3\u306e\u30e6\u30fc\u30b6\u30fc\u8a2d\u5b9a(B):\u300d\u304b\u3089\u300c\u30e1\u30a4\u30f3\u30bf\u30d6\u300d\u3092\u9078\u3073\u3001\u4e0b\u306e\u4e00\u89a7\u304b\u3089\u300c\u633f\u5165\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/span><\/span><\/li>\n
      3. \uff083\uff09\u5de6\u5074\u306e\u300c\u30b3\u30de\u30f3\u30c9\u306e\u9078\u629e(C):\u300d\u3067\u300c\u30e1\u30a4\u30f3\u30bf\u30d6\u300d\u3092\u9078\u3073\u307e\u3059\u3002\u300c\u633f\u5165\u300d\uff1e\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u306e\u9806\u3067\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3001\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/span><\/span><\/li>\n
      4. \uff084\uff09\u771f\u3093\u4e2d\u306b\u3042\u308b\u300c\u8ffd\u52a0\uff08A\uff09\uff1e\uff1e\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
        \n(2)\u3067\u9078\u629e\u3057\u305f\u300c\u633f\u5165\u300d\u306e\u3068\u3053\u308d\u306b\u3001\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/span><\/span><\/li>\n
      5. \uff085\uff09\u300cOK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3092\u9589\u3058\u307e\u3059\u3002<\/span><\/span><\/li>\n
      6. \uff086\uff09\u300c\u633f\u5165\u300d\u30bf\u30d6\u306b\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
      7. \u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u3044\u305f\u3089\u3001\u300c\u7a2e\u985e\uff1a<\/span>(U)<\/span>\u300d\u306e\u53f3\u96a3\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u7a2e\u985e\u540d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30d7\u30eb\u30c0\u30a6\u30f3\u30e1\u30cb\u30e5\u30fc\u304c\u958b\u304f\u306e\u3067\u3001\u4e0a\u4e0b\u306b\u30b9\u30af\u30ed\u30fc\u30eb\u3057\u3066\u300c<\/span>(<\/span>\u682a<\/span>)\/(<\/span>\u6709<\/span>)<\/span>\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/span><\/li>\n
      8. \u4e0b\u306b\u8868\u793a\u3055\u308c\u305f\u6587\u5b57\u306e\u4e00\u89a7\u8868\u306e\u4e2d\u304b\u3089\u3001\u5165\u529b\u3057\u305f\u3044\u7279\u6b8a\u6587\u5b57\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/span>
        \n\"Excel4\"<\/span><\/li>\n
      9. \u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u306e\u53f3\u4e0b\u306b\u3042\u308b\u300c\u633f\u5165(I)<\/span>\u300d\u30dc\u30bf\u30f3\u3092<\/span>1<\/span>\u56de\u3060\u3051\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
        \n<\/span><\/span>\u300c\u633f\u5165(I)<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u4f55\u5ea6\u3082\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30af\u30ea\u30c3\u30af\u3057\u305f\u56de\u6570\u5206\u3001\u7279\u6b8a\u6587\u5b57\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002<\/span><\/li>\n
      10. \u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3092\u9589\u3058\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div>\n

        1.<\/span>\u3067\u9078\u629e\u3057\u305f\u30bb\u30eb\u306b\u3001<\/span>4.<\/span>\u3067\u9078\u629e\u3057\u305f\u7279\u6b8a\u6587\u5b57\u304c\u5165\u529b\u3055\u308c\u307e\u3057\u305f\u3002<\/span><\/p>\n

        \u30b3\u30d4\u30fc\u30e9\u30a4\u30c8\u30de\u30fc\u30af\u306f\u3069\u3053\uff1f<\/span><\/h2>\n

        \u5148\u7a0b\u306e\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u306b\u898b\u5f53\u305f\u3089\u306a\u3044\u8a18\u53f7\u3082\u3042\u308a\u307e\u3059\u3002<\/span><\/p>\n

        \u4f8b\u3048\u3070\u3001\u30b3\u30d4\u30fc\u30e9\u30a4\u30c8\u3092\u793a\u3059\u300c\u00a9\ufe0f\u300d\u306f\u3001\u5148\u7a0b\u306e\u4e00\u89a7\u306e\u4e2d\u306b\u306f\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3002<\/span><\/p>\n

        \n
          \n
        1. \u7279\u6b8a\u6587\u5b57\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u6240\uff08\u30bb\u30eb\uff09\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/span>
          \n<\/span>\"Excel2\"<\/li>\n
        2. \u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span>
          \n<\/span>\"Excel3\"<\/p>\n
            \n
          1. \u203b1.Excel2002\u30012003\u3092\u3054\u5229\u7528\u306e\u5834\u5408\u306f\u3001\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u633f\u5165\u300d\u2192\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span><\/li>\n
          2. \u203b2.Excel2007\u4ee5\u964d\u3092\u3054\u5229\u7528\u3067\u3001\u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u4e2d\u306b\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u306f\u3001\u5148\u7a0b\u306e\u300c\u7279\u6b8a\u6587\u5b57\u3092\u5165\u529b\u3057\u3088\u3046\u300d\u306e2.\uff1e \u203b2 \uff1e(1)\uff5e(6)\u3092\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002<\/span><\/li>\n<\/ol>\n<\/li>\n
          3. \u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u3044\u305f\u3089\u3001\u5de6\u4e0a\u306e\u300c\u7279\u6b8a\u6587\u5b57<\/span>(P)<\/span>\u300d\u306e\u30bf\u30d6\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span><\/li>\n
          4. \u4e0b\u306b\u8868\u793a\u3055\u308c\u305f\u6587\u5b57\u306e\u4e00\u89a7\u8868\u306e\u4e2d\u304b\u3089\u3001\u5165\u529b\u3057\u305f\u3044\u7279\u6b8a\u6587\u5b57\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/span>\"Excel5\"<\/li>\n
          5. \u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u306e\u53f3\u4e0b\u306b\u3042\u308b\u300c\u633f\u5165<\/span>(I)<\/span>\u300d\u30dc\u30bf\u30f3\u3092<\/span>1<\/span>\u56de\u3060\u3051\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/span>
            \n<\/span>\u300c\u633f\u5165<\/span>(I)<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u4f55\u5ea6\u3082\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30af\u30ea\u30c3\u30af\u3057\u305f\u56de\u6570\u5206\u3001\u7279\u6b8a\u6587\u5b57\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002<\/span><\/li>\n
          6. \u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3092\u9589\u3058\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div>\n

            \u4eca\u56de\u3054\u7d39\u4ecb\u3057\u305f\u6587\u5b57\u4ee5\u5916\u306b\u3082\u3001\u69d8\u3005\u306a\u8a18\u53f7\u3084\u7279\u6b8a\u6587\u5b57\u304c\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304b\u3089\u5165\u529b\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

            \u5165\u529b\u65b9\u6cd5\u306b\u8ff7\u3063\u305f\u3068\u304d\u306f\u3001\u300c\u8a18\u53f7\u3068\u7279\u6b8a\u6587\u5b57\u300d\u3092\u5229\u7528\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n","protected":false},"featured_media":13048,"template":"","column_category":[588,594],"column_tag":[609,640,1108],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column\/1402"}],"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\/13048"}],"wp:attachment":[{"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/media?parent=1402"}],"wp:term":[{"taxonomy":"column_category","embeddable":true,"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column_category?post=1402"},{"taxonomy":"column_tag","embeddable":true,"href":"https:\/\/www.n-create.co.jp\/pr\/wp-json\/wp\/v2\/column_tag?post=1402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}