Магия Excel | Telegram Webview: lemur_excel/611 -

Telegram Group & Telegram Channel

Магия Excel

Три правила структурирования данных в Excel из книги Data Modeling with Microsoft Excel:

1. В каждом столбце одно поле (например, имя, возраст, оклад или отдел)
2. Каждая строка – одна запись, одна операция — один элемент, в общем.
3. В каждой ячейки одно значение. Если там текст, то не должно быть чисел или других данных. Если вы вводите адрес, города и индексы должны быть в разных столбцах. Тогда вы сможете фильтровать и анализировать данные отдельно по городам и индексам.

Короче говоря, вместо одной ячейки "Оплачено 19.08.2025 218572 руб." должно быть 2 (дата оплаты и сумма) или даже 4 (статус, дата, сумма, валюта). Но точно не все в одной 😊

www.group-telegram.com/ye/lemur_excel.com/612

14.7K viewsMay 12 at 10:45

group-telegram.com/lemur_excel/611

Create: 2025-05-12
Last Update: 2025-06-18 20:28:14

Три правила структурирования данных в Excel из книги Data Modeling with Microsoft Excel:

1. В каждом столбце одно поле (например, имя, возраст, оклад или отдел)
2. Каждая строка – одна запись, одна операция — один элемент, в общем.
3. В каждой ячейки одно значение. Если там текст, то не должно быть чисел или других данных. Если вы вводите адрес, города и индексы должны быть в разных столбцах. Тогда вы сможете фильтровать и анализировать данные отдельно по городам и индексам.

Короче говоря, вместо одной ячейки "Оплачено 19.08.2025 218572 руб." должно быть 2 (дата оплаты и сумма) или даже 4 (статус, дата, сумма, валюта). Но точно не все в одной 😊

BY Магия Excel

Share with your friend now:
group-telegram.com/lemur_excel/611

Open in Telegram

Telegram | DID YOU KNOW?

Date: 2025-06-18|

Now safely in France with his spouse and three of his children, Kliuchnikov scrolls through Telegram to learn about the devastation happening in his home country. The gold standard of encryption, known as end-to-end encryption, where only the sender and person who receives the message are able to see it, is available on Telegram only when the Secret Chat function is enabled. Voice and video calls are also completely encrypted. Apparently upbeat developments in Russia's discussions with Ukraine helped at least temporarily send investors back into risk assets. Russian President Vladimir Putin said during a meeting with his Belarusian counterpart Alexander Lukashenko that there were "certain positive developments" occurring in the talks with Ukraine, according to a transcript of their meeting. Putin added that discussions were happening "almost on a daily basis." "We're seeing really dramatic moves, and it's all really tied to Ukraine right now, and in a secondary way, in terms of interest rates," Octavio Marenzi, CEO of Opimas, told Yahoo Finance Live on Thursday. "This war in Ukraine is going to give the Fed the ammunition, the cover that it needs, to not raise interest rates too quickly. And I think Jay Powell is a very tepid sort of inflation fighter and he's not going to do as much as he needs to do to get that under control. And this seems like an excuse to kick the can further down the road still and not do too much too soon." But Telegram says people want to keep their chat history when they get a new phone, and they like having a data backup that will sync their chats across multiple devices. And that is why they let people choose whether they want their messages to be encrypted or not. When not turned on, though, chats are stored on Telegram's services, which are scattered throughout the world. But it has "disclosed 0 bytes of user data to third parties, including governments," Telegram states on its website.
from ye

Telegram Магия Excel
FROM American