Алексей Колоколов

Заставьте данные говорить. Как сделать бизнес-дашборд в Excel. Руководство по визуализации данных


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

цветом. Иногда это автоматически сформированный отчет из 1С или другой системы, который потом обрастает примечаниями и группировками.

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

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

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

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

iVBORw0KGgoAAAANSUhEUgAAAhEAAANICAMAAABOtk2rAAAC/VBMVEUAAABda2dYcGlYcWhdbmhjamhnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dkZGRnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2dnZ2doaGhnZ2dmZmZjY2NhYWFfX19dXV1cXFxbW1tYWFhXV1dWVlZVVVVWVlZbW1thYWFdXV1aWlpfX19kZGRwcHBubm5/f391dXVsbGxjY2NeXl5XV1dQUFBRUVFwcHBsbGx5eXmCgoKGhoaRkZGbm5uZmZmenp6oqKirq6u0tLS8vLy7u7vDw8PHx8fI2NPS0tLOzs7V1dXb29vi4uLd3d3k5OTm5ubq6urv7+/v8vHx9vTx8fHq6urp6eng4ODg4ODZ6+XO7uS25tae3sqJ1r140bNgyaZOwpxDvpYrtogasH8MonARnW8Vm28Wmm8RnW8amG8ikm4rjGwmkG0pj20xiWwqjm0sjG03hmw6hGtEfmpCf2o0h2w7g2tDfmtKeWpMeGpUdGlPdmlKempfbGhcbmhQdWlRdWlTcGdHe2o3hWw7g2s7g2smkG0rjW0jj2sbjGcTnW8LonACp3EEpnEGq3QAqXECp3EIo28BqXEBq3IArHIDrXMCqHEFpXACpGwCqHEBrXIArHIAq3EArHIArXIBq3ECrHMArXIArHIArHIArXIAq3EAqnEAqXEAqHEBp3EApm0ApWwApGoAo2kAomcAomgAoWUCpnAAsHIJqnYGomwQnm8Vm28Rnm8ZmG4asH4MonAHp3MUm28RnW8XmW8TnW8Xmm96enqOjo6KioqLlpOhoaGrrKy4uLjFxcXS0tL1+Pf6+/v7/Py3t7e7u7urq6uenp6Ojo5+fn5XxqEntYcBrnOqQ2l9AAAA/3RSTlMACgoGAwICBgsOERUYHiQnKy8yNTk9QURITFFXW15iZmpwdXqAhIiLj5WaoKWsqrO5vMHFyczQ1Njc3uLn7fD09/v+///////////////++Pbw6enb497108G+x8LU6/+jmZiWgoOBal9gSz5ENTJJTTQhGRoUDAQKBgQIDxYSISo1LQ4eKTJMYEtwiYCEgHxzbGhrX1VIPTgwMjo2JyUYERkXDQMHFBwkNjdQSmFtg5Whqqeuq6SnsrjCxcbL0NLN197d4uLo8PD29/v////////7///////8+vT76ubVzMO7qZiUlYhcWEx4cFw0QCwfGQsCAwhTa4elp7Wm1ddvUK+JAABHKUlEQVR42u2dB3xUxfr3B8XdEJJQkkAKpAOphtRNyKZxiAFCT+ihdxSQLh1sKL6KGkAvRWkq/kXRCzZAmnSSTUJVBK+C4L2A9Bru9fPOM+ec3bOFSAuK+X31Q3ZPmXN25neeeWbmzDOMAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQGXg0uQrl+81jctDh/F/z58da95wZbLyYfLky8jjh4tunTsPv9c0JnfMO8/Gde95Qd0wpVO3CeJD/6b9kcUPF8PbZzXve8+pnGnTrktmm4Hm71M7dn9GpN66+1Tk8cNF/+xTxryL95zM9IF9+4+8ZFFEqoEUMa579pPI4oeL8Z3ane/b8qxS6U9REN8mTpkySa4TpghXYJL4OonvVkp+onrk5Cmy1zBliuozTDUKGzGgdT+lFpkyZaL5k9Ul5O2X5Q2Xpky9LF9DvjLfIDPJ9mjzRnCfGdG2KxvcVqk2LnRsmpWV1axpb/oyuHuzrI79yHr0a0eOxvAUI3cTrnbNympfNooOeDI6I6t93/P806CWQ8Tp3Z94ymwjErkihrXpJuqOUX2MWVkJZ0hIo/I6Wy5xNi7zifQosiKjO3alvaez+J2M65OSlZV0SpT92Sy6o8xmZ8T10rMyY0i8E7o1bZaVJXUbjPKrgEqj5SA2zthBdgkvtO1848aNsqw+VMqtOpTd6NI2fzRjfVuP5Bv69uIFcDont+xG15w80ka7tjdvlOX0GMbYoF5CEX2faPmU1kaM6yYbn1EdW3a9Uda+BdmLUbniEs2i6BIt2pXduNm83VWuiNxu3DiMap87mo3p1jzxxo2OLW6Sazo4pws/vEsLroih7Zrz67Vswe9iQvdmZTdu3GzX9hwK8H5zoWMuL9y+OUMVRdwklyCbK+Js265cCxP75wzgu1txG3Emh+8728pA5uFUr1PsQo/04cI8dOX/tCFFDG7VrIXFRnSfwE63GSC+dM8ZxP8d0y2Hl+socYlpWVwR51rmUQpPtuS3MDqXbER0Nr+PPi378+rgmb6tTlGabejUa23PsAu57ciYDO/Q8hybkJBK/uqZ5qdQgveboa3IfA9rIYw4G962n6qI/q1lkXTveJELZjgblULS6ddKGOqpI0ayIW1OiwP6ND8vK2JYh269NTYivawsK2GcSLVltNh2ljQ1StRQQhEDWp8R20/xs4UiBufw2xjTXvZzz7dL5PXG4NZ0wWttzrAhreXiP8NlpijiqVZnUIL3m97ZVIbj8jKFZzA8x6yI/Kx+14lObc9zRYxgvduRGchLHaee2SerrzigS7tBQhETb7Y5O6C1WREpzaSsrI6io+NMjlzfT+jERaVRRH4zcVH2VHZDNia325VRPTuNYey3HNmwsJs558hGqIoIU3yUUVmPs4kJ7adfmXSuU4fRKMH7zOjUPFHEA3JOWytiXH5TqSWnRRb3KvtmZTTNpCf3Yo9O5g7IPs2a0QEts3jFToo4ldOf9cux2AjD2EmnsvPHkw3gghJ04T1Yo1qpihif31luodD1xuQ1bdo0i6zAmdbX5aPLWnNFDJJtBK81IrOmy22VjHw2Ma5Z087N2rTsOwFFeJ8Z3KJ9py78v85P5FPmjmhzSrURPZqOnCZzifXN7lKWlH2GFNHZXAZhT1ydIh8wmSti6PA2URO1ikjlnuXEmy2pw/KUMC+crrnn2Ygci41oOkauq7JD2ZgOaWU3s8lh/a31QI2NGNj6rKKI8CfkntXRTbki4puVlXG/N6cvivA+0zWri0ynJ8htP5NtVkS/HLmPYsJ4cjxHsWGp7XmJ3Gwrtk6aPo1X+nL39IQJE7h7ecrQ4TyzUgS1Pi/ktuQ6GtY8Smw7l9NVvYRQRP8cxY/gtcroDnzf6ZbkaGR1F37EhQ5N+KV7t/xNUQS/huxH5Ag/Yhr/eKVLz/Mow/vKuezuyjM/sC3V3t2aP6kqYnBOd6pPhvWIUNsarRpPZGdaNB4vLHtfdj6HXE02Oj//AhuU3THnKrNShNxD9WR20iheA4lG6ITeJI/eLYeqijjbsjv5AcNz252XPcvxj1PL4vEWogY71YIbgNEdUkcrfsT5dqKJPLo7l+qEhPaib7xbKyji/nJaec75k9ms+/gxZe17XFQVwfplG65fG9Ce2qXU1uD/Zp9ml25mx1+/VtY2lwx6i44Drg1MIg9kUHPhAtjZCG4HWkWR65je79r1btldJ44ZkCUuIRTBBrQ0DLw2wNhyMFNan8M7tj/Pey+e6HvtetesuHFs+M3scKYogl+ErpfcfAD1R2Rcv3b9Wu/m3VCG95Vx+W3MXTzRrYb/1quDaHFOz4mknun+ua3btOpKRqNvL1LE2Lxev7FJ/XJbtWnbdZhwQvJatspJGiKUlS8c1H69zIpony8UMb43NR2G5bds06oD9wN/65Urqp3p2Y9TF/Xp3JatWuSR7zi6ZzfqsxzShgtm1OM83XZ9uJMR3Kq76Dq71kv0TfRo3iqnw+nLpIjsnFY5bVpGjUEh3lcuzZg+Uf08dsbYKTPkpuWVGdOVTTOmT5A/TJb/TFO2KmeNmz5jurDeU2fIL0ZMmzFFSe7yjOlyq2TqjOm8qMdPnyEOmagcqF5iHE9snHIr9GfidLqUOHqCOHm83L6Y8Yx6PXH0ZX4AZzqKEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHi4uvfD808QLzyMvAHvuxVf+d/T77w4dPHTg6NFvZj0/EVlSuXlp86ED+/fuLeUU7ystPXDoqxeRKZWY548dKLVh3/cvIV8qryA27BcqOHhwH2f/QSGP/YcgiUrrQqwTgvjum1kvP8t5cdaxw6L6+H4m8qZyMusQmYQNL08wb3nhS+5LlB7+EnlTOU3Ej+Q2rH/OauMvJInv0QytlMykOmPzCzYy2cA3HpiF3KmMvMIdyf2v2G3dB0VUVn7ZvX377rdst64sLC0tOWm79Tfilin9Vv7uck9b/IB+7eXnCJR6eSxZxHnMduuHRaWlptnaLfoFq/7509q1a3/+55wlDpKptvLTE2uJfxasMCf9z1vw2fvqIR/M+fSf/KRNn336VhVtcgXWJ8yZu0KnkSttWmlzA3O0x3/5XwuWVvRzL//3vz9u3rx53X9fhijulDkmrog3LN/fe31jsamomPdXFBcV7Txh+0gvnb2t1LRv//79+/aZTKbVi+Stb/9Q6Jgdiqbmf3GYH87PKi4sNG2cW9WS4FdF1mcU7/16jnn3Gzzdotl2ts58sKmw9NBBlUPHVD28dGT/d7xdtW9f6cEDh2dBE3fG8WKuiLfNXxdsNGl7NIu3LrCuY7ZZ7Tbt/FVs/kdRqWO2CzOyfPaeEu3WouMWM/G5/UlFJ9Tdb9DNvW5zx68WO77WfkURMzce0mwtObD5ZZTyHTCf+qg2LFO//me3LITiwqLiYirFkh1aoz37B5HJ3IgUmcTu0kJhXv7xQ7GKcr6CUMR7X5rU00xyqoWrq1gposR8gpzoiXIVUWh1cOl+hYOyImYe3SdvPXhwv+iRKzkKSdw+72zguWoqMOtjhyiQratPfrTwjRObCik/ty4yH/0GbSgt2nyi4MMP55zcLAyD8FXfefWkymG+bYv526ukteMkiOLdm06u+nDea6t3FmvLXCii5IvX5MNfW61J9FaK+I+a+GtrSBLrX1ERBT/ze9FPv+WVWU8/O+uVbd+hU/ZOWD53mygPs7u5lkpr1yeK8/DYnC2kF3PhzdtFRx+ZozzfVebspO+bqlq5pUd5Euse1W5aQIVs+mmh6oWeIIHsWqhRxO755oOrzNlCib5ajiIsfFRk13J+fjNZiKOq8/DcS0e5Edy/Eb5EuTym4/+xRQsK1tEzb/riPbOJ+GEP9+Q01cRCKvNdipF4dBPXR8mGdzRlTbsL5/yBIo5z37ForaaBcYLKebVGEXu0beK5vJhL1tyeIgrtFEGdLqXbNCP8L/5IHS7/D6VeHquOcn48vLuQjO72AkuDdFHB3IK5c7WNw9n8eS5SKpU5pJ9t87UpvVZkMhV+Xr4iHpvHU/1Ve9rSbymhD26hiGXcSJSsfezuFPHC99wkfGflN7xMRufoCyj2cjhRZHHLik8uK+/QRTupVrFUKUVWBoEt/ulfP/9rdZXybYQ9s6ky+sctFFFlI7/k13dpI2btt++XnXWQiwQj/uUqwqoFuf1ked2IP/Ey+UaIZtEerp/NVf8g7dtSxEJeMRS+aVHELq0i5tN1Tt6dIp7fREO5Nvbg+Z37SkswvFuuItT+JFkZpg2Lyu+ukA38mybbzs27VsQi3qQpXOXYRlRdU2zxO+9UES8e5al9ZXvYV3zjkcko91vz8Wefyny2fheJouTbd2957KvcwO9cofqDhQvviyIWb6VuKE1bw6KIhSSIwuOa/ojSTV+sEf8dn/PJR++Wrwga3j1oN2z3C/kWeJ30tnh0/hckCdMay6ZHFr5+8qcfzRwhX2OFWn9sX3GXilix8tXVlkQ38yIy/WxRxN4v1C6Gn3ZRe+aX97SKKC0pKRX/FRbu3rF25WPlKOIlroiSY6/YsI6ngVcHb5vXqAVhbnE+NmdzUbEW4X3+Hz3Xv/NPvy+9K0UsObGzUJuo6LbUKELTyck/75y9nFkpwqpb3dLF7UARvwh3ed9+a8SrhFDEbXdOkJkuVozE0q8KS+wHDISNeI+ajBveuxtFzN3hYCTCWhFWHF67UquIEiuvh/eAV721Im4x5MHrEijitplPOb1dVNDL1iklULxXxdpG3JUi5u4R/mth4V5tqlaKKLaMZopqQu0CIUWUrP3k01WffvLpJye+2iL3oheUr4h9Bx2AOQi3zyMbuVnYLYY4XxVOxeZVBQtcPpB5nwYaZRtxt7XGu2RcSnetLpi7Qk100VZrRRT/9JnK6m+FJormOmprLCsgt6Z04yPl1Rr7/vdfR6CL6vb5ukRxJN7ZSqXzy3IrN8Ok2Ai2jh+2fcmdK0IMXm+dZ9XW+NZaEZpxDbZsrlDQN+85bH2+RWOz5haPnSJeseuxBLem6qNVH33UUQfTV6prObfQMqKgLU+5rbH67lqfVb8mmVkJgi3ebq0Iqz5L9g8SZuE8x/0RX5RoXvBx2PrES6O3y6vr161b/7aDFuh6VRGrCjWtDoXVZhtBQxym1+5YEe8fsQxTmDsddpenCNEHIjsL9or4tVDTT2bfQ8UHv0vWYaDz9jhO+eyg/+8DGhHf8Y4DA64MOyk24i0TDX076nvSlaeIf+y2jIwwzZt8WkXsslbEx3vULk17RfzbVJ4iniefaD86o26PN8lv37zYbnsB1QubhUUuVV1Mq6FpxUYso5kdNiNdj64+yjucFpWniHf22FVFVcklKcdG0GsPt1LE64WaLfYjXa/wUa19x6x/4HMUKwNzlJjDwYRS03G73kRy3+Wn7lMaY7LKf7mdINsI4WSWbntHu38edWdteKTcWuMwL/5tVr3Pb5hKy1XESRLMLWqNn8hGzLulIl48RG9WWnsSsw7t23cIL0g4QHToFZ+wthJvbxHdhCvMBkFb5O9Q/qs2gi3ZTl+0b8y883up3av9jj1L7YSQgl22PVTWtcaCI/vUl4HtFEHDbaVbl976jZlj1EP5vba5MfOgg/FQIMpPlKhp2+z5aoE9smD1rhLz67NssXjHbqP6BC4r2FpcqrER7HXxdfscxSZUFe/klW5bUn7r83VhEY6rQly4uqi0PEU8Il7lU5KwUcSKE9TZVfxqOe9QidHP0kOvqLXEc2Ji64FXUPyOWLlDHv3evWX1cWLN0T2ijM1VCVXS3Iavnf3Rxx8VrNlCRbdrr9lGcEdDHF605fjHH3308YmNomiL/vMH/RHv/U4lbNp+vICf9OraYnJQeU2iVUTJmuMqa44W0eFF8yy92OvUfT+KkdrS398tRxGySSjZv/fYLO49zDpG7/3x9yzhRtxCEtvlsYES7ThWSdFxtQAfW10o7y5S377f+eoWi41gi9XX7Pn+Ivnl/aI3/7AXe6GwQ7ynmk6iSxav5W9dWPVil1iPrZUUvaYd6bIaISve8VZ571mSJMTQ1v4DPNTWfvGi/kEI4tYVx+dFJquhrJKSos2a3qMqJ4o0u0uKt85bslVjI/hUnKIS7QGF2/5zGyNdC7cWai9Z9Pky7g7ceqSrRJ0XZD/2yW9341usfEWwmUokHTWs0sFjEEQ5LDhxmI85yRnNX5Heu3aO1SzMx+ZsKpSHP/l415GT7/IBrqLCIs1bEXy6XpF8enGRaePsZfY9VPzN628eYXaj4bJ1Ki4qXjd3Oft3UeEPiiK+tJ0YaNpyYoV2lp+GosPWt/vRD0X7vrfvopw8a/PBQwfF9Q4d+u7Y0yj18qnyVsGnqzes43z26Vz7mcFV3lq1hvdubljz6Vx6mW75Kv6u1QdWxTtHnL5+9aqVjznos6T