▶ video
Views: 56
Public channel
ID 70659412484274
Google Таблицы и Excel
Только прикладная польза про работу с данными без лишней теории и скучных лекций.
Быстрые туториалы, формулы в один клик и готовые решения для автоматизации ваших задач.
Прокачиваем логику работы в таблицах, чтобы вы тратили меньше сил на отчетность.
The section failed to load.
The data did not refresh — the previous period is still shown.
Channel analytics
Dashboard
22 October — 28 October 2026
Loading…
SubscribersHow many subscribers the channel has now. The wave shows subscribers at each point of the period. The change is against the start of the period.
705
7.1 %
+47 for the period
ViewsHow many views the posts published in the period have now. These are not views per day: MAX does not report how many views there were yesterday. The percentage is the change in the daily average: the current period is still running (today is not over yet), so it is compared with the previous one by pace rather than by total. “Was” is the whole previous period of the same length.
1 071
44.3 %
was 2 129
ReactionsHow many reactions the posts published in the period have. The percentage is the change in the daily average: the current period is still running (today is not over yet), so it is compared with the previous one by pace rather than by total. “Was” is the whole previous period of the same length.
21
31.6 %
was 34
MentionsHow many times other channels mentioned the channel: links and reposts, excluding advertising posts. The bigger the circle, the more mentions at that point of the period. The percentage is the change in the daily average: the current period is still running (today is not over yet), so it is compared with the previous one by pace rather than by total. “Was” is the whole previous period of the same length.
with a subscription
RepostsHow many times other channels reposted this channel's posts (excluding advertising posts). Reposts are also counted as mentions. The percentage is the change in the daily average: the current period is still running (today is not over yet), so it is compared with the previous one by pace rather than by total. “Was” is the whole previous period of the same length.
after signing in
Average post reachHow many views one post gets on average. Only posts older than two days are counted: views of fresh posts are still growing. Points with fresh posts are dashed with hollow dots: the reach of all posts right now, it will still grow.
190
19.9 %
was 237
ERRWhat share of subscribers sees an average post: average reach ÷ subscribers × 100 %. The line shows ERR at each point of the period, the dashed line — ERR of the previous period of the same length. Points with posts younger than two days are hollow dots on the dashed end of the line.
26.9 %
9.1 pp
dashed line — was 36.0 %
Engagement ERHow often readers react to posts: reactions ÷ views × 100 %. The tick on the bar is the previous period.
1.96 %
0.4 pp
was 1.60 %
Posts per dayHow many posts are published per day on average. Each cell is a point of the period: the darker, the more posts per day. The percentage is the change in the daily average: the current period is still running (today is not over yet), so it is compared with the previous one by pace rather than by total. “Was” is the whole previous period of the same length.
1.0
13.9 %
was 1.3
Ad shareWhat share of the period's posts looks like advertising: erid labeling, ad links and other signs. The scale shows the ad load by the quality index thresholds: up to 10 % — low, up to 25 % — moderate, up to 50 % — high, above — very high. A growing share is marked red.
with a subscription
TrendTop — subscribers at the end of each point of the period; bottom — growth per point: green means more subscribers, red means fewer. Above the growth chart — the biggest gain and the biggest loss. MAX does not report how many people subscribed and unsubscribed separately.
Audience growth
+47subscribers in the period
+19 biggest gain · 23 Oct 2026
Channel scoreA channel score from 0 to 100 made of five parts: audience, growth integrity, ad load, trust and calculation reliability. Each bar shows how many points the part earned out of its maximum. The index is recalculated every night; channels are compared with similar ones of the same category and size.
How it is calculated
Quality index
61/ 100Medium
- Audienceordinary: a post is seen by 35% of subscribers 11/25
- Growth integritysteady growth, no signs of fake subscribers 25/25
- Ad loadlow: no ads 14/20
- Trustowner not verified 4/20
- Calculation reliabilityenough data 8/10
Tip: verify the channel via the datool.ru bot — this is part of Trust.
ReachHow many views the posts published at each point of the period have now (not views per day). The record is labeled; the point with today is paler — the day is not over yet. Average post reach — posts older than two days.
Views and reach
1 071views in the period 44.3 %
Average post reach — 190 views (posts older than two days).
EngagementER — reactions divided by views, in percent — for the posts of each point of the period. The dashed line is ER for the whole period. The change is in percentage points against the previous period of the same length.
Subscriber engagement
1.96 %ER = reactions ÷ views 0.4 pp
Channel ER
average for the period
CitationsThe citation index (CI) shows how often and by which channels this channel is mentioned over the last 30 days, excluding advertising posts. The level is its place among similar channels. The line shows CI at each point of the period (for a week or month — the average over its days).
How it is calculated
Citation index
The citation index has not been calculated yet: it will appear after the nightly calculation once other channels mention the channel.
RhythmHow many posts are published on average in each hour of each weekday, Moscow time: the darker the cell, the more posts. “Best time” — the hours when posts older than two days have the highest average reach.
When and how much it posts
FormatsWhat the feed is made of. Each post has one format, by priority: repost, video, photo, link, text. The bar and percentages show the share of posts of each format; on the right — average reach of one post of the format (posts older than two days), the small bar compares it with the most viewed format.
Post formats
PostsEach dot is a post in the period: horizontally — publication date, vertically — views, dot size — reactions, color — format. This shows hits, flops and how reach changes. For large channels, the 100 most viewed posts and an even sample of the rest are shown — no more than 1,500 dots.
Every post is a dot
Higher means more views, bigger means more reactions. Click a dot to open the post.
SummaryTotals for the selected period: how many posts were published, how many views and reactions they have now and the average post reach. Views are the current views of posts published on those days, not views per day. The change is against the same span before the period, if statistics cover it.
Period totals
Click a metric to see it across the period below
AdsWhat share of the period's posts looks like advertising: erid labeling, ad links and other signs. The detector is cautious, so the real share is usually higher. The scale shows the ad load by the quality index thresholds. Below — the average reach of an ad post and a regular post, and who the channel advertises (sites that ad links lead to).
More
Ads in the channel
What worksPosts of the period with the most views. The bar shows views relative to first place. The preview is the post's image; for a post without an image — the channel avatar. Views are the post's current count.
All posts
Top posts
By views for the period
RhythmHow many posts were published each day of the period (pale bars) and the 7-day average (line): you can see whether the channel is speeding up or slowing down. Today is not over yet, so its average is calculated up to yesterday.
Posts by day
Pale bars are days, the line is the 7-day average: you can see whether the channel is speeding up or slowing down
Posts per day
7-day average
Data updated at 07:47 Moscow time. Views are the current counts of posts published on those days; average reach counts posts older than two days. How the quality index is calculated
Posts for the period
Loading…
▶ video
Складываешь числа вручную? Excel умеет делать это за секунду.
Выдели диапазон и используй:
=SUM(B2:B20)
Excel автоматически сложит все значения.
А если хочешь ещё быстрее — выдели нужные числа и посмотри на строку состояния внизу окна Excel.
Там сумма может появиться без единой формулы.
⚡ Маленький приём, который часто экономит время.
Google Таблицы и Excel
Выдели диапазон и используй:
=SUM(B2:B20)
Excel автоматически сложит все значения.
А если хочешь ещё быстрее — выдели нужные числа и посмотри на строку состояния внизу окна Excel.
Там сумма может появиться без единой формулы.
⚡ Маленький приём, который часто экономит время.
Google Таблицы и Excel
Views: 104
▶ video
#Н/Д, #ДЕЛ/0! и другие ошибки портят отчёт?
Можно показать вместо ошибки нормальный текст.
Например:
=IFERROR(A2/B2;"Нет данных")
Если расчёт невозможен, Excel вместо ошибки покажет:
Нет данных
💡 Особенно полезно в отчётах и больших таблицах.
Google Таблицы и Excel
Можно показать вместо ошибки нормальный текст.
Например:
=IFERROR(A2/B2;"Нет данных")
Если расчёт невозможен, Excel вместо ошибки покажет:
Нет данных
💡 Особенно полезно в отчётах и больших таблицах.
Google Таблицы и Excel
▶ video
Почему Excel считает одинаковые слова разными?
Иногда проблема в лишних пробелах.
Например:
Иванов
и
Иванов
визуально почти одинаковы, но для Excel это могут быть разные значения.
Используй:
=TRIM(A2)
Формула удалит лишние пробелы из текста.
🔥 Особенно полезно после копирования данных из других программ.
Google Таблицы и Excel
Иногда проблема в лишних пробелах.
Например:
Иванов
и
Иванов
визуально почти одинаковы, но для Excel это могут быть разные значения.
Используй:
=TRIM(A2)
Формула удалит лишние пробелы из текста.
🔥 Особенно полезно после копирования данных из других программ.
Google Таблицы и Excel
▶ video
Источник сводной таблицы
Изменение структуры данных в источнике сводной таблицы.
Google Таблицы и Excel
Изменение структуры данных в источнике сводной таблицы.
Google Таблицы и Excel
▶ video
А если нужны последние символы?
Например:
INV-2026-4589
Нужно получить только:
4589
Используй:
=RIGHT(A2;4)
Excel автоматически возьмёт последние 4 символа.
💡 Очень удобно для номеров заказов, артикулов и кодов.
Google Таблицы и Excel
Например:
INV-2026-4589
Нужно получить только:
4589
Используй:
=RIGHT(A2;4)
Excel автоматически возьмёт последние 4 символа.
💡 Очень удобно для номеров заказов, артикулов и кодов.
Google Таблицы и Excel
▶ video
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…
Loading…