Excel для экономистов. 10 статей про отчеты, сверки, сопоставления - Наталья Лидл

Скачать книгу

и различия видны сразу. На практике количество контрагентов в разы больше, и различия могут быть не так очевидны.

      Быстро выявить отклонения можно двумя способами:

      1. Выделить сводную таблицу (область выделения должна быть больше самой таблицы) и вставить ее как значение. Форматы пропадут, данные останутся, и с ними можно будет делать любые расчеты и преобразования.

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQEAZABkAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIfIiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAJJA6UDASIAAhEBAxEB/8QAGwABAQADAQEBAAAAAAAAAAAAAAUDBAYCBwH/xABeEAABAwMBAwQNBgkICAUCBgMBAgMEAAUREgYTIRQVMdMWIkFRU1VWYZKTlJXRMlJUkdLUByM2cXSBobKzMzVCRXWDscIXJGJyc6W04TRDY6LBJUQmN2SCo8PwZYX/xAAbAQEBAAIDAQAAAAAAAAAAAAAAAQIDBAYHBf/EADoRAQABAQMIBgoCAwADAQAAAAABEQID8BMhMUFRYdHhEmOBkaGxBAUVFjI0UnGiwRQzIiPxBkJiQ//aAAwDAQACEQMRAD8A6a3wLSu2xlubPPurUygqcGcLOBk/L7tbHNtm8mpH7ft14t382Rf+Cj90VsdNfVvJt9Of8p07ZL/0m9i9tR0p0zr3sRt1lAydmn/2/br0i1WZaErTs6spUMg7wdHrK3Hoqo6GVLPbOE9r3uivcZeIrQ/2E/4V8z0z029uOj0bVa11zqpvbvR7V5eV6Vqc1NbR5os/k4v1o6ynNFn8nF+tHWVT1011wfa1/t8Z4uRk7f1z3pnNFn8nF+tHWU5os/k4v1o6yqeumunta/2+M8TJ2/rnvTOaLP5OL9aOspzRZ/JxfrR1lU9dNdPa1/t8Z4mTt/XPemc0WfycX60dZTmiz+Ti/WjrK/Xr0Gbw3ALOUKACntXBK1BRSnGO6Enu90d+qWurPrT0iNM+M8Uixan/AN570zmiz+Ti/WjrKc0WfycX60dZVPXTXU9rX+3xniuTt/XPemc0WfycX60dZTmiz+Ti/WjrKp66a6e1r/b4zxMnb+ue9M5os/k4v1o6yvxdqsyEKWrZ1YSkZJ3g6PWVU11ikrzFdH+wr/CpPra/pp8Z4rF3bmfjnvaPNFn8nF+tHWU5os/k4v1o6yqeumur7Wv9vjPFMnb+ue9M5os/k4v1o6ynNFn8nF+tHWVT10109rX+3xniZO39c96ZzRZ/JxfrR1lOaLP5OL9aOsqnrprp7Wv9vjPEydv6570zmiz+Ti/WjrKc0WfycX60dZVPXWlc7i7BbYLLKXnH3ktJStzQATniSAe93qR619ImaRPjPFJsWois2572Hmiz+Ti/WjrKc0WfycX60dZWe23Fc5p3eshl1h1TS0pXrTkd0KwMjj3h3a3NdWfWvpETSZ8Z4kWLU6Lc96ZzRZ/JxfrR1lOaLP5OL9aOsqnrprqe1r/b4zxXJ2/rnvTOaLP5OL9aOspzRZ/JxfrR1lU9dNdPa1/t8Z4mTt/XPemc0WfycX60dZTmiz+Ti/WjrKp66a6e1r/b4zxMnb+ue9ot2C2OtJcRs0soWkKSd8OIP95Xrsct3kyv1yetq3Acxb4w/wDST/gKz73z19Ox6TezZia+M8XEtXl5FqY6c97nexy3eTK/XJ62nY5bvJlfrk9bXRb3z03vnrLL3u2e+eLHK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+emXvds988TK3n1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPWvPuTdvhqkOJWvBCUoQMqWokBKR5ySBT+Re7Z75MrefXPei9jlu8mV+uT1tOxy3eTK/XJ62q8OXcHFqTNhNMDSClTMjeg+Y5Skg/WPPW3vfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPTL3u2e+eJlbz6573Nt2C2OtpcRs0spUAQd8OIP95Xrsct3kyv1yetq5DcxBYH/pp/wrNvfPVy97tnvniZW9+ue9zvY5bvJlfrk9bTsct3kyv1yetrot756b3z1Mve7Z754mVvPrnvc72OW7yZX65PW07HLd5Mr9cnrayq2kmIRLlG2tqhQ3lturRJJd0p6VBBQAR3cas1cS+laQpKspUMgjuin8i9pWs988TK3ladOe9z3Y5bvJlfrk9bTsct3kyv1yetrot756b3z0y97tnvniZW8+ue9zblgtjTanF7NLCUgknfDgB/eV67HLd5Mr9cnrauTHMwXx/wCmr/Cs2989XL3u2e+eJlb36573O9jlu8mV+uT1tOxy3eTK/XJ62ui3vnpvfPUy97tnvniZW8+ue9zvY5bvJlfrk9bTsct3kyv1yetrot756b3z0y97tnvniZW8+ue9zvY5bvJlfrk9bTsct3kyv1yetreh3W4TZLuiFGTFafWyXFSlazpOCdO7x+rVVTe+en8i901nvniZW8+ue9zvY5bvJlfrk9bTsct3kyv1yetrot756b3z0y97tnvniZW8+ue9zvY5bvJlfrk9bXlywWxptTi9mlhKQSTvhwA/vK6Te+esMxzMF8f+mr/CrF/e7Z754mVvfrnvQ+xy3eTK/XJ62nY5bvJlfrk9bXRb3z03vnqZe92z3zxMrefXPe53sct3kyv1yetp2OW7yZX65PW10W989N756Ze92z3zxMrefXPe53sct3kyv1yetp2OW7yZX65PW10W989N756Ze92z3zxMrefXPe53sct3kyv1yetp2OW7yZX65PW1vxLrOmTHkohx0xWX1MqcVJVrOO6EaMf+6qe989P5F7prPfPEyt59c97nexy3eTK/XJ62nY5bvJlfrk9bXRb3z03vnpl73bPfPEyt59c97nexy3eTK/XJ62nY5bvJlfrk9bXRb3z03vnpl73bPfPEyt59c97m3LBbGm1OL2aWEpBJO+HAD+8r12OW7yZX65PW1cmOZgvj/wBNX+FZt756uXvds988TK3v1z3ud7HLd5Mr9cnradjlu8mV+uT1tdFvfPTe+epl73bPfPEyt59c97nexy3eTK/XJ62nY5bvJlfrk9bVSfdVxn2YkVgSJb4KkIU5oSlKcalKVg4HEDgCST+fGaHJlONq5ZGQw4lWMNu7xKhjpBwD5uIHR+umXvds988TK3n1z3uA2wt0e38j5PbFQd5r1ZWFa8ae8pXRnzdNKo/hGVq5u/vf8lK7Z6utTa9FszO/zl3/ANTTM+g2Jma6fOWe3fzZF/4KP3RVKIthk7xasr7gweFZLPBjrssFSkKyqO2T26vmjz1nDFvVIVGS4kvoSFKaDx1AHoJGc4rrN9bibcxveeX1mYvrU7582tMkpkKa0nOknufmrXYXiO2P9gf4VW5vjfMV6xXxrJDs8FyEwtTSipTaSfxqxxx+evken3Fq+ixk9VdO+jkei3kXfS6eumhJ1011c5kt/gV+uX8acyW/wK/XL+NfN/gX22PHg5f8i7347UPXTXVzmS3+BX65fxpzJb/Ar9cv40/gX22PHgfyLvfjtQ9dNdXOZLf4Ffrl/GnMlv8AAr9cv40/gX22PHgfyLvfjtcK7Y5bzElw3BSJLz2/ShISWwpJGjJKdWAEpzg9+rqXFaRqwFY446M1d5kt/gV+uX8acyW/wK/XL+NZWvQ/SLWaZjHYxi+uomsVx2oeumurnMlv8Cv1y/jTmS3+BX65fxrH+BfbY8eDL+Rd78dqHrprq5zJb/Ar9cv405kt/gV+uX8afwL7bHjwP5F3vx2oeusb68x3B/sH/Cug5kt/gV+uX8a/DZLeRgsqIP8A6q/jU/gX22PHgsek3cTrx2omumurnMlv8Cv1y/jTmS3+BX65fxq/wL7bHjwT+Rd78dqHrprq5zJb/Ar9cv405kt/gV+uX8afwL7bHjwP5F3vx2oeumurnMlv8Cv1y/jTmS3+BX65fxp/AvtsePA/kXe/Hah66nXqGu4xmW0NMPbt9Lim3zhKwM8DwPf71dbzJb/Ar9cv405kt/gV+uX8atn0K/szWJjx4JN/dTFM+O1ydoiOQUv60Mspdc1IjsEltoYAwOA6SM9A6aoa6ucyW/wK/XL+NOZLf4Ffrl/Glr0K/tTWZjx4Fm/uoikVx2oeumurnMlv8Cv1y/jTmS3+BX65fxqfwL7bHjwX+Rd78dqHrprq5zJb/Ar9cv405kt/gV+uX8afwL7bHjwP5F3vx2oeumurnMlv8Cv1y/jTmS3+BX65fxp/AvtsePA/kXe/Ha0YbmITA/8ATT/hWbe+etpNphpSEpbWABgAOr4ftr95rifMc9cv419yxSzZiJfOtVm1MtTe+em989bfNcT5jnrl/GnNcT5jnrl/GsulDGktTe+em989bfNcT5jnrl/GnNcT5jnrl/GnSgpLU3vnpvfPW3zXE+Y565fxpzXE+Y565fxp0oKS1N756b3z1t81xPmOeuX8ac1xPmOeuX8adKCktTe+em989bfNcT5jnrl/GnNcT5jnrl/GnSgpLU3vnpvfPW3zXE+Y565fxpzXE+Y565fxp0oKS1N756b3z1t81xPmOeuX8ac1xPmOeuX8adKCktTe+em989bfNcT5jnrl/GnNcT5jnrl/GnSgpLU3vnpvfPW3zXE+Y565fxpzXE+Y565fxp0oKS1N7560rrFVcYJZQ4G3UrQ40sjIC0qCk5HdGRVjmuJ8xz1y/jTmuJ8xz1y/jSsFJSYb9yWtRmtRWkhIwGXVOEnunJSnA82D+etve+etvmuJ8xz1y/jTmuJ8xz1y/jTpQUlqb3z03vnrb5rifMc9cv405rifMc9cv406UFJam989N7562+a4nzHPXL+NOa4nzHPXL+NOlBSWpvfPTe+etvmuJ8xz1y/jTmuJ8xz1y/jTpQUlqb3z03vnrb5rifMc9cv405rifMc9cv406UFJam989N7562+a4nzHPXL+NOa4nzHPXL+NOlBSWpvfPTe+etvmuJ8xz1y/jTmuJ8xz1y/jTpQUlqb3z03vnrb5rifMc9cv405rifMc9cv406UFJam989N7562+a4nzHPXL+NOa4nzHPXL+NOlBSWpvfPTe+etvmuJ8xz1y/jTmuJ8xz1y/jTpQUlqb3z03vnrb5rifMc9cv405rifMc9cv406UFJT4rmIjI/2E/wCFZd7562xaoYAAbWAOgB1fxpzXE+Y565fxp0oKS1N756b3z1t81xPmOeuX8ac1xPmOeuX8adKCkuUNuuhj3CAOSojTnnFKf3qlLShfSNGkDOOHyvr6KvNlLTaW08EpAA/MK3ea4nzHPXL+NOa4nzHPXL+NImIih0Zam989N7562+a4nzHPXL+NOa4nzHPXL+NOlBSU+U5mI8P9hX+FZd7562zaoZBBbWQekF1fxpzXE+Y565fxp0oKS1N756b3z1t81xPmOeuX8ac1xPmOeuX8adKCktTe+em989bfNcT5jnrl/GnNcT5jnrl/GnSgpLl4NrdiXR2Sq2W1xTkhbgl6zvkpUTwxu+8cfKq7vfPW3zXE+Y565fxpzXE+Y565fxpWKUKTWrU3vnpvfPW3zXE+Y565fxpzXE+Y565fxp0oKS1N756xSnMxHh/sK/wqhzXE+Y565fxqZtPFagbKXeZG1ofjwXnW1FxStKkoJBwTg8R3adKCktje+em989bfNcT5jnrl/GnNcT5jnrl/GnSgpLU3vnpvfPW3zXE+Y565fxpzXE+Y565fxp0oKS1N756b3z0uaLdaoKpTzT6wFJQhttxRW4tRCUpSNXSSQOJA75AqcLtbOTuFdtuLcxEhMbkKnBvlOKTqABDmggp7bOrAAOSMU6UFJeIFpjRpkia9GjKlOSFuIfDYK0pPQNWM9+qm989TZd92dg7Oi9yi+00QoBhTit8VpJCmwnVxUCCDg4GCc441YkRbdFhuS3yttlpsuLWXV9qkDJPT3qdKzEfY6M1+7DvfPTe+epiL3aORSX37fcYzsfdERnVHeuh04bKQlZHbHhxIwQc4rOiXHeircj2S5PSGXd0/ES+2l1g41dtqdCSCCCClR6R58KwUlub3z03vnrFY1wL7a0XBqHLjtuKUEpfd4qAONQ0rUCDjgQeI49FakO62qW25IMC4sQUNLeROdKty6hHSoELJHDiNQTkcRmnSiFpLblOZiPD/AGFf4Vl3vnqLcZyHtlL1MYtlytz8a3OSGFy+hX4tRSoYUodI4pVxHDI410vNcT5jnrl/GlYSktTe+em989bfNcT5jnrl/GnNcT5jnrl/GnSgpKFcYr7sxidE3KnmkLaU0+SEOIURkZAOD2o44PerxYreq1tytTMeOJD5dSzGOUNjSlOAdKfm56B010HNcT5jnrl/GnNcT5jnrl/GkWogmzMuD2/Vq5B/ef5aVm/CNFZjc3boKGre5ysq+Z3zSu3+rflbHb5y9D9S/IXfb5y6Wy/zHA/Rm/3RUiPMtTW2rrLEmIha4ulSELSCp3eEkED

Скачать книгу