ВПР и Сводные таблицы Excel. Сергей Заидович Карамов

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

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

/9j/4AAQSkZJRgABAQAAAQABAAD/4gxYSUNDX1BST0ZJTEUAAQEAAAxITGlubwIQAABtbnRyUkdCIFhZWiAHzgACAAkABgAxAABhY3NwTVNGVAAAAABJRUMgc1JHQgAAAAAAAAAAAAAAAAAA9tYAAQAAAADTLUhQICAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABFjcHJ0AAABUAAAADNkZXNjAAABhAAAAGx3dHB0AAAB8AAAABRia3B0AAACBAAAABRyWFlaAAACGAAAABRnWFlaAAACLAAAABRiWFlaAAACQAAAABRkbW5kAAACVAAAAHBkbWRkAAACxAAAAIh2dWVkAAADTAAAAIZ2aWV3AAAD1AAAACRsdW1pAAAD+AAAABRtZWFzAAAEDAAAACR0ZWNoAAAEMAAAAAxyVFJDAAAEPAAACAxnVFJDAAAEPAAACAxiVFJDAAAEPAAACAx0ZXh0AAAAAENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueQAAZGVzYwAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAABJzUkdCIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWFlaIAAAAAAAAPNRAAEAAAABFsxYWVogAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAAAA+EAAC2z2Rlc2MAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkZXNjAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAtIHNSR0IAAAAAAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAtIHNSR0IAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZGVzYwAAAAAAAAAsUmVmZXJlbmNlIFZpZXdpbmcgQ29uZGl0aW9uIGluIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAALFJlZmVyZW5jZSBWaWV3aW5nIENvbmRpdGlvbiBpbiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHZpZXcAAAAAABOk/gAUXy4AEM8UAAPtzAAEEwsAA1yeAAAAAVhZWiAAAAAAAEwJVgBQAAAAVx/nbWVhcwAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAo8AAAACc2lnIAAAAABDUlQgY3VydgAAAAAAAAQAAAAABQAKAA8AFAAZAB4AIwAoAC0AMgA3ADsAQABFAEoATwBUAFkAXgBjAGgAbQByAHcAfACBAIYAiwCQAJUAmgCfAKQAqQCuALIAtwC8AMEAxgDLANAA1QDbAOAA5QDrAPAA9gD7AQEBBwENARMBGQEfASUBKwEyATgBPgFFAUwBUgFZAWABZwFuAXUBfAGDAYsBkgGaAaEBqQGxAbkBwQHJAdEB2QHhAekB8gH6AgMCDAIUAh0CJgIvAjgCQQJLAlQCXQJnAnECegKEAo4CmAKiAqwCtgLBAssC1QLgAusC9QMAAwsDFgMhAy0DOANDA08DWgNmA3IDfgOKA5YDogOuA7oDxwPTA+AD7AP5BAYEEwQgBC0EOwRIBFUEYwRxBH4EjASaBKgEtgTEBNME4QTwBP4FDQUcBSsFOgVJBVgFZwV3BYYFlgWmBbUFxQXVBeUF9gYGBhYGJwY3BkgGWQZqBnsGjAadBq8GwAbRBuMG9QcHBxkHKwc9B08HYQd0B4YHmQesB78H0gflB/gICwgfCDIIRghaCG4IggiWCKoIvgjSCOcI+wkQCSUJOglPCWQJeQmPCaQJugnPCeUJ+woRCicKPQpUCmoKgQqYCq4KxQrcCvMLCwsiCzkLUQtpC4ALmAuwC8gL4Qv5DBIMKgxDDFwMdQyODKcMwAzZDPMNDQ0mDUANWg10DY4NqQ3DDd4N+A4TDi4OSQ5kDn8Omw62DtIO7g8JDyUPQQ9eD3oPlg+zD88P7BAJECYQQxBhEH4QmxC5ENcQ9RETETERTxFtEYwRqhHJEegSBxImEkUSZBKEEqMSwxLjEwMTIxNDE2MTgxOkE8UT5RQGFCcUSRRqFIsUrRTOFPAVEhU0FVYVeBWbFb0V4BYDFiYWSRZsFo8WshbWFvoXHRdBF2UXiReuF9IX9xgbGEAYZRiKGK8Y1Rj6GSAZRRlrGZEZtxndGgQaKhpRGncanhrFGuwbFBs7G2MbihuyG9ocAhwqHFIcexyjHMwc9R0eHUcdcB2ZHcMd7B4WHkAeah6UHr4e6R8THz4faR+UH78f6iAVIEEgbCCYIMQg8CEcIUghdSGhIc4h+yInIlUigiKvIt0jCiM4I2YjlCPCI/AkHyRNJHwkqyTaJQklOCVoJZclxyX3JicmVyaHJrcm6CcYJ0kneierJ9woDSg/KHEooijUKQYpOClrKZ0p0CoCKjUqaCqbKs8rAis2K2krnSvRLAUsOSxuLKIs1y0MLUEtdi2rLeEuFi5MLoIuty7uLyQvWi+RL8cv/jA1MGwwpDDbMRIxSjGCMbox8jIqMmMymzLUMw0zRjN/M7gz8TQrNGU0njTYNRM1TTWHNcI1/TY3NnI2rjbpNyQ3YDecN9c4FDhQOIw4yDkFOUI5fzm8Ofk6Njp0OrI67zstO2s7qjvoPCc8ZTykPOM9Ij1hPaE94D4gPmA+oD7gPyE/YT+iP+JAI0BkQKZA50EpQWpBrEHuQjBCckK1QvdDOkN9Q8BEA0RHRIpEzkUSRVVFmkXeRiJGZ0arRvBHNUd7R8BIBUhLSJFI10kdSWNJqUnwSjdKfUrESwxLU0uaS+JMKkxyTLpNAk1KTZNN3E4lTm5Ot08AT0lPk0/dUCdQcVC7UQZRUFGbUeZSMVJ8UsdTE1NfU6pT9lRCVI9U21UoVXVVwlYPVlxWqVb3V0RXklfgWC9YfVjLWRpZaVm4WgdaVlqmWvVbRVuVW+VcNVyGXNZdJ114XcleGl5sXr1fD19hX7NgBWBXYKpg/GFPYaJh9WJJYpxi8GNDY5dj62RAZJRk6WU9ZZJl52Y9ZpJm6Gc9Z5Nn6Wg/aJZo7GlDaZpp8WpIap9q92tPa6dr/2xXbK9tCG1gbbluEm5rbsRvHm94b9FwK3CGcOBxOnGVcfByS3KmcwFzXXO4dBR0cHTMdSh1hXXhdj52m3b4d1Z3s3gReG54zHkqeYl553pGeqV7BHtje8J8IXyBfOF9QX2hfgF+Yn7CfyN/hH/lgEeAqIEKgWuBzYIwgpKC9INXg7qEHYSAhOOFR4Wrhg6GcobXhzuHn4gEiGmIzokziZmJ/opkisqLMIuWi/yMY4zKjTGNmI3/jmaOzo82j56QBpBukNaRP5GokhGSepLjk02TtpQglIqU9JVflcmWNJaflwqXdZfgmEyYuJkkmZCZ/JpomtWbQpuvnByciZz3nWSd0p5Anq6fHZ+Ln/qgaaDYoUehtqImopajBqN2o+akVqTHpTilqaYapoum/adup+CoUqjEqTepqaocqo+rAqt1q+msXKzQrUStuK4trqGvFq+LsACwdbDqsWCx1rJLssKzOLOutCW0nLUTtYq2AbZ5tvC3aLfguFm40blKucK6O7q1uy67p7whvJu9Fb2Pvgq+hL7/v3q/9cBwwOzBZ8Hjwl/C28NYw9TEUcTOxUvFyMZGxsPHQce/yD3IvMk6ybnKOMq3yzbLtsw1zLXNNc21zjbOts83z7jQOdC60TzRvtI/0sHTRNPG1EnUy9VO1dHWVdbY11zX4Nhk2OjZbNnx2nba+9uA3AXcit0Q3ZbeHN6i3ynfr+A24L3hROHM4lPi2+Nj4+vkc+T85YTmDeaW5x/nqegy6LzpRunQ6lvq5etw6/vshu0R7ZzuKO6070DvzPBY8OXxcvH/8ozzGfOn9DT0wvVQ9d72bfb794r4Gfio+Tj5x/pX+uf7d/wH/Jj9Kf26/kv+3P9t////2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAESAk8DAREAAhEBAxEB/8QAHQABAAMBAAMBAQAAAAAAAAAAAAQFBgcBAwgCCf/EAFYQAAEDAgIFAwgWCAYCAgMAAAABAwQCBQYVERJTlNIHITETNEFUdLLR0xQYIjU2RFJVVmF1gYKDk5aXorO0wtQIFjJDUXORsSN2laOkwTO2N8NxobX/xAAZAQEAAwEBAAAAAAAAAAAAAAAAAgMEBQH/xAA7EQEBAAECBAUDAwEFBwQDAAAAAQIDERITIVEEMTIzQWFx8CIjgZEFFFJyoSRCU2JzscE0NYKDs9Hx/9oADAMBAAIRAxEAPwD+qYAAAAAAAAAAAAAAGdxb6U+M/CBngAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABeYM/8Nz7u/wDoaA0IAAAAAeyj9lAP0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAzuLfSnxn4QM8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALzBn/hufd3/ANDQGhAAAAAD2UfsoB+gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGdxb6U+M/CBngAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB4juXCHU8sC6yI1L9fVK6KKGqk1tWmnT5qhV6KU7IHuzG/eyGX8ix4sBmN+9kMv5FjxYDMb97IZfyLHiwGY372Qy/kWPFgMxv3shl/IseLA11hcfdtTDkqRW+6utrOVpSir5pexSiJ0e0BYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAM7i30p8Z+EDPAAPC1UoqIqoi1LoT21A8gAAAAAAAAAHhaqUVEVURal0J7ageQAAAAAAAAADwtVKKiKqItS6E9tQPIAAAAAAAAAB4WqlFRFVEWpdCe2oHkAAAAAAAAAA8LVSioiqiLUuhPbUDyAAAbLD/AJ0MfD75QLEAAAAAAAAAAAAAAAAAAAAAAAAAAAAABncW+lPjPwgZ4CNcLhEtcRydOeRtltNKqvZ9pP4r7QFdbLyl6hWu50tdSpkyXaaaFXSqJTS6iafb0UgXQAAAAwPKRy1YO5Lb9hXDmJG7g5KxbOphRqojNNbcWlXGmfJEipak6mz1aRHa1k1l13qE0aNKo0JfEeInhsPPa3f46S2Y7/4stsuGfPDexqy6Ph74nL0yyfXrvbftjJvlfidW+AAAAEWZXqyINPq5Cp/tOL/0BKAAAAHMMVcuNdhxxd8A2Dkmxti+4WK1xLvcHLKtspaZZk1P0tIiS5jFblarGd8zRRV0J2VRCq6sx0dTxGU2wwtxt+sxxzu0m98sp8efknlhw56envN85vPtMuHrb0nX6+X8tngfGmHuUXCFoxzhSZVKtF7iUTIjtVC0VLRUmnRVSvPTUi6UVF50VFQ1a+jdDUuFsv1nlZZvLPpZZZ9FOnnzJvZZZbLL5yy7WX6yyyrwqTAAEWZXqyINPq5Cp/tOL/0BKAAAAHP8ScscC14mlYKwngzEuN79bW23rnCsLcWmm3UOU6zfV5Ex9iPS5UipUjKOq6tNSV6mousRwyupLnhN8ZbLem2826Tfrb168Msx8srLZLLPHl8PFeuU3k+dt7N/pN5ZN9t7vtvtdtLg/EkrFVjou87Cd7w3IV55h223ihmmSzU25VRpVWHHWqqatXWpqocqpWmpF09KJZljJtZd9/v/AE6yXpf4vnLZZbXLeK42eX+u8l6bffb6WWXrF2RSAAEWZXqyINPq5Cp/tOL/ANASgAAAByOr9IORNvuKrLhPkR5QMTt4OuVdpuU22V2ehlZNLDb1VLVEie0855h5teZvnVdCaVI6eXHpY6+X6cbcuu2/pyywt2x3vnjdpJvfifCeeHBrf3fecW2N7TbObzrdp9+32bzA2PcK8pGH6MTYPuVUyErzsVxHY7kd+PIarWh1l5l2mlxlyipFSqiummpP4c6FuWFxmOXSzKSyy7yy/Ms/p9LLLtZYpwz495ZZZ0ss2svaz/WfFlllssrQEEwABFmV6siDT6uQqf7Ti/8AQEoAAA2WH/Ohj4ffKBYgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAM7i30p8Z+EDK3C4RLXEcnTnkbZbTSqr2faT+K+0Bx7FOKZeJJevXpbitqvUWdPR7a/xUDcYTr1cP4Yp9XNfT/bkr/0BsgAAAB8lX+0cp/LzizleuWD8K4auNgeiVcnlpn3TFMm2vQ3Ius5Klx22YEhKl8mO0pr69K60Kjm8yimfCat8D/eNPplqZzVwvndtLK46XS7Tbjxzzk3ks1NrZtuvzz09PxmOnnOLHTxuOUs2lurJlqTfreuny8fLaWXbe27d15BeUN/lQ5KLDiu5NUsXhWaoN5jJUirGuUetWZTS/wANDrdfN/BUOh4i6OplPEeG9vUkzx/y5TeT74+m/WWMPh8NTRmXhta756duGV73G7b9f8U2yn0sdAM68AAV10r1Z1np9XNqT/jvL/0BYgAAAD5uuuDbxjD9JnlMj23lVxPgplrBWHKZLtkpt+l6it66pprrlxnqm9REVUqaqbVNZVVdKUrTVjhjfAeIurf0XVyll6Y7cnR3tsuOXl57ZTpOll6rta3+9eEmOO95eW3zfdvTa7y7/WX/AMXb/oqX+jEPIRhqRGs9ut0OD5KtcFLbS4kOTFiyXY7MpjqlddfU3m2qXUWqutV19OtVp1l2+Iyy1Jp62c2yzwwyuP8AhuWEvDttNpPKTabY7T4Y9OTDU1dLHLjmOeUmW+/H13uVvzbbeK/OUt6eU60Z1wAArrpXqzrPT6ubUn/HeX/oCxAAAAHCP0abrCs+IeU/k1vj9MfGEXGl1vsmM+uq/Mt0t5K4kyhF/bZ6krbWtTpSmprUXQqaDzwk4v7N0JPPTmWGf0z488rv/nl45f8Ael3m+1PFWY+P1N/9+YZY/XGaeGN278OUuN7Xz613CJPg3ClyuBNYk0su1sOKy4laUO0Lq10Lo6KqVRUVOlFTQp7Os3nl/wDq7X/WWfeF6W43zm3+sln9ZZZ9LK94AABXXSvVnWen1c2pP+O8v/QFiAAAAOGfo+S4sDE3LzOnSWo0aNyiSXnnnq0ooboptVvWqqqpeZEREVVVeZEQYZ46X9maOed2k51tvlJz9XrUvEY5Z/2nljjN7dPR2n/we/8ARmSq7vcpnKFb9P6u4yxpIuNhrTmblRG4seMstvsK286w7XTUnNXStNelUqRSelhdHwGhpZzbL9ee185NTUyzxl7W42ZbfHF167qtbLHV8dq6mnd8ZNPDf4uWGEmVl8rJf0798b8SO2EEwABXXSvVnWen1c2pP+O8v/QFiAAAbLD/AJ0MfD75QLEAAAAAAAAAAAAAAAAAAAAAAAAAAAAABmMaymoyQ1cpeXW6po6mzW56np1UXQBznENus+IXKKrhIvlNDSeZaZhO6iL/AB0dSXSoFHVg7B1HS5iX3rc8v9mAJ9M+1WqvDlpt0a+O0R57qoldplK5Uix5CroRGk1l01dFKadCKvQiqBps8a9ZsRfN+d4kBnjXrNiL5vzvEgM8a9ZsRfN+d4kBnjXrNiL5vzvEgV9jbw7hi3UWfDWC7naYDbjjtMWDhaWwzTW5WtblSUUMJSi1V1VVKujnqqVV51E6Y44zyxkknaSbSTtJOknxC9css755Xe35t73vfq/VryCx+S0suDrrb/J8pydL8i4XmNeSJNejXec1WE13KtCaal0quhNKifpxmE8p5T4m9tu33tt+9t+S9crlfO7b3vtJJ/SSSfSSeUTs8a9ZsRfN+d4kBnjXrNiL5vzvEgM8a9ZsRfN+d4kCsu12V2fZa27LiBaWZ1dbmmxTU0U+Rn6eZFa5+epOZNK9noRVAs88a9ZsRfN+d4kBnjXrNiL5vzvEgM8a9ZsRfN+d4kBnjXrNiL5vzvEgYzFvJnyMY/utN9x3yG2/ElypZpj0zLvgJyY+jVKqtNCOOxqqtVFqqVE06E0r/EjjhjjbcZ59b9fjr/Ek/hK5ZZSS3y8v+/8A3a9i6xIrDcaNYL+0y1SlDbdGHZ1NNFKJoRERGdCIidgszzy1Mrnnd7fOq8cccMZjjNpHszxr1mxF8353iSKRnjXrNiL5vzvEgM8a9ZsRfN+d4kCrvN4RZlnkJZ7/AEtR51Tj1VVjm0pTSsZ6lF52ufzVVKaE5+f+CKeyXLyeWzHzTP1stfad6/0Sb4oly8+yPMw7n62WvtO9f6JN8UOXn2OZh3P1stfad6/0Sb4ocvPsczDufrZa+071/ok3xQ5efY5mHdmsZ4d5IuUemJTyh8mMTFCQFrWIl6wc7NSOtejX6n1aPVqa2rTp0aNOqmnoI8i8XHw9fLfbrslz5MbhxdL1236bz/8At/qtbBKwZhOzxsPYWwvKs1qhUrRGg2/DUmPHYpVVVUoboZSmlNKquhE6VUszmrqXfLe3pP4k2n9