Секреты проверки данных в Excel Проверка данных позволяет решить множество разнообразных задач. В этом видео рассмотрим несколько примеров. 0:00 Проверка данных в Excel 0:19 Запрет ввода данных по условию 2:01 Проверка на дубликаты 4:00 Обвести неверные данные.. Смотреть это видео на youtube: youtu.be/BEEzjHwDOKs

Channel
Excel Hacks | Бухгалтерия и Аналитика
@hacks_excel
On this record: Topic · Growth · Engagement · What this channel posts · Advertising · Posts · Posts recorded as deleted · Citations · Telegram's recommendations · Cite this entry
283,052subscribers
-2,104 since we began measuring on 6 August 2026
Risers and fallers across the register · movement among entries of 100,000–316,228.
Register entry
| Telegram ID | -1001150636847 |
|---|---|
| Type | Channel |
| Usernames | @excel @hacks_excel |
| Description | Научим тебя эффективной работе в Excel. Сотрудничество: @max_excel MAX: max.ru/hacks_excel РКН: vk.cc/cHiCFp |
| Created | 23 September 2019 — measured — cross-checked against a third-party dataset (ext.tg_channel) |
| First recorded | 6 August 2026 |
| Last confirmed live | 10 November 2026 |
| Measurements held | 129 |
| Confirmed unchanged | 1 time, most recently 10 November 2026 |
| On Telegram | t.me/hacks_excel |
Topic
Education — a classification, not a measurement. An on-box language model (Qwen3.6-35B-A3B-UD-Q6_K_XL, prompt version 1) read this channel’s own recent posts on 8 August 2026 and assigned it the closest of 31 fixed categories, at 98% confidence. This is a model’s judgement about what the channel is likely to be about, not a fact this register measured the way a subscriber count or a view count is measured — it can be revised on a later pass, and it carries no weight anywhere else on this page. How this classification works, and the other topics.
Growth
| Measured (UTC) | Subscribers | Change |
|---|---|---|
| 10 Nov 2026, 22:18 | 283,052 | -39 |
| 10 Nov 2026, 10:51 | 283,091 | -51 |
| 9 Nov 2026, 06:59 | 283,142 | -8 |
| 8 Nov 2026, 22:07 | 283,150 | -48 |
| 7 Nov 2026, 20:11 | 283,198 | -10 |
| 7 Nov 2026, 12:07 | 283,208 | -29 |
| 6 Nov 2026, 17:08 | 283,237 | -20 |
| 6 Nov 2026, 11:47 | 283,257 | -12 |
| 5 Nov 2026, 15:08 | 283,269 | -24 |
| 5 Nov 2026, 10:37 | 283,293 | -41 |
| 4 Nov 2026, 14:40 | 283,334 | -5 |
| 4 Nov 2026, 12:36 | 283,339 | -39 |
| 3 Nov 2026, 14:56 | 283,378 | no change |
| 3 Nov 2026, 13:32 | 283,378 | -33 |
| 2 Nov 2026, 18:20 | 283,411 | -4 |
| 2 Nov 2026, 10:36 | 283,415 | -35 |
| 1 Nov 2026, 20:01 | 283,450 | -26 |
| 1 Nov 2026, 10:18 | 283,476 | -15 |
| 31 Oct 2026, 17:45 | 283,491 | -28 |
| 31 Oct 2026, 09:06 | 283,519 | first reading |
Engagement
136 posts held, back to 25 July 2026 — the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 239 pages of Telegram’s post history, 20 posts per page.
- ERR · 30 days
- 2.80%
- avg views ÷ 283,052 subscribers
- Avg views / post
- 7,920
- 38 posts measured
- Reaction rate
- —
- this channel exposes no reaction counts
- Posts in window
- 38
- of 136 held
ERR is average views per post over the last 30 days divided by subscribers, the definition TGStat uses, so this figure is comparable with the one you will see elsewhere. It falls structurally as a channel grows: a high ERR on a small channel and a low one on a large channel describe reach mathematics, not quality. We publish the figure and the sample it came from and pass no verdict on it.
ER is defined industry-wide as (forwards + reactions + comments) ÷ views — note the denominator is views, not subscribers. Telegram’s public web preview carries views and reactions but not forward or comment counts, so the reaction rate above is the reactions term only and is therefore a floor: the true ER for this channel is higher by an amount we have not measured and will not estimate.
| Window | Rolling 30 days · latest post in window 10 November 2026 |
|---|---|
| Posts held | 136 (25 July 2026 – 10 November 2026) |
| Views total | 301,120 |
| Reactions total | — |
| Forwards / comments | not exposed by the public surface — not measured, not estimated |
| Readings taken | 11 Nov 2026, 01:13 UTC |
Views are a single reading per post, taken at the time above. A post published in the last day or two is still accumulating views, which pulls the 30-day average down slightly. That is a property of the standard definition rather than a fault in it, so we keep the definition rather than “correcting” the number into something nobody can reproduce.
Precision. Telegram publishes view counts on its public widget in short form — 8.12K, 3.7M — so any reading at or above 1,000 reaches us rounded to three significant figures, and only counts below 1,000 are exact. Averages and rates derived from them are shown to the same precision rather than to the unit: a figure like 3,701,250 would assert digits nobody measured.
Reaction counts are published per emoji and rounded the same way, so a total below 1,000 is exact and a larger one is a sum that may carry a rounded component from each emoji above 1,000. Because it is a sum, it does not look rounded — read a large reaction total as three significant figures per contributing emoji rather than as the figure it prints.
What this channel posts
- Photos
- 64
- Videos
- 157
- Links
- 662
Lifetime counters from Telegram’s own channel header, read 11 November 2026 — not the date at the top of this page, which is when the subscriber count was last read. Below Telegram’s rounding threshold, so these counts are exact.
- Video runtime
- 18h 15m
- Average length
- 15m 26s
Measured directly from 71 videos with a duration reading, out of the posts we hold for this channel — not this channel’s whole posting history, only the sample this register has actually read. An exact reading to the second, taken from the post itself rather than from Telegram’s own rounded chrome, so it carries no ≈ mark.
Advertising
- Ad load
- 3.68%
- 5 of 136 posts carry an ad marker
- Regulatory tokens
- 5
- posts carrying an erid · 5 distinct tokens
- Median views · ads
- 7,080
- over 5 measured posts
- Median views · rest
- 8,610
- over 131 measured posts
An ad marker, not a judgement about a post. A post is counted here because it carries one of two explicit markings: an erid token, which Russian law has required on paid placements since 2022 and which is issued against a specific advertising contract, or a #реклама / #ad hashtag in the body, which is the channel declaring it itself. The first is documentary; the second is a self-declaration and is weaker. No classifier reads the text and decides — nothing on this site guesses that a post is an advertisement.
This is a floor, and it can only ever be a floor. A channel that runs paid placements without marking them produces no marker for us to count, and an unmarked ad is indistinguishable from an ordinary post on the public surface. The ad load above therefore means “the share of posts that declared themselves”, never “the share of posts that were paid for”. A low figure is not evidence of a channel that runs few ads.
Both figures are medians, and no ratio between them is published. Each is a view reading that actually occurred on a post, picked by percentile_disc rather than averaged, so one viral post cannot move it and no interpolated value is invented between two readings. They are printed side by side with the count behind each rather than as a ratio: an ad and an ordinary post are not otherwise matched — for topic, for length, for hour of day — so the gap between them is a description of two groups and not the effect of one being an ad.
| erid | Posts | First seen | Last seen |
|---|---|---|---|
| 2VtzqwcUNyU | 1 | 9 November 2026 | 9 November 2026 |
| 2VtzqwtnEYK | 1 | 14 August 2026 | 14 August 2026 |
| 2VtzqxVxoCw | 1 | 20 August 2026 | 20 August 2026 |
| 2W5zFG6LpSN | 1 | 9 November 2026 | 9 November 2026 |
| 2W5zFGURM2h | 1 | 9 October 2026 | 9 October 2026 |
A token repeated across several posts is one advertising contract placed more than once, which is what the identifier is for. The strings are reproduced exactly as they appeared in the post or in its click-through URL and are not validated against any registry — we record the marker a channel published, and whether it resolves to a real contract is a question for the register that issued it.
Measured over the 136 most recent posts we hold, published 25 July 2026 to 10 November 2026. Views are the latest single reading held for each post, and any reading at or above 1,000 is rounded by Telegram to three significant figures.
Recent posts
Telegram’s own ‘edited’ marker: 1 of 38 posts held from the last 30 days (2.63%) carried it when this register last read them. The marker says a post was changed after publishing, not what it said before — this register holds the earlier wording only where an edit fell between two of its own reads (see the edit ledger and how it is measured).
Как предпринимателю делегировать работу с документами сотрудникам и не передавать свою КЭП? Больше не нужно просить предпринимателя передавать свою КЭП сотрудникам — в ЭДО от Точка Банка можно использовать машиночитаемую доверенность (МЧД). Руководитель даёт бухгалтеру или менеджеру доступ в интернет-банк для работы в ЭДО. За пару минут выпускает доверенность и определяет, с какими документами сотрудник может работ…
Создаем нестандартные диаграммы в Excel В этом видеоуроке автор рассматривает процесс создания нестандартных диаграмм. 00:19 Водопадная диаграмма 04:11 Спидометр 09:39 График со сценариями 17:39 Pie in pie диаграмма.. Смотреть это видео на youtube: youtu.be/ajDjZozX3BQ
Курсы и сертификаты работодатель видит. Но ждет в первую очередь другого Пройденные курсы и тренажеры — важная часть резюме, их учитывают. А дальше нанимающий менеджер хочет услышать, как вы разберете рабочую задачу. Этот ответ открывает дверь на второй этап. 10 ноября в 18:00 мск karpovꓸcourses проводит бесплатный вебинар «Нет опыта – нет оффера? Как получить опыт аналитика, близкий к рабочему». На эфире: — по ка…
Быстрый способ добавления функции Переходить по кнопке «Fx» в шапке программы и искать популярную (или даже никому не известную) функцию — бессмысленно. Сэкономьте время: перейдите во вкладку «Формулы». Там откроется полное меню для добавления и редактирования имеющихся формул. По одному клику можно создать известную формулу, там же еë настроить и произвести вычисления.
Клиент приходит к разработчику 1С с задачей по конфигурации. А через какое-то время пишет: нужно докупить рабочие места, продлить ИТС или подобрать ещё одну лицензию. Это уже не совсем разработка. Нужно разобраться с подбором, счётом, оформлением и отгрузкой. И всё это параллельно основной работе. Но необязательно заниматься всем этим самостоятельно или отправлять клиента искать какого-то франчайзи 1С. У компании …
Выборочное форматирование ячеек Предположим, вам понадобилось выделить жирным текстом только определённые значения в таблице, сохраняя при этом форматирование других ячеек. Для этого можно нажать сочетание клавиш CTRL + H и ввести форматируемое значение в поле Найти. В поле Заменить на введите то же значение, после чего нажмите на Параметры → Формат. В появившемся окне на вкладке Шрифт остаётся лишь выбрать наче…
Развивайся играя Платформа Wikium — сервис для тренировки памяти, внимания и мышления. Система автоматически адаптируется под вашу успеваемость и составляет индивидуальную программу занятий. Всего 10-15 минут в день дают улучшение работоспособности, скорости обучения и концентрации. Также вы можете овладеть конкретным навыком в короткие сроки на специализированном курсе: • Развитие внимания; • Скорочтение; • Эмо…
Как вставить чек-бокс (флажок) в Excel В этом видео автор подробно расскажет, как работать с чек-боксами в эксель, то есть как вставить в ячейку галочку, с помощью которой можно будет отмечать какие-либо пункты в списке или управлять форматированием целой строки. 00:00 Вступление 00:20 Как включить вкладку Разработчик 00:45 Вставка и настройка флажка 04:13 Пример 1 05:32 Флажок в формулах 06:28 Пример 2 07:46…
Хочешь разбираться в 1С? Для тебя уже всё сделали. ⚙️ Канал 1С Hacks рассказывает обо всех возможностях, приёмах и лайфхаках по работе в 1С. Подписывайтесь и прокачивайте свои навыки: @secrets_1C
Создание сводной таблицы в Excel: пошаговая инструкция В этом видеоуроке автор поделится подробной и пошаговой инструкцией создания сводной таблицы в Excel. А также вы узнаете зачем нужны сводные таблицы, как с ними работать и как группировать сводные таблицы по месяцам. 0:00 Вступление 0:24 Зачем нужны сводные таблицы 0:48 Как построить сводную таблицу 1:41 Как устроены области и поля 2:33 Настройка внешнего …
Как 15+ экспертов из СКОЛКОВО, Т1 и Rickꓸai внедрили ИИ в финансы и 1С… ...и решили бесплатно показать свои рабочие схемы 26 и 27 ноября на онлайн-конференции «КонФин 2027»! Что в программе конференции? Как отдать нейросети заведение документов и автоматический поиск ошибок в проводках. Как вытаскивать отчёты прямо из живой базы без программистов и Excel. Как через Python-скрипты и сверку с первоисточником сделать…
Showing the 12 most recent of 136 posts we hold for @hacks_excel. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked ≈ was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.
Posts recorded as deleted after publishing
We recorded 77 posts on @hacks_excel as deleted — posts this register held that were missing from the channel’s public page on two separate reads, taken from different network addresses at least an hour apart.
A deletion is not wrongdoing. This register can see that a post it held is no longer on the channel’s public page, and when — not why. Expired ad placements, reposts, rotating links and corrections all look the same. This is a count of recorded detections, not an exact total: it misses deletions we could not see, because only a post we held and later re-read inside the page can be seen to go, and it may include a small number of wrong records. How this is measured.
- First seen missing
- 7 August 2026
- Most recent seen missing
- 10 November 2026
- Median time before seen missing
- 8 days
- Seen missing in the last 30 days
- 27
Forward network
Republishes
Channels on the register whose posts this channel has forwarded.
Built only from forwarded posts we have actually read, on both sides. Coverage is early and deliberately incomplete: a missing link means we have not read the post that would prove it, never that the relationship does not exist. Counts are distinct forwarded posts observed, so they only ever go up as we read more.
Mentions
Named by 4 registered channels — every channel on the register whose own posts have named this one, by its current username or any other username it currently holds, merged from two separately captured readings of the same fact so a namer caught by only one of them is not missed and a namer both caught is not counted twice. A username this channel has since dropped is not matched — that handle may belong to someone else now, and crediting today’s namer to yesterday’s owner would misattribute it.
Named by
Channels on the register whose posts name this channel's handle.
Names
Channels on the register whose handles appear in this channel's posts.
@secrets_1C · 46,4597 postsСекреты аналитики | Data Science, BI, Tableau
@analytics_secrets · 46,8144 postsDevOps School | Linux, InfoSec, ИБ
@devops_sc · 14,7564 postsPython Hacks
@python_secrets · 40,3324 postsAI с Софьей и Натали
@ai_finansist · 16,0353 postsСистемный и Бизнес-анализ
@ba_sa_analytics · 52,4843 postsБазы данных | Access, SQL, Big Data
@databases_secrets · 30,0123 postsФинансовый анализ
@fin_analytics · 41,5383 postsУправление проектами и продуктами в IT | Project & Product Management
@product_and_project · 16,6013 postsУправление персоналом | hr, карьера, кадры
@secrets_hr · 21,8003 postsСекреты сисадмина | DevOps, Linux, SRE
@sysadmin_library · 25,7233 postsФинансовый директор | Мастер CFO
@findir_pro · 44,2742 postsStudent invest
@studentinvest · 52 postsЯхонтова про финансы и удаленку
@yahontova_profinance · 6,1222 postsИскра
@iskrachan · 3,0231 postLumio Pay
@lumiopay · 1,3001 postТЕХНО: Яндекс про технологии
@techno_yandex · 218,5691 postПереход Что за инвестор
@WhatTheInvestor · 2251 postXLTable News 📢
@xltable_news · 271 post
A mention is a weaker signal than a forward and is counted separately for that reason — naming a channel is not republishing it, and a handle in a post body is easy to place deliberately. The post counts beside each row below are distinct posts in which the handle appeared, from posts we have read on both sides — the “Named by N registered channels” figure above is a different count, of distinct NAMING CHANNELS rather than posts, and is not the sum of the rows under it.
Channels Telegram recommends alongside this one
Telegram’s own answer, not this register’s. When this register asks Telegram’s API what is similar to this channel, this is the list it returns, in the exact order Telegram returns it — never re-sorted by subscribers or by anything else this register measures. The relationship, and the order, are Telegram’s; we record them and date them, and make no claim of our own about which of these channels actually resemble this one.
@fin_analytics · 41,538#1
@analytics_secrets · 46,814#2
@ba_sa_analytics · 52,484#3
@databases_secrets · 30,012#4
@python_secrets · 40,332#5
@secrets_hr · 21,800#6
@excelhackru · 74,003#7
@product_and_project · 16,601#8
@google_sheets · 59,478#9
@excel_everyday · 52,038#10
@lemur_excel · 49,845#11
@gulchikk · 8,121#12
@free_edu · 306,697#13
@DimHelpWithExcel · 11,541#14
@sberbank · 727,507#15
@accwhisper · 50,493#16
@sysadmin_library · 25,723#17
@ML_secrets · 7,365#18
@lektorium20 · 114,343#19
@moscowmap · 2,622,185#20
@exploitex · 2,022,997#21
@bhblaw · 31,593#22
@yaplakal · 419,820#23
@RepostUZ · 91,728#24
@bugfeature · 552,118#25
@uznews · 71,711#26
@pravoinf · 32,707#27
@temalebedev · 968,108#28
@potrebitel_uz · 38,640#29
@kurbanoffnet · 14,767#30
@buh_uz · 18,468#31
@Lepragram · 340,793#32
@rozetked · 646,921#33
@lifeyt · 326,954#34
@uzbekistan_online_novosti_uznews · 54,789#35
@centralbankuzbekistan · 45,049#36
@bugnotfeature · 1,162,637#37
@NationGeographic · 322,427#38
@mudak · 524,131#39
@pikabu · 254,974#40
@d_code · 405,444#41
@tb_invest_official · 521,159#42
@media1337 · 1,103,517#43
@bankmijoz · 49,195#44
@Reddit · 160,928#45
@flibusta_anglysky · 366,343#46
@alfabank · 981,016#47
@gosuslugi · 988,723#48
@normauz · 12,762#49
@sportsmens1 · 285,250#50
@driverone · 462,000#51
@uzmdk · 202,662#52
@mash · 3,140,033#53
@bbbreaking · 1,975,436#54
@yurasumy · 2,662,248#55
@bazabazon · 1,557,057#56
@trolluz · 83,235#57
@gazetauz · 86,083#58
@banksta · 439,838#59
@pressauz · 295,559#60
@spotuz · 27,630#61
@davletovuz · 78,632#62
@wylsared · 1,088,291#63
@makarenko_channel · 35,963#64
@podrobno · 57,162#65
@fuckingenglish · 307,122#66
@whackdoor · 1,538,229#67
@the_bakiroo · 60,521#68
@twitt_ota · 418,557#69
@oper_goblin · 490,249#70
@shmirziyoyev · 255,796#71
@bomber_fighter · 525,130#72
@mig41 · 476,724#73
@kinopoisk · 794,552#74
@NovostiUZ · 78,391#75
@vysokygovorit · 485,001#76
@rkadyrov_95 · 2,026,626#77
@wargonzo · 738,065#78
@medvedev_telegram · 1,688,832#79
@xushnudbek · 754,128#80
@ruGrammar · 120,322#81
@sladkov_plus · 692,737#82
@prikoly · 364,443#83
@russicaru · 417,710#84
@FactTG · 204,234#85
Read from Telegram’s recommendation API, most recently 10 August 2026. Telegram holds a list like this for a small and growing share of the register — how this is measured, and why most channel pages show nothing here.
Appears in Telegram’s recommendations for other channels
The reverse of the list above, and a different kind of signal. This does not require this channel to have ever been asked about directly — each row below is a channel we DID ask Telegram about, whose Telegram-generated list happened to include this one. A channel can appear here with an empty list above it, because being named by someone else’s query is independent of having been queried itself.
@secrets_hr · 21,800
Telegram ranks this channel #1 of 93 here — alongside 92 others — read 22 September 2026
@databases_secrets · 30,012
Telegram ranks this channel #1 of 82 here — alongside 81 others — read 7 September 2026
@python_secrets · 40,332
Telegram ranks this channel #1 of 82 here — alongside 81 others — read 30 August 2026
@fin_analytics · 41,538
Telegram ranks this channel #1 of 87 here — alongside 86 others — read 29 August 2026
@secrets_1C · 46,459
Telegram ranks this channel #1 of 79 here — alongside 78 others — read 27 August 2026
@analytics_secrets · 46,814
Telegram ranks this channel #1 of 85 here — alongside 84 others — read 27 August 2026
@ba_sa_analytics · 52,484
Telegram ranks this channel #1 of 90 here — alongside 89 others — read 24 August 2026
@excelhackru · 74,003
Telegram ranks this channel #1 of 87 here — alongside 86 others — read 19 August 2026
@lemur_excel · 49,845
Telegram ranks this channel #2 of 95 here — alongside 94 others — read 25 August 2026
@excel_everyday · 52,038
Telegram ranks this channel #2 of 97 here — alongside 96 others — read 24 August 2026
@Vnaime_norm · 80,321
Telegram ranks this channel #2 of 94 here — alongside 93 others — read 18 August 2026
@lifehackoftheday · 25,876
Telegram ranks this channel #3 of 97 here — alongside 96 others — read 13 September 2026
@eruditurl24 · 96,339
Telegram ranks this channel #4 of 86 here — alongside 85 others — read 16 August 2026
@teacherus · 34,718
Telegram ranks this channel #5 of 94 here — alongside 93 others — read 3 September 2026
@google_sheets · 59,478
Telegram ranks this channel #5 of 98 here — alongside 97 others — read 22 August 2026
@accwhisper · 50,493
Telegram ranks this channel #9 of 96 here — alongside 95 others — read 25 August 2026
@free_edu · 306,697
Telegram ranks this channel #9 of 95 here — alongside 94 others — read 10 August 2026
@lektorium20 · 114,343
Telegram ranks this channel #11 of 96 here — alongside 95 others — read 14 August 2026
@iworldcom · 31,748
Telegram ranks this channel #18 of 73 here — alongside 72 others — read 5 September 2026
@procode404 · 40,080
Telegram ranks this channel #23 of 83 here — alongside 82 others — read 30 August 2026
@neobyasnimofact · 22,070
Telegram ranks this channel #24 of 64 here — alongside 63 others — read 19 September 2026
@i_am_artis · 104,797
Telegram ranks this channel #25 of 77 here — alongside 76 others — read 15 August 2026
@algebra_shpargalki · 23,756
Telegram ranks this channel #27 of 86 here — alongside 85 others — read 17 September 2026
@analyst_club · 33,324
Telegram ranks this channel #30 of 96 here — alongside 95 others — read 4 September 2026
This channel appears in 79 seed channels' Telegram-generated recommendation lists in total, of which the 24 where it ranks highest are shown above. Each is Telegram’s list for THAT channel, not this one — see how this is measured.
Cite this entry
A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 10 November 2026 — this entry's latest reading, not the date you are reading this.
“Excel Hacks | Бухгалтерия и Аналитика” (@hacks_excel), 283,052 subscribers as measured 10 November 2026. Telegram Register, tgregister.com/channel/hacks_excel.
Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.