Сводные таблицы Excel. Часть 2. Учебное пособие. Валентин Юльевич Арьков

Сводные таблицы Excel. Часть 2. Учебное пособие

Сделайте короткие понятные заголовки.

Выделяем диапазон ячеек с итоговыми показателями по годам. Выбираем в верхнем меню

Home – Styles – Conditional Formatting

Начало – Стили – Условное форматирование.

Для начала просто укажем на этот пункт меню и почитаем всплывающую подсказку (рис. 6.3). Нам сообщают, что если выделить особо важные значения показателей, то будет легче обнаружить тренды и закономерности.

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

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

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

Безопасно оплатить книгу можно банковской картой 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/wAARCAGtAk8DAREAAhEBAxEB/8QAHQABAQADAQEBAQEAAAAAAAAAAAYFBwgEAwECCf/EAGQQAAAFAwECBgoNBg0CAgkCBwECAwQFAAYHERIhCBMUFzFWFRYiN0FXlZbR1DI2UWF0dXaTlLK0tdIjNFSis9MJJDM1QlJVcXOBg5GxQ2IloRgmREZTZHKSxGOkOFhld4Kj8f/EABQBAQAAAAAAAAAAAAAAAAAAAAD/xAAUEQEAAAAAAAAAAAAAAAAAAAAA/9oADAMBAAIRAxEAPwD/AFToFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoMLeF6Wlj+33N13zckbAwzMSA4fyLkqCCQnMBS7RzCABqYwAGvhEKDW//pj8FD/+Y3HfnE1/HQbUhJuHuWHZXBb8m2kYyRQI5aO2ygKJLpHDUpyGDcYogICAhQepddFsidw5WIkkkUTnOcwFKUodIiI7gCg1sw4TnB4lrnbWVEZps6Qn3roGTeNZy6K7lRceggJkMI6/5UGzaBQKBQKBQKDFW9dVtXYg7c2xPMJVFi8Vj3KjNcqpUXKQ6KJGEojoco7hDpCgytBjIC5beupos/tqbYyjZu5WZKrM1yqkIukcSKpiYoiG0UwCUQ8AgIUGToFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoPLJRcZMszx8vHNXzVTQToOUSqpm0HUNSmAQHQQAaDmKyLCsZThv5Rj1LLgjNUbHtxRNAY5EUyHMu82jAXZ0AR0DUfDoFBVZtyDdeP55nBMMm41xVZ6UcU6MrO8Wu4cudsQ5Og0FVIpEylANTajqJtAANKDnvJvCQuzJnBZuJGRQhbodsclxtjuVYkyrJlcTVRdA5dAPtHSIqChUzhqIabWgiAhQbTbN714Nt0WG8vK3MavrduyZQt1XtbtksW4gHrggggZM+2YXCImLxZhECn7oB90KDOt7n4QGR84ZQsqy8nQFrwtirxSDZJxbIP1VhdNOOOYygrk00MGgBp4aCasrhHZVkLLwlITb2IcyN63/ACVrTiyTDiiKtmxnxSmSJtDxZh5KmPSPSNBmLQ4S18X1wqV7ChWMeTGhrclV4x+KYmcST9g5QRcLENroCAHWMmXd3QpmHo01D+j8IPIROAfJcIcDx3ba0t13KJiLX+LccmqcpdU9fY6FDdrQUWYsn31bQW6dLJOPsdW6+iuVv7iuRQqqxnY7Oy3btTKpgIaCJjHEw6bgAPDQfnBRzpO5iTvqFn5yBuBayptOMQnoRuo3ayiCrcixFQSOJtgwbYlHZMYo6agOlBnM53vOrPYvCWOH/J7xvEhxVek0HsJElEAcPze4bQeLSAfZKGDwFNQa+/g/bdi7PxpfVpworCxh8kXEyb8csZVQU03AFKJzmERMYQDeI9I0G7Ms45c5TtbtRTvmftdq4cJnfOINYqDpy2DXbbgqICKZT66CYuhtOgQ6aDSX8HPEMbf4PLuAjCHIzjb0uVm3Kc4nMCScksQoCYd5h0AN47xoOoaBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQaotrFdxQ/CVvbL7lyxNDXHbUPDtUiKGFwVZqq4MoJy7OyBRBYuggYR3DuCgirwwllGN4RMvm6xIuyLoRuSFYQ52t0KrJKQgtjKDxjQ5ElNoinGanT7gRMUB2qCeg+CTfknjvKlmZCvSLUmLvvBG8oScjm4gDN8kRsdExm5txSprNwKBdo20npqOojQUjnFmfssXPZiubV7MjbfsaUTneT2+4cLqzkiiQQbnV41MgNkSmMKgpgKgiYChtaBvCjwTjTIds3jknJOSywTSVv2QYrJx0O6VcoNEGjbiCarKJpic5t5h7gADcG/poNNXPwP8AMEviDHFgQF4xEHL2vfUnPyEmiqc5kmDtZ5tcn1T3rgk60DaAAA2o6joGobga4EVt7MVkXRaKUextO0bGkrVTabZgWKoss2OkJQ2dBLsoH2jCbXUQ3DqNBo6Rwhwtm/BUluDQnaeMjMVoZ3FlmTXQ8BUE1DnPxgo8i02gA3sdvT36DJ2NZ2U8nythcK+0bYsmXXm7HbQTq37ldrAnEGIsYwuWa5UT6ifoOUSFEwFL3QaUG2uD1iLJWNrzydc2Q5yFlT3zKMpZupGJnRKgJGpUTtwSNrskJsFAptoRMG8QAd1BVX5wd8JZPuIl239jeImpkjUrEr1wQ3Gg3KYxip7QCHcgYxh090aDXvBm4MSHB3h79dw0BAIXBPz0q9i1W6qopAwUU22bdYRABAC7gMBQHTfoI0G8LSUupW2ItS+G8YhcBmqYyaUYoc7QjnZ7sETKABxJrroJgAdOmg1vwXcTXLhnHMjad1uGCzx3c83MkMyVMomCDt6oukAiYpR2gIcNoNNAHXQR6aDb9AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFA

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