╨и╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ Excel

╨С╨╡╤Б╨┐╨╗╨░╤В╨╜╤Л╨╣ ╤И╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓ ╨▓ Excel

╨Ъ╨╛╨│╨┤╨░ ╨┤╨╡╨╗╨╛ ╨┤╨╛╤Е╨╛╨┤╨╕╤В ╨┤╨╛ ╤Г╨┐╤А╨░╨▓╨╗╨╡╨╜╨╕╤П ╨▒╨╕╨╖╨╜╨╡╤Б╨╛╨╝, ╨╛╨╜╨╕ ╨┤╨╛╨╗╨╢╨╜╤Л ╨╛╤В╤Б╨╗╨╡╨╢╨╕╨▓╨░╤В╤М ╨┐╤А╨╛╨╕╨╖╨▓╨╛╨┤╨╕╤В╨╡╨╗╤М╨╜╨╛╤Б╤В╤М ╨║╨░╨╢╨┤╨╛╨│╨╛ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨░. ╨Т ╨╛╤Б╨╜╨╛╨▓╨╜╨╛╨╝ ╤Н╤В╨╛ ╤Б╨▓╤П╨╖╨░╨╜╨╛ ╤Б ╤В╨╡╨╝, ╤З╤В╨╛ ╨┤╨╗╤П ╨╝╨╜╨╛╨│╨╕╤Е ╨▓╨╗╨░╨┤╨╡╨╗╤М╤Ж╨╡╨▓ ╨▒╨╕╨╖╨╜╨╡╤Б╨░ ╤Б╤З╨╡╤В╨░ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓ ╨┐╤А╤П╨╝╨╛ ╨┐╤А╨╛╨┐╨╛╤А╤Ж╨╕╨╛╨╜╨░╨╗╤М╨╜╤Л ╨║╨╛╨╗╨╕╤З╨╡╤Б╤В╨▓╤Г ╨╛╤В╤А╨░╨▒╨╛╤В╨░╨╜╨╜╤Л╤Е ╤З╨░╤Б╨╛╨▓. ╨б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╨╜╨╛, ╨▓╨╗╨░╨┤╨╡╨╗╨╡╤Ж ╨▒╨╕╨╖╨╜╨╡╤Б╨░ ╨╛╨▒╤П╨╖╨░╨╜ ╨┐╨╛╨┤╨╡╨╗╨╕╤В╤М╤Б╤П ╤В╨░╨║╨╕╨╝╨╕ ╨┐╨╛╨┤╤А╨╛╨▒╨╜╨╛╤Б╤В╤П╨╝╨╕ ╤Б ╨║╨╗╨╕╨╡╨╜╤В╨╛╨╝. ╨Т ╤Н╤В╨╛╨╣ ╤Б╤В╨░╤В╤М╨╡ ╨▒╤Г╨┤╤Г╤В ╨┐╨╛╨║╨░╨╖╨░╨╜╤Л ╨┤╨▓╨░ ╤А╨░╨╖╨╜╤Л╤Е ╤Б╨┐╨╛╤Б╨╛╨▒╨░ ╤Б╨╛╨╖╨┤╨░╨╜╨╕╤П ╤И╨░╨▒╨╗╨╛╨╜╨░ ╤А╨╡╨╡╤Б╤В╤А╨░ Excel.

╨Ю╨│╨╗╨░╨▓╨╗╨╡╨╜╨╕╨╡

• ╨С╨╡╤Б╨┐╨╗╨░╤В╨╜╤Л╨╣ ╤И╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓ ╨▓ Excel
  • 2 ╤Б╨┐╨╛╤Б╨╛╨▒╨░ ╤Б╨╛╨╖╨┤╨░╤В╤М ╨▒╨╡╤Б╨┐╨╗╨░╤В╨╜╤Л╨╣ ╤И╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ ╨▓ Excel
  • ╨в╨╛, ╤З╤В╨╛ ╨╜╤Г╨╢╨╜╨╛ ╨╖╨░╨┐╨╛╨╝╨╜╨╕╤В╤М
  • ╨а╨╡╨║╨╛╨╝╨╡╨╜╨┤╤Г╨╡╨╝╤Л╨╡ ╤Б╤В╨░╤В╤М╨╕

╨Ф╨░╨▓╨░╨╣╤В╨╡ ╤А╨░╤Б╤Б╨╝╨╛╤В╤А╨╕╨╝ ╤Н╤В╨╕ ╨┤╨▓╨░ ╨╝╨╡╤В╨╛╨┤╨░ ╨╛╨┤╨╕╨╜ ╨╖╨░ ╨┤╤А╤Г╨│╨╕╨╝:

2 ╤Б╨┐╨╛╤Б╨╛╨▒╨░ ╤Б╨╛╨╖╨┤╨░╤В╤М ╨▒╨╡╤Б╨┐╨╗╨░╤В╨╜╤Л╨╣ ╤И╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ ╨▓ Excel

.free_excel_div{╤Д╨╛╨╜:#d9d9d9;╤А╨░╨╖╨╝╨╡╤А ╤И╤А╨╕╤Д╤В╨░:16px;╤А╨░╨┤╨╕╤Г╤Б ╨│╤А╨░╨╜╨╕╤Ж╤Л:7px;╨┐╨╛╨╖╨╕╤Ж╨╕╤П:╨╛╤В╨╜╨╛╤Б╨╕╤В╨╡╨╗╤М╨╜╨░╤П;margin:30px;padding:25px 25px 25px 45px}.free_excel_div:before{content:»»;╤Д╨╛╨╜:url(╤Ж╨╡╨╜╤В╤А ╤Ж╨╡╨╜╤В╤А ╨▒╨╡╨╖ ╨┐╨╛╨▓╤В╨╛╤А╨░ #207245;╤И╨╕╤А╨╕╨╜╨░:70px;╨▓╤Л╤Б╨╛╤В╨░:70px;╨┐╨╛╨╖╨╕╤Ж╨╕╤П:╨░╨▒╤Б╨╛╨╗╤О╤В╨╜╨░╤П;╨▓╨╡╤А╤Е:50%;margin-top:-35px;╤Б╨╗╨╡╨▓╨░:-35px;╨│╤А╨░╨╜╨╕╤Ж╨░:5px ╤Б╨┐╨╗╨╛╤И╨╜╨░╤П #fff;╨│╤А╨░╨╜╨╕╤Ж╨░-╤А╨░╨┤╨╕╤Г╤Б:50%} ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╤Б╨║╨░╤З╨░╤В╤М ╤Н╤В╨╛╤В ╤И╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ Excel ╨╖╨┤╨╡╤Б╤М — ╨и╨░╨▒╨╗╨╛╨╜ ╤А╨╡╨╡╤Б╤В╤А╨░ Excel

╨Ь╨╡╤В╨╛╨┤ тДЦ 1 тАФ ╨╛╨╜╨╗╨░╨╣╨╜-╤И╨░╨▒╨╗╨╛╨╜╤Л

╨Т╤Л╨┐╨╛╨╗╨╜╨╕╤В╨╡ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨┤╨╡╨╣╤Б╤В╨▓╨╕╤П, ╤З╤В╨╛╨▒╤Л ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╤М ╨╛╨┤╨╕╨╜ ╨╕╨╖ ╤В╤Л╤Б╤П╤З ╨▒╨╡╤Б╨┐╨╗╨░╤В╨╜╤Л╤Е ╤Б╨┐╨╕╤Б╨║╨╛╨▓, ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╨╡╨╜╨╜╤Л╤Е ╨▓ Excel, ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╨╖╨░╨│╤А╤Г╨╢╨░╨╡╨╝╨╛╨│╨╛ ╤И╨░╨▒╨╗╨╛╨╜╨░.

1. ╨Ю╤В╨║╤А╨╛╨╣╤В╨╡ ╨╜╨╛╨▓╤Л╨╣ ╤Д╨░╨╣╨╗ Excel ╨╕ ╨┐╨╡╤А╨╡╨╣╨┤╨╕╤В╨╡ ╨▓ ╨╝╨╡╨╜╤О ┬л╨д╨░╨╣╨╗┬╗ > ┬л╨б╨╛╨╖╨┤╨░╤В╤М┬╗.

   

2. ╨Ъ╨░╨║ ╤В╨╛╨╗╤М╨║╨╛ ╨▓╤Л ╨╜╨░╨╢╨╝╨╡╤В╨╡ ┬л╨б╨╛╨╖╨┤╨░╤В╤М┬╗, ╨▓╤Л ╤Г╨▓╨╕╨┤╨╕╤В╨╡ ╨╛╨║╨╜╨╛ ╨┐╨╛╨╕╤Б╨║╨░, ╨▓ ╨║╨╛╤В╨╛╤А╨╛╨╝ ╨▓╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨╕╤Б╨║╨░╤В╤М ╤В╤Л╤Б╤П╤З╨╕ ╤И╨░╨▒╨╗╨╛╨╜╨╛╨▓ Excel ╨▓ ╨Ш╨╜╤В╨╡╤А╨╜╨╡╤В╨╡, ╤Г╨║╨░╨╖╨░╨▓ ╨║╨╗╤О╤З╨╡╨▓╨╛╨╡ ╤Б╨╗╨╛╨▓╨╛ ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╨▓╨▓╨╛╨┤╨░.

   ╨Т╤Б╨╡, ╤З╤В╨╛ ╨▓╨░╨╝ ╨╜╤Г╨╢╨╜╨╛ ╤Б╨┤╨╡╨╗╨░╤В╤М, ╤Н╤В╨╛ ╨▓╨▓╨╡╤Б╤В╨╕ ┬л╤Б╨┐╨╕╤Б╨╛╨║┬╗ ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╨║╨╗╤О╤З╨╡╨▓╨╛╨│╨╛ ╤Б╨╗╨╛╨▓╨░, ╨╕ ╨▓╨░╨╝ ╨▒╤Г╨┤╤Г╤В ╨┤╨╛╤Б╤В╤Г╨┐╨╜╤Л ╤В╤Л╤Б╤П╤З╨╕ ╨╛╨╜╨╗╨░╨╣╨╜-╨▓╨░╤А╨╕╨░╨╜╤В╨╛╨▓, ╤Б╨▓╤П╨╖╨░╨╜╨╜╤Л╤Е ╤Б ╨║╨╗╤О╤З╨╡╨▓╤Л╨╝ ╤Б╨╗╨╛╨▓╨╛╨╝.

   

3. ╨Э╨░╨╢╨╝╨╕╤В╨╡ ╨╜╨░ ╨╗╤О╨▒╨╛╨╣ ╨╕╨╖ ╤И╨░╨▒╨╗╨╛╨╜╨╛╨▓ ╤Б╨┐╨╕╤Б╨║╨╛╨▓.

   

4. ╨Ч╨░╤В╨╡╨╝ ╨╜╨░╨╢╨╝╨╕╤В╨╡ ╨║╨╜╨╛╨┐╨║╤Г ┬л╨б╨╛╨╖╨┤╨░╤В╤М┬╗, ╨║╨╛╤В╨╛╤А╨░╤П ╨┐╨╛╤П╨▓╨╗╤П╨╡╤В╤Б╤П ╨▓ ╨╛╨║╨╜╨╡, ╨▓╤Б╨┐╨╗╤Л╨▓╨░╤О╤Й╨╡╨╝ ╨┐╤А╨╕ ╨╜╨░╨╢╨░╤В╨╕╨╕ ╨╜╨░ ╤И╨░╨▒╨╗╨╛╨╜.

   

5. ╨Ъ╨░╨║ ╤В╨╛╨╗╤М╨║╨╛ ╨▓╤Л ╨╜╨░╨╢╨╝╨╡╤В╨╡ ┬л╨б╨╛╨╖╨┤╨░╤В╤М┬╗, ╨╛╨╜ ╨╖╨░╨│╤А╤Г╨╖╨╕╤В ╤Н╤В╨╛╤В ╤И╨░╨▒╨╗╨╛╨╜ ╨┤╨╗╤П ╨▓╨░╤Б ╨╕ ╨┐╨╛╨╖╨▓╨╛╨╗╨╕╤В ╨▓╨░╨╝ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╤М ╨╡╨│╨╛ ╨▓ ╤Б╨▓╨╛╨╕╤Е ╤Ж╨╡╨╗╤П╤Е.

   

   ╨Ю╨▒╤А╨░╤В╨╕╤В╨╡ ╨▓╨╜╨╕╨╝╨░╨╜╨╕╨╡, ╤З╤В╨╛ ╨▓╨░╨╝ ╨╜╨╡╨╛╨▒╤Е╨╛╨┤╨╕╨╝╨╛ ╨┐╨╛╨┤╨║╨╗╤О╤З╨╡╨╜╨╕╨╡ ╨║ ╤Б╤В╨░╨▒╨╕╨╗╤М╨╜╨╛╨╝╤Г ╨╕╨╜╤В╨╡╤А╨╜╨╡╤В-╤Б╨╛╨╡╨┤╨╕╨╜╨╡╨╜╨╕╤О, ╤З╤В╨╛╨▒╤Л ╨╕╨╝╨╡╤В╤М ╨▓╨╛╨╖╨╝╨╛╨╢╨╜╨╛╤Б╤В╤М ╨╖╨░╨│╤А╤Г╨╢╨░╤В╤М ╤И╨░╨▒╨╗╨╛╨╜╤Л, ╨┐╨╛╤Б╨║╨╛╨╗╤М╨║╤Г ╨╝╤Л ╨╖╨░╨│╤А╤Г╨╢╨░╨╡╨╝ ╨╕╤Е ╨║╨░╨║ ╤А╨╡╤Б╤Г╤А╤Б╤Л, ╨┐╤А╨╡╨┤╨╛╤Б╤В╨░╨▓╨╗╤П╨╡╨╝╤Л╨╡ Microsoft Office.
   ╨н╤В╨╕╤Е ╤И╨░╨▒╨╗╨╛╨╜╨╛╨▓ ╤В╤Л╤Б╤П╤З╨╕, ╨╕ ╨▓╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨▓╤Л╨▒╤А╨░╤В╤М ╨╗╤О╨▒╨╛╨╣ ╨╕╨╖ ╨╜╨╕╤Е.

╨Ь╨╡╤В╨╛╨┤ тДЦ 2 ╨б╨╛╨╖╨┤╨░╨╜╨╕╨╡ ╤И╨░╨▒╨╗╨╛╨╜╨░ ╤А╨╡╨╡╤Б╤В╤А╨░ Excel

╨Т╤Л╨┐╨╛╨╗╨╜╨╕╤В╨╡ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨┤╨╡╨╣╤Б╤В╨▓╨╕╤П, ╤З╤В╨╛╨▒╤Л ╤Б╨╛╨╖╨┤╨░╤В╤М ╤Б╨╛╨▒╤Б╤В╨▓╨╡╨╜╨╜╤Л╨╣ ╨▒╨╡╤Б╨┐╨╗╨░╤В╨╜╤Л╨╣ ╤И╨░╨▒╨╗╨╛╨╜ ╤Б╨┐╨╕╤Б╨║╨░ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓ ╨▓ Excel ╤Б ╨╜╤Г╨╗╤П.

╨и╨░╨│ 1: ╨Т ╤П╤З╨╡╨╣╨║╨╡ B1 ╨▓╨▓╨╡╨┤╨╕╤В╨╡ ┬л╨б╨┐╨╕╤Б╨╛╨║┬╗ ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╨╖╨░╨│╨╛╨╗╨╛╨▓╨║╨░ ╨╗╨╕╤Б╤В╨░ ╨╕ ╨╜╨░╤Б╤В╤А╨╛╨╣╤В╨╡ ╨┤╨╗╤П ╨╜╨╡╨│╨╛ ╤Д╨╛╤А╨╝╨░╤В╤Л.

╨и╨░╨│ 2: ╨Т ╤П╤З╨╡╨╣╨║╨╡ A2 ╨▓╨▓╨╡╨┤╨╕╤В╨╡ ┬л╨Ф╨░╤В╨░ ╨╜╨░╤З╨░╨╗╨░ ╨╜╨╡╨┤╨╡╨╗╨╕┬╗, ╨░ ╨▓ ╤П╤З╨╡╨╣╨║╨╡ ╤А╤П╨┤╨╛╨╝ ╤Б ╨╜╨╡╨╣ (B2) ╨▓╨▓╨╡╨┤╨╕╤В╨╡ ┬л<╨┤╨┤-╨╝╨╝╨╝-╨│╨│╨│╨│>┬╗. ╨н╤В╨╛ ╤Д╨╛╤А╨╝╨░╤В, ╨▓ ╨║╨╛╤В╨╛╤А╨╛╨╝ ╨┤╨░╤В╨░ ╨▒╤Г╨┤╨╡╤В ╨╛╤В╤А╨░╨╢╨░╤В╤М ╨╜╨░╤З╨░╨╗╨╛ ╨╜╨╡╨┤╨╡╨╗╨╕.

╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨╜╨░╤Б╤В╤А╨╛╨╕╤В╤М ╤Ж╨▓╨╡╤В╨░ ╨┤╨╗╤П ╤Н╤В╨╛╨│╨╛ ╨▓ ╤Б╨╛╨╛╤В╨▓╨╡╤В╤Б╤В╨▓╨╕╨╕ ╤Б ╨▓╨░╤И╨╕╨╝╨╕ ╤В╤А╨╡╨▒╨╛╨▓╨░╨╜╨╕╤П╨╝╨╕. ╨Ь╤Л ╨┐╤А╨╕╨╝╨╡╨╜╨╕╨╗╨╕ ╤И╤А╨╕╤Д╤В ╨║╤А╨░╤Б╨╜╨╛╨│╨╛ ╤Ж╨▓╨╡╤В╨░ ╨┤╨╗╤П ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╣ ╨┤╨░╤В╤Л.

╨и╨░╨│ 3: ╨б╨╛╨╖╨┤╨░╨╣╤В╨╡ ╨┐╨╛╨╗╨╡ ╤Б ╨▓╨╜╨╡╤И╨╜╨╕╨╝╨╕ ╨│╤А╨░╨╜╨╕╤Ж╨░╨╝╨╕ (╤Н╤В╨╛ ╨╝╨╛╨╢╨╜╨╛ ╤Б╨┤╨╡╨╗╨░╤В╤М ╤Б ╨┐╨╛╨╝╨╛╤Й╤М╤О ╨║╨╜╨╛╨┐╨║╨╕ Ctrl+Shift+&) ╨╝╨╡╨╢╨┤╤Г ╤П╤З╨╡╨╣╨║╨░╨╝╨╕ B3: J5 ╨╕ ╨┤╨╛╨▒╨░╨▓╤М╤В╨╡ ╨╜╨╡╨║╨╛╤В╨╛╤А╤Л╨╡ ╨┤╨╛╨┐╨╛╨╗╨╜╨╕╤В╨╡╨╗╤М╨╜╤Л╨╡ ╤Б╨▓╨╡╨┤╨╡╨╜╨╕╤П, ╤В╨░╨║╨╕╨╡ ╨║╨░╨║ ┬л╨Ь╨╕╨╜╨╕╨╝╨░╨╗╤М╨╜╨╛╨╡ ╨║╨╛╨╗╨╕╤З╨╡╤Б╤В╨▓╨╛ ╤З╨░╤Б╨╛╨▓ ╤Б╨╝╨╡╨╜╤Л┬╗, ┬л╨Ь╨░╨║╤Б╨╕╨╝╨░╨╗╤М╨╜╨╛╨╡ ╨║╨╛╨╗╨╕╤З╨╡╤Б╤В╨▓╨╛ ╤З╨░╤Б╨╛╨▓ ╤Б╨╝╨╡╨╜╤Л┬╗, ┬л╨б╨▓╨╡╤А╤Е╤Г╤А╨╛╤З╨╜╤Л╨╡ ╤З╨░╤Б╤Л┬╗, ┬л╨б╤В╨░╨▓╨║╨░ ╨╖╨░ ╤Б╨▓╨╡╤А╤Е╤Г╤А╨╛╤З╨╜╤Г╤О ╤А╨░╨▒╨╛╤В╤Г┬╗. ┬╗, ┬л╨з╨░╤Б╤Л ╤А╨░╨▒╨╛╤В╤Л ╨▓ ╨╜╨╛╤З╨╜╤Г╤О ╤Б╨╝╨╡╨╜╤Г┬╗ ╨╕ ┬л╨Ф╨╛╨┐╤Г╤Б╤В╨╕╨╝╨░╤П ╤Б╨╝╨╡╨╜╨░┬╗, ╤З╤В╨╛╨▒╤Л ╨╖╨░╤Д╨╕╨║╤Б╨╕╤А╨╛╨▓╨░╤В╤М ╤Б╨╛╨╛╤В╨▓╨╡╤В╤Б╤В╨▓╤Г╤О╤Й╨╕╨╡ ╨┤╨╡╤В╨░╨╗╨╕.

╨и╨░╨│ 4: ╨Ш╨╖ ╤П╤З╨╡╨╡╨║ B7: J8 ╨╝╤Л ╤Б╨╛╨▒╨╕╤А╨░╨╡╨╝╤Б╤П ╨┤╨╛╨▒╨░╨▓╨╕╤В╤М ╨╜╨╡╨║╨╛╤В╨╛╤А╤Л╨╡ ╨┤╨╡╤В╨░╨╗╨╕ ╨┤╨╗╤П ╤Б╨╝╨╡╨╜╨╜╨╛╨│╨╛ ╤Б╨┐╨╕╤Б╨║╨░; ╨┐╨╛╤Н╤В╨╛╨╝╤Г ╤Б╨╛╨╖╨┤╨░╨╣╤В╨╡ ╨┐╤А╤П╨╝╨╛╤Г╨│╨╛╨╗╤М╨╜╨╕╨║ ╤Б ╨▓╨╜╨╡╤И╨╜╨╡╨╣ ╨│╤А╨░╨╜╨╕╤Ж╨╡╨╣ ╨┤╨╗╤П ╤В╨╛╨│╨╛ ╨╢╨╡ ╨┤╨╕╨░╨┐╨░╨╖╨╛╨╜╨░, ╤З╤В╨╛ ╨╕ ╨╜╨░ ╨┐╤А╨╡╨┤╤Л╨┤╤Г╤Й╨╡╨╝ ╤И╨░╨│╨╡. ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨│╤А╤Г╨▒╨╛ ╨╜╨░╨╖╨▓╨░╤В╤М ╨╖╨░╨│╨╛╨╗╨╛╨▓╨║╨╕ ╤Б╤В╨╛╨╗╨▒╤Ж╨╛╨▓ ╨┤╨╗╤П ╤Н╤В╨╛╨│╨╛ ╤Б╨┐╨╕╤Б╨║╨░. ┬л╨Ш╨╝╤П ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨░┬╗ ╨▒╤Г╨┤╨╡╤В ╨┐╨╡╤А╨▓╤Л╨╝. ╨Я╨╛╤Б╨╗╨╡ ╤Н╤В╨╛╨│╨╛ ╨║╨░╨╢╨┤╤Л╨╣ ╤Б╤В╨╛╨╗╨▒╨╡╤Ж ╨╛╤В D ╨┤╨╛ J ╤Б╨╛╨┤╨╡╤А╨╢╨╕╤В ╨╛╨┤╨╜╤Г ╨┤╨░╤В╤Г ╨╕ ╨╛╨┤╨╕╨╜ ╨┤╨╡╨╜╤М ╨╜╨╡╨┤╨╡╨╗╨╕, ╨╜╨░╤З╨╕╨╜╨░╤П ╤Б ╨┐╨╛╨╜╨╡╨┤╨╡╨╗╤М╨╜╨╕╨║╨░.

╨Ю╨▒╤А╨░╤В╨╕╤В╨╡ ╨▓╨╜╨╕╨╝╨░╨╜╨╕╨╡, ╤З╤В╨╛ ╤Д╨╛╤А╨╝╨░╤В ╤П╨▓╨╗╤П╨╡╤В╤Б╤П ╨╜╨░╤Б╤В╤А╨░╨╕╨▓╨░╨╡╨╝╤Л╨╝. ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╤М ╨╡╨│╨╛ ╨┐╨╛ ╤Б╨▓╨╛╨╡╨╝╤Г ╤Г╤Б╨╝╨╛╤В╤А╨╡╨╜╨╕╤О. ╨Ь╤Л ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╨╗╨╕ ╨║╤А╨░╤Б╨╜╤Л╨╣ ╤И╤А╨╕╤Д╤В ╨┤╨╗╤П ╨┤╨░╤В, ╤З╨╡╤А╨╜╤Л╨╣ ╨┤╨╗╤П ╨┤╨╜╨╡╨╣ ╨╕ ┬л╨Ш╨╝╤П ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨░┬╗. ╨Я╨╛╤Б╨╗╨╡ ╨┤╨╛╨▒╨░╨▓╨╗╨╡╨╜╨╕╤П ╨╖╨░╨│╨╛╨╗╨╛╨▓╨║╨░ ╨╝╤Л ╨▓╤Л╨▒╨╡╤А╨╡╨╝ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨┐╤П╤В╤М ╤П╤З╨╡╨╡╨║, ╨╜╨░╤З╨╕╨╜╨░╤П ╤Б B9: J14, ╨┤╨╗╤П ╨╖╨░╨┐╨╛╨╗╨╜╨╡╨╜╨╕╤П ╤Б╨▓╨╡╨┤╨╡╨╜╨╕╨╣ ╨╛ ╤А╨╡╨╡╤Б╤В╤А╨╡ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨░.

╨и╨░╨│ 5: ╨Т ╤Б╤В╨╛╨╗╨▒╤Ж╨╡ C ╨╝╨╡╨╢╨┤╤Г C9 ╨╕ C14 ╨┤╨╛╨▒╨░╨▓╤М╤В╨╡ ╨╖╨░╨│╨╛╨╗╨╛╨▓╨║╨╕ ╨┤╨╗╤П ╨║╨░╨╢╨┤╨╛╨╣ ╤Б╤В╤А╨╛╨║╨╕ ╨║╨░╨║ ┬л╨Э╨░╤З╨░╨╗╨╛ ╨┐╨╡╤А╨▓╨╛╨╣ ╨┐╨╛╨╗╨╛╨▓╨╕╨╜╤Л┬╗, ┬л╨Я╨╡╤А╨╡╤А╤Л╨▓ ╨╜╨░ ╨╛╨▒╨╡╨┤┬╗, ┬л╨Ъ╨╛╨╜╨╡╤Ж ╨┐╨╡╤А╨▓╨╛╨╣ ╨┐╨╛╨╗╨╛╨▓╨╕╨╜╤Л┬╗, ┬л╨Э╨░╤З╨░╨╗╨╛ ╨▓╤В╨╛╤А╨╛╨╣ ╨┐╨╛╨╗╨╛╨▓╨╕╨╜╤Л┬╗, ┬л╨Я╨╡╤А╨╡╤А╤Л╨▓ ╨╜╨░ ╤З╨░╨╣┬╗ ╨╕ ┬л╨Ъ╨╛╨╜╨╡╤Ж ╨▓╤В╨╛╤А╨╛╨╣ ╨┐╨╛╨╗╨╛╨▓╨╕╨╜╤Л┬╗. ╨б╨┤╨╡╨╗╨░╨╣╤В╨╡ ╤И╤А╨╕╤Д╤В ╨║╤Г╤А╤Б╨╕╨▓╨╛╨╝. ╨Ю╨╜ ╨┤╨╛╨╗╨╢╨╡╨╜ ╨▓╤Л╨│╨╗╤П╨┤╨╡╤В╤М ╤В╨░╨║, ╨║╨░╨║ ╨┐╨╛╨║╨░╨╖╨░╨╜╨╛ ╨╜╨░ ╤Б╨║╤А╨╕╨╜╤И╨╛╤В╨╡ ╨╜╨╕╨╢╨╡.

╨и╨░╨│ 6: ╨в╨╡╨┐╨╡╤А╤М ╨┐╤А╨╕╨╝╨╡╨╜╨╕╤В╨╡ ╤Ж╨▓╨╡╤В╨░ ╨║ ╤З╨╡╤А╨╡╨┤╤Г╤О╤Й╨╕╨╝╤Б╤П ╤П╤З╨╡╨╣╨║╨░╨╝, ╤З╤В╨╛╨▒╤Л ╤Н╤В╨╛ ╨▓╤Л╨│╨╗╤П╨┤╨╡╨╗╨╛ ╨║╨░╨║ ╤В╨░╨▒╨╗╨╕╤Ж╨░. ╨Ф╨╗╤П ╤П╤З╨╡╨╣╨║╨╕ C9 ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╣╤В╨╡ ╤Б╨▓╨╡╤В╨╗╨╛-╤А╨╛╨╖╨╛╨▓╤Л╨╣ ╤Ж╨▓╨╡╤В, ╨░ ╨┤╨╗╤П ╤П╤З╨╡╨╣╨║╨╕ C10 ╨┐╤Г╤Б╤В╤М ╨╛╨╜ ╨▒╤Г╨┤╨╡╤В ╨▒╨╡╨╗╤Л╨╝, ╤Б╨║╨╛╨┐╨╕╤А╤Г╨╣╤В╨╡ ╨╕ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╣╤В╨╡ ╤В╨╛ ╨╢╨╡ ╨░╨╗╤М╤В╨╡╤А╨╜╨░╤В╨╕╨▓╨╜╨╛╨╡ ╤Д╨╛╤А╨╝╨░╤В╨╕╤А╨╛╨▓╨░╨╜╨╕╨╡ ╤П╤З╨╡╨╡╨║ ╨▓ excel. ╨д╨╛╤А╨╝╨░╤В╨╕╤А╨╛╨▓╨░╨╜╨╕╨╡ ╤П╤З╨╡╨╡╨║ ╨▓ Excel. ╨▓ ╤Г╨┤╨╛╨▒╨╜╨╛╨╝ ╨┤╨╗╤П ╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╤В╨╡╨╗╤П ╤Д╨╛╤А╨╝╨░╤В╨╡. ╨д╨╛╤А╨╝╨░╤В╨╕╤А╨╛╨▓╨░╨╜╨╕╨╡ ╤П╤З╨╡╨╣╨║╨╕ ╨╖╨░╨▓╨╕╤Б╨╕╤В ╨╛╤В ╤Е╨░╤А╨░╨║╤В╨╡╤А╨░ ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╨╡╨╜╨╜╤Л╤Е ╨┤╨░╨╜╨╜╤Л╤Е. ╨Я╨╛╨┤╤А╨╛╨▒╨╜╨╡╨╡ ╨╛╨▒ ╨╛╤Б╤В╨░╨╗╤М╨╜╤Л╤Е ╤П╤З╨╡╨╣╨║╨░╤Е. ╨н╤В╨╛ ╨┤╨╛╨╗╨╢╨╜╨╛ ╨▓╤Л╨│╨╗╤П╨┤╨╡╤В╤М ╨║╨░╨║ ╨╜╨░ ╤Б╨║╤А╨╕╨╜╤И╨╛╤В╨╡ ╨╜╨╕╨╢╨╡.

╨и╨░╨│ 7: ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨┤╨╛╨▒╨░╨▓╨╕╤В╤М ╨╡╤Й╨╡ ╨┐╤П╤В╤М ╤Б╤В╤А╨╛╨║ ╨┤╨╗╤П ╨┤╤А╤Г╨│╨╛╨│╨╛ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨░ ╨╕ ╨┐╨╛╨▓╤В╨╛╤А╨╕╤В╤М ╤И╨░╨│╨╕ 5 ╨╕ 6, ╤З╤В╨╛╨▒╤Л ╤Б╨╛╨╖╨┤╨░╤В╤М ╤Б╨┐╨╕╤Б╨╛╨║ ╨┤╨╗╤П ╨╡╤Й╨╡ ╨╛╨┤╨╜╨╛╨│╨╛ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨░. ╨Т ╨╕╨┤╨╡╨░╨╗╨╡ ╨▓╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╤Б╨╛╨╖╨┤╨░╤В╤М ╨╡╨│╨╛ ╨┤╨╗╤П ╤В╨░╨║╨╛╨│╨╛ ╨║╨╛╨╗╨╕╤З╨╡╤Б╤В╨▓╨░ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓, ╨║╨░╨║╨╛╨╡ ╨▓╤Л ╤З╤Г╨▓╤Б╤В╨▓╤Г╨╡╤В╨╡ ╨╕╨╗╨╕ ╨╕╨╝╨╡╨╡╤В╨╡ ╨▓ ╤Б╨▓╨╛╨╡╨╣ ╨╛╤А╨│╨░╨╜╨╕╨╖╨░╤Ж╨╕╨╕.

╨Ю╨▒╤А╨░╤В╨╕╤В╨╡ ╨▓╨╜╨╕╨╝╨░╨╜╨╕╨╡, ╤З╤В╨╛ ╨╝╤Л ╨╕╤Б╨┐╨╛╨╗╤М╨╖╨╛╨▓╨░╨╗╨╕ ╤В╨╛╨╗╤Б╤В╤Г╤О ╤А╨░╨╝╨║╤Г ╨▓ ╨║╨░╤З╨╡╤Б╤В╨▓╨╡ ╤А╨░╨╖╨┤╨╡╨╗╨╕╤В╨╡╨╗╤П ╨┤╨╗╤П ╨╗╤Г╤З╤И╨╡╨╣ ╨▓╨╕╨╖╤Г╨░╨╗╨╕╨╖╨░╤Ж╨╕╨╕ ╨╕ ╤А╨░╨╖╨╗╨╕╤З╨╡╨╜╨╕╤П ╨┤╨▓╤Г╤Е ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓. ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨▓╨╕╨┤╨╡╤В╤М ╤Н╤В╨╛ ╨╜╨░ ╨╗╨╕╨╜╨╕╨╕, ╨┐╤А╨╛╨▓╨╡╨┤╨╡╨╜╨╜╨╛╨╣ ╨╝╨╡╨╢╨┤╤Г 14 ╨╕ 15 ╤Б╤В╤А╨╛╨║╨░╨╝╨╕ ╨╗╨╕╤Б╤В╨░.

╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨┤╨╛╨▒╨░╨▓╨╕╤В╤М ╨┤╨╛╨┐╨╛╨╗╨╜╨╕╤В╨╡╨╗╤М╨╜╤Л╨╡ ╨╜╨░╤Б╤В╤А╨╛╨╣╨║╨╕, ╨╜╨░╨┐╤А╨╕╨╝╨╡╤А, ╨┤╨╛╨▒╨░╨▓╨╕╤В╤М ╨╕╤В╨╛╨│╨╕. ╨в╨╡╨╝ ╨╜╨╡ ╨╝╨╡╨╜╨╡╨╡, ╤Н╤В╨╛╨│╨╛ ╨┤╨╛╨╗╨╢╨╜╨╛ ╨▒╤Л╤В╤М ╨┤╨╛╤Б╤В╨░╤В╨╛╤З╨╜╨╛ ╨┤╨╗╤П ╨▓╤Б╨╡╤Е ╨▓╨░╤И╨╕╤Е ╤В╤А╨╡╨▒╨╛╨▓╨░╨╜╨╕╨╣, ╤Б╨▓╤П╨╖╨░╨╜╨╜╤Л╤Е ╤Б ╤А╨╡╨╡╤Б╤В╤А╨╛╨╝. ╨Ф╨░╨▓╨░╨╣╤В╨╡ ╨┐╨╛╨┤╨▓╨╡╨┤╨╡╨╝ ╨╕╤В╨╛╨│╨╕, ╨▓╤Б╨┐╨╛╨╝╨╜╨╕╨▓ ╨╜╨╡╨║╨╛╤В╨╛╤А╤Л╨╡ ╨╝╨╛╨╝╨╡╨╜╤В╤Л:

╨в╨╛, ╤З╤В╨╛ ╨╜╤Г╨╢╨╜╨╛ ╨╖╨░╨┐╨╛╨╝╨╜╨╕╤В╤М

• ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨╖╨░╨│╤А╤Г╨╖╨╕╤В╤М ╤В╤Л╤Б╤П╤З╨╕ ╨╛╨╜╨╗╨░╨╣╨╜-╤Д╨░╨╣╨╗╨╛╨▓ ╤А╨╡╨╡╤Б╤В╤А╨╛╨▓ ╨╕╨╖ Microsoft Office ╨╕╨╗╨╕ ╨╕╨╖ ╨Ш╨╜╤В╨╡╤А╨╜╨╡╤В╨░. ╨Ю╨┤╨╜╨░╨║╨╛ ╤Б╨╜╨░╤З╨░╨╗╨░ ╤Г╨▒╨╡╨┤╨╕╤В╨╡╤Б╤М, ╤З╤В╨╛ ╨▓╤Л ╨┐╨╛╨┤╨║╨╗╤О╤З╨╡╨╜╤Л ╨║ ╤Б╤В╨░╨▒╨╕╨╗╤М╨╜╨╛╨╝╤Г ╨╕╨╜╤В╨╡╤А╨╜╨╡╤В-╤Б╨╛╨╡╨┤╨╕╨╜╨╡╨╜╨╕╤О.
• ╨Т╤Б╨╡╨│╨┤╨░ ╨╗╤Г╤З╤И╨╡ ╤Б╨╛╨╖╨┤╨░╤В╤М ╤Б╨▓╨╛╨╣ ╤Б╨╛╨▒╤Б╤В╨▓╨╡╨╜╨╜╤Л╨╣ ╤Б╨┐╨╕╤Б╨╛╨║. ╨Я╨╛╤Б╨║╨╛╨╗╤М╨║╤Г ╨▓╤Л ╤Б╨╛╨╖╨┤╨░╨╗╨╕ ╨╡╨│╨╛, ╨▓╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╨┤╨╛╨▒╨░╨▓╨╕╤В╤М ╨▓╤Б╨╡ ╨╜╨░╤Б╤В╤А╨░╨╕╨▓╨░╨╡╨╝╤Л╨╡ ╨┐╨╛╨╗╤П ╨▓ ╤Б╨╛╨╛╤В╨▓╨╡╤В╤Б╤В╨▓╨╕╨╕ ╤Б ╨▓╨░╤И╨╕╨╝╨╕ ╨▒╨╕╨╖╨╜╨╡╤Б-╤В╤А╨╡╨▒╨╛╨▓╨░╨╜╨╕╤П╨╝╨╕.

╨а╨╡╨║╨╛╨╝╨╡╨╜╨┤╤Г╨╡╨╝╤Л╨╡ ╤Б╤В╨░╤В╤М╨╕

╨н╤В╨░ ╤Б╤В╨░╤В╤М╤П ╨▒╤Л╨╗╨░ ╤А╤Г╨║╨╛╨▓╨╛╨┤╤Б╤В╨▓╨╛╨╝ ╨┐╨╛ ╤И╨░╨▒╨╗╨╛╨╜╤Г ╤А╨╡╨╡╤Б╤В╤А╨░ Excel. ╨Ч╨┤╨╡╤Б╤М ╨╝╤Л ╨╛╨▒╤Б╤Г╨┤╨╕╨╝ ╨┤╨▓╨░ ╤Б╨┐╨╛╤Б╨╛╨▒╨░ ╤Б╨╛╨╖╨┤╨░╨╜╨╕╤П ╨▒╨╡╤Б╨┐╨╗╨░╤В╨╜╨╛╨│╨╛ ╤И╨░╨▒╨╗╨╛╨╜╨░ ╤Б╨┐╨╕╤Б╨║╨░ ╤Б╨╛╤В╤А╤Г╨┤╨╜╨╕╨║╨╛╨▓ ╨▓ Excel, ╨┐╤А╨╕╨╝╨╡╤А╤Л ╨╕ ╨╖╨░╨│╤А╤Г╨╢╨░╨╡╨╝╤Л╨╣ ╨╗╨╕╤Б╤В Excel. ╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╤Г╨╖╨╜╨░╤В╤М ╨▒╨╛╨╗╤М╤И╨╡ ╨╕╨╖ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╤Е ╤Б╤В╨░╤В╨╡╨╣: тАУ

• ╨Я╤А╨╛╤Б╤В╨╛╨╣ ╤И╨░╨▒╨╗╨╛╨╜ ╨║╨▓╨╕╤В╨░╨╜╤Ж╨╕╨╕ Excel
• ╨п╤А╨╗╤Л╨║ ╨╜╨╛╨▓╨╛╨│╨╛ ╨╗╨╕╤Б╤В╨░ Excel
• ╨и╨░╨▒╨╗╨╛╨╜ ╨╢╤Г╤А╨╜╨░╨╗╨░ ╤Г╤З╨╡╤В╨░ ╤А╨░╨▒╨╛╤З╨╡╨│╨╛ ╨▓╤А╨╡╨╝╨╡╨╜╨╕ ╨▓ ╤Д╨╛╤А╨╝╨░╤В╨╡ Excel
• ╨и╨░╨▒╨╗╨╛╨╜ ╨▒╤О╨┤╨╢╨╡╤В╨░ ╨╝╨╡╤А╨╛╨┐╤А╨╕╤П╤В╨╕╤П ╨▓ ╤Д╨╛╤А╨╝╨░╤В╨╡ Excel
• ╨и╨░╨▒╨╗╨╛╨╜ ╨▒╤О╨┤╨╢╨╡╤В╨░ ╨┐╤А╨╛╨╡╨║╤В╨░
• ╨и╨░╨▒╨╗╨╛╨╜ ╨╗╨╕╤З╨╜╨╛╨│╨╛ ╨▒╤О╨┤╨╢╨╡╤В╨░