Приемы работы с умными таблицами (часть 3) Вставка формул Использование умных таблиц позволяет упростить рутинные операции. Например, при вставке формулы в одну из ячеек мы автоматически получим аналогичную формулу во всем соответствующем столбце. Но это удобство может создавать проблемы, если в других ячейках столбца формулы должны отличаться. Мы можем управлять автозаполнением формул с помощью параметров автоз…

Channel
Excel Hacks | Бухгалтерия и Аналитика
@hacks_excel
On this record: Topic · Growth · Engagement · What this channel posts · Advertising · Posts · Citations · Telegram's recommendations · Cite this entry
283,790subscribers
-1,366 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 |
| Created | 23 September 2019 — measured — cross-checked against a third-party dataset (ext.tg_channel) |
| First recorded | 6 August 2026 |
| Last confirmed live | 25 October 2026 |
| Measurements held | 99 |
| Confirmed unchanged | 1 time, most recently 25 October 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 why it has no browse page of its own yet.
Growth
| Measured (UTC) | Subscribers | Change |
|---|---|---|
| 25 Oct 2026, 13:46 | 283,790 | -15 |
| 25 Oct 2026, 10:50 | 283,805 | -26 |
| 24 Oct 2026, 14:51 | 283,831 | -10 |
| 24 Oct 2026, 13:10 | 283,841 | -1 |
| 23 Oct 2026, 17:56 | 283,842 | -17 |
| 23 Oct 2026, 13:05 | 283,859 | -16 |
| 22 Oct 2026, 20:37 | 283,875 | -16 |
| 22 Oct 2026, 10:59 | 283,891 | -58 |
| 21 Oct 2026, 19:49 | 283,949 | -27 |
| 21 Oct 2026, 01:45 | 283,976 | +301 |
| 20 Oct 2026, 12:40 | 283,675 | +335 |
| 19 Oct 2026, 22:29 | 283,340 | +6 |
| 19 Oct 2026, 15:19 | 283,334 | -31 |
| 18 Oct 2026, 22:26 | 283,365 | -12 |
| 18 Oct 2026, 17:34 | 283,377 | -32 |
| 17 Oct 2026, 19:48 | 283,409 | +4 |
| 17 Oct 2026, 14:09 | 283,405 | -34 |
| 16 Oct 2026, 22:16 | 283,439 | -29 |
| 16 Oct 2026, 12:20 | 283,468 | -16 |
| 16 Oct 2026, 00:20 | 283,484 | first reading |
Engagement
117 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 198 pages of Telegram’s post history, 20 posts per page.
- ERR · 30 days
- 2.95%
- avg views ÷ 283,790 subscribers
- Avg views / post
- 8,370
- 37 posts measured
- Reaction rate
- —
- this channel exposes no reaction counts
- Posts in window
- 37
- of 117 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 24 October 2026 |
|---|---|
| Posts held | 117 (25 July 2026 – 24 October 2026) |
| Views total | 309,560 |
| Reactions total | — |
| Forwards / comments | not exposed by the public surface — not measured, not estimated |
| Readings taken | 25 Oct 2026, 13:20 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
- Video runtime
- 16h 06m
- Average length
- 16m 06s
Measured directly from 60 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
- 2.56%
- 3 of 117 posts carry an ad marker
- Regulatory tokens
- 3
- posts carrying an erid · 3 distinct tokens
- Median views · ads
- 7,710
- over 3 measured posts
- Median views · rest
- 8,810
- over 114 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. The sample on one side is under five posts, which is too thin to compare. The two figures are shown side by side with the count behind each, and deliberately not divided into a headline like “ads get x% fewer views” — an arithmetic that is easy to print and, at this sample size, means nothing.
| erid | Posts | First seen | Last seen |
|---|---|---|---|
| 2VtzqwtnEYK | 1 | 14 August 2026 | 14 August 2026 |
| 2VtzqxVxoCw | 1 | 20 August 2026 | 20 August 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 117 most recent posts we hold, published 25 July 2026 to 24 October 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
Хочешь разбираться в 1С? Для тебя уже всё сделали. ⚙️ Канал 1С Hacks рассказывает обо всех возможностях, приёмах и лайфхаках по работе в 1С. Подписывайтесь и прокачивайте свои навыки: @secrets_1C
Количество и сумма ячеек по цвету В этом видео автор разбирает простой способ подсчёта количества и суммы ячеек по цвету в Excel — с помощью пользовательских функций вы реализуете суммирование по цвету заливки или текста ячейки, а также разберете аналогичный пример и для подсчета количества ячеек одинакового цвета.. Смотреть это видео на youtube: youtu.be/_KsRExUoQBw
Excel Hacks теперь в MAX! Информация по решению типовых проблем в Excel еще никогда не была такой доступной, как сейчас. Внутри канала все возможности, приёмы и лайфхаки по работе с таблицами. Подписывайтесь и прокачивайте свои навыки: @hacks_excel
Как объединить ячейки в Excel Объединение ячеек – известная команда, однако на выполнение этой операции часто уходит много времени. В этом видео автор подробно разберет, что подразумевают под объединением ячеек и как быстро выполнить эту операцию, выбрав оптимальный вариант. Вы рассмотрите все способы объединения ячеек в Excel: форматирование, выравнивание по центру, функции СЦЕПИТЬ, СЦЕП и ОБЪЕДИНИТЬ и др.. Смотр…
Развивайся играя Платформа Wikium — сервис для тренировки памяти, внимания и мышления. Система автоматически адаптируется под вашу успеваемость и составляет индивидуальную программу занятий. Всего 10-15 минут в день дают улучшение работоспособности, скорости обучения и концентрации. Также вы можете овладеть конкретным навыком в короткие сроки на специализированном курсе: • Развитие внимания; • Скорочтение; • Эмо…
Выделение цветом столбцов или строк на диаграмме в Excel В этом видео автор разбирает способ, позволяющий визуально выделять определенные столбцы или строки на диаграмме, что преобразит внешний вид ваших графиков. 00:00 Визуализация самого высокого и самого низкого столбца на гистограмме 00:53 Как выделить столбец на диаграмме? 04:37 Как выделить несколько столбцов на диаграмме? 06:03 Подсветка строк на графике…
Обучишься Excel — станешь аналитиком 📌 Полезные приёмы, гайды, лайфхаки эксель и аналитики данных для начинающих на канале @ba_sa_analytics. Подписывайся и становись аналитиком: @ba_sa_analytics
📌 8 инструментов в Excel, которыми должен уметь пользоваться каждый В этом ролике автор подробно разбирает восемь полезных инструментов Excel, которые обязательно пригодятся каждому. 00:22 Условное форматирование 03:41 Текст по столбцам 05:32 Фильтр и сортировка 10:09 Удаление дубликатов 12:08 Выпадающие списки 14:21 Подсказки по вводу 15:39 Сводные таблицы 16:28 Примечания Смотреть это видео на youtube: …
Как успешно сменить работу? Узнаешь в этом канале. 📌 Канал @secrets_hr делится полезными секретами и лайфхаками в составлении резюме, трудоустройстве и управлении персоналом для HR. Подписывайтесь и прокачивайте свои навыки: @secrets_hr
Приемы работы с умными таблицами (часть 2) Строка итогов Быстро подвести итоги по столбцу можно с помощью соответствующей опции вкладки Конструктор, при этом из выпадающего списка можно выбрать одну из стандартных функций, либо сформировать свою формулу. Аналогичного эффекта можно добиться при помощи сочетания клавиш ALT + =. Однако это сочетание работает не только с умными таблицами — таким же образом можно вы…
Лень разбираться в Python? Для вас уже всё сделали. 📌 Канал Python Hacks рассказывает обо всех возможностях, приёмах и лайфхаках по обучению python. Подписывайтесь и прокачивайте свои навыки: @python_secrets
Showing the 12 most recent of 117 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.
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 3 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,0316 postsСекреты аналитики | Data Science, BI, Tableau
@analytics_secrets · 46,9754 postsPython Hacks
@python_secrets · 40,4914 postsAI с Софьей и Натали
@ai_finansist · 15,6713 postsСистемный и Бизнес-анализ
@ba_sa_analytics · 52,7033 postsБазы данных | Access, SQL, Big Data
@databases_secrets · 30,1033 postsDevOps School | Linux, InfoSec, ИБ
@devops_sc · 14,7963 postsУправление персоналом | hr, карьера, кадры
@secrets_hr · 21,9853 postsСекреты сисадмина | DevOps, Linux, SRE
@sysadmin_library · 25,8313 postsФинансовый анализ
@fin_analytics · 41,2822 postsУправление проектами и продуктами в IT | Project & Product Management
@product_and_project · 16,6902 postsStudent invest
@studentinvest · 42 postsЯхонтова про финансы и удаленку
@yahontova_profinance · 6,1642 postsФинансовый директор | Мастер CFO
@findir_pro · 44,2691 postИскра
@iskrachan · 2,9621 postLumio Pay
@lumiopay · 1,2781 postТЕХНО: Яндекс про технологии
@techno_yandex · 221,3001 postПереход Что за инвестор
@WhatTheInvestor · 2261 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,282#1
@analytics_secrets · 46,975#2
@ba_sa_analytics · 52,703#3
@databases_secrets · 30,103#4
@python_secrets · 40,491#5
@secrets_hr · 21,985#6
@excelhackru · 73,790#7
@product_and_project · 16,690#8
@google_sheets · 59,839#9
@excel_everyday · 52,176#10
@lemur_excel · 49,859#11
@gulchikk · 8,128#12
@free_edu · 307,581#13
@DimHelpWithExcel · 11,552#14
@sberbank · 733,482#15
@accwhisper · 50,578#16
@sysadmin_library · 25,831#17
@ML_secrets · 7,384#18
@lektorium20 · 114,643#19
@moscowmap · 2,638,082#20
@exploitex · 2,013,394#21
@bhblaw · 31,612#22
@yaplakal · 420,289#23
@RepostUZ · 90,869#24
@bugfeature · 558,835#25
@uznews · 70,756#26
@pravoinf · 32,785#27
@temalebedev · 970,517#28
@potrebitel_uz · 38,662#29
@kurbanoffnet · 14,704#30
@buh_uz · 18,443#31
@Lepragram · 341,448#32
@rozetked · 653,436#33
@lifeyt · 328,582#34
@uzbekistan_online_novosti_uznews · 56,067#35
@centralbankuzbekistan · 44,401#36
@bugnotfeature · 1,131,859#37
@NationGeographic · 323,545#38
@mudak · 526,855#39
@pikabu · 254,974#40
@d_code · 405,433#41
@tb_invest_official · 523,960#42
@media1337 · 1,117,171#43
@bankmijoz · 49,441#44
@Reddit · 161,394#45
@flibusta_anglysky · 367,414#46
@alfabank · 976,632#47
@gosuslugi · 990,634#48
@normauz · 12,778#49
@sportsmens1 · 286,099#50
@driverone · 464,409#51
@uzmdk · 201,097#52
@mash · 3,150,184#53
@bbbreaking · 1,976,451#54
@yurasumy · 2,673,006#55
@bazabazon · 1,560,134#56
@trolluz · 77,486#57
@gazetauz · 85,946#58
@banksta · 438,669#59
@pressauz · 299,484#60
@spotuz · 27,211#61
@davletovuz · 78,438#62
@wylsared · 1,097,672#63
@makarenko_channel · 36,136#64
@podrobno · 57,132#65
@fuckingenglish · 308,696#66
@whackdoor · 1,558,078#67
@the_bakiroo · 60,431#68
@twitt_ota · 329,437#69
@oper_goblin · 491,598#70
@shmirziyoyev · 253,867#71
@bomber_fighter · 526,836#72
@mig41 · 479,320#73
@kinopoisk · 798,307#74
@NovostiUZ · 79,804#75
@vysokygovorit · 488,650#76
@rkadyrov_95 · 2,047,850#77
@wargonzo · 740,448#78
@medvedev_telegram · 1,692,865#79
@xushnudbek · 773,425#80
@ruGrammar · 120,666#81
@sladkov_plus · 697,427#82
@prikoly · 366,720#83
@russicaru · 424,602#84
@FactTG · 204,343#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,985
Telegram ranks this channel #1 of 93 here — alongside 92 others — read 22 September 2026
@databases_secrets · 30,103
Telegram ranks this channel #1 of 82 here — alongside 81 others — read 7 September 2026
@python_secrets · 40,491
Telegram ranks this channel #1 of 82 here — alongside 81 others — read 30 August 2026
@fin_analytics · 41,282
Telegram ranks this channel #1 of 87 here — alongside 86 others — read 29 August 2026
@secrets_1C · 46,031
Telegram ranks this channel #1 of 79 here — alongside 78 others — read 27 August 2026
@analytics_secrets · 46,975
Telegram ranks this channel #1 of 85 here — alongside 84 others — read 27 August 2026
@ba_sa_analytics · 52,703
Telegram ranks this channel #1 of 90 here — alongside 89 others — read 24 August 2026
@excelhackru · 73,790
Telegram ranks this channel #1 of 87 here — alongside 86 others — read 19 August 2026
@lemur_excel · 49,859
Telegram ranks this channel #2 of 95 here — alongside 94 others — read 25 August 2026
@excel_everyday · 52,176
Telegram ranks this channel #2 of 97 here — alongside 96 others — read 24 August 2026
@Vnaime_norm · 80,560
Telegram ranks this channel #2 of 94 here — alongside 93 others — read 18 August 2026
@lifehackoftheday · 25,793
Telegram ranks this channel #3 of 97 here — alongside 96 others — read 13 September 2026
@eruditurl24 · 96,697
Telegram ranks this channel #4 of 86 here — alongside 85 others — read 16 August 2026
@teacherus · 34,838
Telegram ranks this channel #5 of 94 here — alongside 93 others — read 3 September 2026
@google_sheets · 59,839
Telegram ranks this channel #5 of 98 here — alongside 97 others — read 22 August 2026
@accwhisper · 50,578
Telegram ranks this channel #9 of 96 here — alongside 95 others — read 25 August 2026
@free_edu · 307,581
Telegram ranks this channel #9 of 95 here — alongside 94 others — read 10 August 2026
@lektorium20 · 114,643
Telegram ranks this channel #11 of 96 here — alongside 95 others — read 14 August 2026
@iworldcom · 31,862
Telegram ranks this channel #18 of 73 here — alongside 72 others — read 5 September 2026
@procode404 · 40,244
Telegram ranks this channel #23 of 83 here — alongside 82 others — read 30 August 2026
@neobyasnimofact · 22,265
Telegram ranks this channel #24 of 64 here — alongside 63 others — read 19 September 2026
@i_am_artis · 105,217
Telegram ranks this channel #25 of 77 here — alongside 76 others — read 15 August 2026
@algebra_shpargalki · 23,961
Telegram ranks this channel #27 of 86 here — alongside 85 others — read 17 September 2026
@analyst_club · 33,391
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 25 October 2026 — this entry's latest reading, not the date you are reading this.
“Excel Hacks | Бухгалтерия и Аналитика” (@hacks_excel), 283,790 subscribers as measured 25 October 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.