bencourtice<p>I can't believe it. Microsoft seem to have removed the DD/MM/YY[YY] format for dates in Excel. I've been mostly using LibreOffice, is this a new bug in excel?<br><a href="https://aus.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://aus.social/tags/microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoft</span></a> <a href="https://aus.social/tags/windoze" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>windoze</span></a></p>
Recent searches
No recent searches
Search options
Only available when logged in.
techhub.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A hub primarily for passionate technologists, but everyone is welcome
Administered by:
Server stats:
5.4Kactive users
techhub.social: About · Status · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.3.6
#excel
19 posts · 18 participants · 2 posts today
Merle Meyerdierks<p><a class="hashtag" href="https://bsky.app/search?q=%23FreeOffice" rel="nofollow noopener noreferrer" target="_blank">#FreeOffice</a> 2024 ist ein vollständig ausgestattetes Officepaket von <a class="hashtag" href="https://bsky.app/search?q=%23Softmaker" rel="nofollow noopener noreferrer" target="_blank">#Softmaker</a> und <a class="hashtag" href="https://bsky.app/search?q=%23kostenlos" rel="nofollow noopener noreferrer" target="_blank">#kostenlos</a> für <a class="hashtag" href="https://bsky.app/search?q=%23Windows" rel="nofollow noopener noreferrer" target="_blank">#Windows</a> <a class="hashtag" href="https://bsky.app/search?q=%23Mac" rel="nofollow noopener noreferrer" target="_blank">#Mac</a> & <a class="hashtag" href="https://bsky.app/search?q=%23Linux" rel="nofollow noopener noreferrer" target="_blank">#Linux</a>
Kompatibel mit <a class="hashtag" href="https://bsky.app/search?q=%23Microsoft" rel="nofollow noopener noreferrer" target="_blank">#Microsoft</a> <a class="hashtag" href="https://bsky.app/search?q=%23Office" rel="nofollow noopener noreferrer" target="_blank">#Office</a>
<a class="hashtag" href="https://bsky.app/search?q=%23Word" rel="nofollow noopener noreferrer" target="_blank">#Word</a> > <a class="hashtag" href="https://bsky.app/search?q=%23Textmaker" rel="nofollow noopener noreferrer" target="_blank">#Textmaker</a>
<a class="hashtag" href="https://bsky.app/search?q=%23Excel" rel="nofollow noopener noreferrer" target="_blank">#Excel</a> > <a class="hashtag" href="https://bsky.app/search?q=%23Planmaker" rel="nofollow noopener noreferrer" target="_blank">#Planmaker</a>
<a class="hashtag" href="https://bsky.app/search?q=%23PowerPoint" rel="nofollow noopener noreferrer" target="_blank">#PowerPoint</a> > <a class="hashtag" href="https://bsky.app/search?q=%23Presentations" rel="nofollow noopener noreferrer" target="_blank">#Presentations</a>
<a href="https://www.freeoffice.com/de" rel="nofollow noopener noreferrer" target="_blank">www.freeoffice.com/de</a>
Forum: <a href="https://forum.softmaker.de" rel="nofollow noopener noreferrer" target="_blank">forum.softmaker.de</a>
<a class="hashtag" href="https://bsky.app/search?q=%23Unplugtrump" rel="nofollow noopener noreferrer" target="_blank">#Unplugtrump</a> <a class="hashtag" href="https://bsky.app/search?q=%23GoEuropean" rel="nofollow noopener noreferrer" target="_blank">#GoEuropean</a></p>
Francis Mangion (M)<p>Python Projects Community:</p><p><a href="https://mastodon.social/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a> vs <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> vs <a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> [Facebook]: </p><p><a href="https://www.facebook.com/share/p/1Gb5xwQguL/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">facebook.com/share/p/1Gb5xwQgu</span><span class="invisible">L/</span></a></p>
European Made<p>A free replacement for Microsoft Excel with many functions. </p><p><a href="https://europeanmade.eu/index.php/software-games-media/software/libre-office-calc-the-excel-replacement-you-can-count-on" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">europeanmade.eu/index.php/soft</span><span class="invisible">ware-games-media/software/libre-office-calc-the-excel-replacement-you-can-count-on</span></a></p><p><a href="https://mastodon.social/tags/Office" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Office</span></a> <a href="https://mastodon.social/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a> <a href="https://mastodon.social/tags/buyeuropean" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>buyeuropean</span></a></p>
Analitik solutions<p>📊 ¿Listo para dar el siguiente paso con Power Query? 🚀<br />En esta segunda parte, veremos cómo empezar a usar esta increíble herramienta y por qué te ayudará a trabajar más rápido y mejor en Excel.<br />Te permite: ✅ Importar datos de diferentes fuentes. ✅ Organizar información de forma sencilla. ✅ crear tareas repetitivas.<br />🔍 Es solo el comienzo, pero ya estás en el camino correcto.<br />🔽 Sigue la serie y aprende paso a paso cómo dominar Power Query. ✨<br /><a href="https://techhub.social/tags/Excel" class="mention hashtag" rel="tag">#<span>Excel</span></a> <a href="https://techhub.social/tags/PowerQuery" class="mention hashtag" rel="tag">#<span>PowerQuery</span></a> <a href="https://techhub.social/tags/Datos" class="mention hashtag" rel="tag">#<span>Datos</span></a> <a href="https://techhub.social/tags/Productividad" class="mention hashtag" rel="tag">#<span>Productividad</span></a><br /> </p>
LeonianUniverse😁<p>Does anyone know if it is possible to create a corolation chart in <a href="https://caneandable.social/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a>? I want to be able to agrogate some data that I've calculated in my head and be able to determine the average of different variables which I would use to get a clearer average for how many times an event occurs within a certain period of time. Sorry I have to be so vague,but this data is highly classified... at least to me and the person this data is meant for and I don't want a trace of it getting out.</p>
Python Job Support<p>butterfly symbol in MS Word <a href="https://mastodon.social/tags/computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>computer</span></a> <a href="https://mastodon.social/tags/shortcutkeys" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>shortcutkeys</span></a> <a href="https://mastodon.social/tags/butterfly" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>butterfly</span></a></p><p>butterfly symbol in MS Word <a href="https://mastodon.social/tags/computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>computer</span></a> <a href="https://mastodon.social/tags/shortcutkeys" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>shortcutkeys</span></a> <a href="https://mastodon.social/tags/keyboard" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>keyboard</span></a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://mastodon.social/tags/typing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>typing</span></a> <a href="https://mastodon.social/tags/butterfly" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>butterfly</span></a> <a href="https://mastodon.social/tags/search" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>search</span></a> <a href="https://mastodon.social/tags/symbols" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>symbols</span></a> <a href="https://mastodon.social/tags/logo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>logo</span></a> <a href="https://mastodon.social/tags/office" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>office</span></a> ... source</p><p><a href="https://quadexcel.com/wp/butterfly-symbol-in-ms-word-computer-shortcutkeys-butterfly-2/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">quadexcel.com/wp/butterfly-sym</span><span class="invisible">bol-in-ms-word-computer-shortcutkeys-butterfly-2/</span></a></p>
Daniel Schroeder aka deadlydog<p>If you live in <a href="https://hachyderm.io/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a> and haven't heard of <a href="https://hachyderm.io/tags/MonkeyTools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MonkeyTools</span></a>, check it out. It's a productivity add-in for Excel. The free version contains most features, and it only manipulates native functionality, so other users will still be able to open your workbooks without issue: <a href="https://monkeytools.ca" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">monkeytools.ca</span><span class="invisible"></span></a></p>
Python Job Support<p>Excel Interview Questions Count Hours Minutes Seconds of Day in Excel <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://mastodon.social/tags/microsoftexcel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoftexcel</span></a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a></p><p>Excel Interview Questions Count Hours Minutes Seconds of Day in Excel <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://mastodon.social/tags/microsoftexcel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoftexcel</span></a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> YEARFRAC Formula in ... source</p><p><a href="https://quadexcel.com/wp/excel-interview-questions-count-hours-minutes-seconds-of-day-in-excel-excel-microsoftexcel-excel/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">quadexcel.com/wp/excel-intervi</span><span class="invisible">ew-questions-count-hours-minutes-seconds-of-day-in-excel-excel-microsoftexcel-excel/</span></a></p>
boycottusa<p>Il existe des alternatives crédibles à la suite <a href="https://mastodon.social/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Microsoft</span></a> <a href="https://mastodon.social/tags/office" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>office</span></a> comme par exemple la suite <a href="https://mastodon.social/tags/libreoffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>libreoffice</span></a></p><p>Voici un article pour vous aider à vous y retrouver si vous êtes un utilisateur historique de <a href="https://mastodon.social/tags/word" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>word</span></a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> et autres </p><p><a href="https://mastodon.social/tags/boycottusa" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>boycottusa</span></a> </p><p><a href="https://www.zdnet.fr/pratique/libreoffice-comment-le-faire-ressembler-davantage-a-microsoft-office-408844.htm" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">zdnet.fr/pratique/libreoffice-</span><span class="invisible">comment-le-faire-ressembler-davantage-a-microsoft-office-408844.htm</span></a></p><p>Lien de téléchargement libreoffice :<br><a href="https://fr.libreoffice.org/download/telecharger-libreoffice/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">fr.libreoffice.org/download/te</span><span class="invisible">lecharger-libreoffice/</span></a></p>
Karl Voit :emacs: :orgmode:<p>The Microsoft-Dilemma - <a href="https://graz.social/tags/Europe" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Europe</span></a> as a <a href="https://graz.social/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> Colony (43min)<br><a href="https://kolektiva.media/w/cbb9f78a-9705-41f6-b7a3-e869e1a0e7f2" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">kolektiva.media/w/cbb9f78a-970</span><span class="invisible">5-41f6-b7a3-e869e1a0e7f2</span></a> (or<br><a href="https://www.youtube.com/watch?v=duaYLW7LQvg" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=duaYLW7LQv</span><span class="invisible">g</span></a> if you don't mind YT using/stealing your data)</p><p>This is how the <a href="https://graz.social/tags/EU" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EU</span></a> is paying a secret number of Millions to <a href="https://graz.social/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Microsoft</span></a> in order to stay less secure, more dependend, less self-empowered, and more corrupt.</p><p>And this was known even before the US went totally crazy, risking our future big time.</p><p>So let's change and take back control using <a href="https://graz.social/tags/FOSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS</span></a> software and open standards for true competition and actually according to our own rules for a change.</p><p><a href="https://graz.social/tags/Windows" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Windows</span></a> <a href="https://graz.social/tags/Word" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Word</span></a> <a href="https://graz.social/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a> <a href="https://graz.social/tags/PowerPoint" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PowerPoint</span></a> <a href="https://graz.social/tags/corruption" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>corruption</span></a> <a href="https://graz.social/tags/cloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>cloud</span></a> <a href="https://graz.social/tags/politics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>politics</span></a> <a href="https://graz.social/tags/politicians" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>politicians</span></a> <a href="https://graz.social/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LibreOffice</span></a> <a href="https://graz.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://graz.social/tags/Standards" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Standards</span></a> <a href="https://graz.social/tags/Money" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Money</span></a></p>
Forse (he/him)<p>My brother needs a spreadsheet program secure enough to use for patient data.</p><p>Excel is MS and works like shit on Linux.<br>LibreCalc has terrible UI (so by brother says).<br>Google Sheet is Google and is not secure enough.</p><p>Suggestions? =)</p><p><a href="https://kolektiva.social/tags/spreadsheet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spreadsheet</span></a> <br><a href="https://kolektiva.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a></p>
André Polykanine<p>Today I asked <a href="https://dragonscave.space/tags/Copilot" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Copilot</span></a> in <a href="https://dragonscave.space/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a>, then <a href="https://dragonscave.space/tags/ChatGPT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ChatGPT</span></a>, then <a href="https://dragonscave.space/tags/Claude" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Claude</span></a> to perform an extremely simple task: there is an Excel file, column C contains long descriptions. Take each cell from column C, summarize it and fill column B with the summaries or at least give me the summaries so I can fill the column manually.<br>None of them got it. I mean, it's a very simple, trivial task! Why couldn't they just summarize data? They started programming, truncating data to 100 chars (my limit), but not really summarizing with <a href="https://dragonscave.space/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> capabilities.<br>I have like 250 cells, and I don't want to do it manually, I live in 2025! Total disappointment.</p>
Analitik solutions<p>📊 ¿Manejas datos en Excel? Entonces necesitas conocer Power Query. 🚀<br />Lo que hoy haces en horas, con Power Query lo harás en minutos. ⏳✨<br />🔍 ¿No sabes qué es Power Query? Es la herramienta que cambiará tu forma de trabajar con Excel para siempre.<br />🚀 Este es solo el comienzo. Prepárate para nuestra serie de videos donde aprenderás a dominar cada uno de sus comandos y a transformar tus datos como un experto.<br />🔽 ¡Síguenos y aprende a dominar Power Query! <a href="https://techhub.social/tags/Excel" class="mention hashtag" rel="tag">#<span>Excel</span></a> <a href="https://techhub.social/tags/PowerQuery" class="mention hashtag" rel="tag">#<span>PowerQuery</span></a> <a href="https://techhub.social/tags/Productividad" class="mention hashtag" rel="tag">#<span>Productividad</span></a></p>
Shawn Brink<p>Introducing value tokens in Microsoft <a href="https://techhub.social/tags/Excel" class="mention hashtag" rel="tag">#<span>Excel</span></a> <br /><a href="https://www.elevenforum.com/t/introducing-value-tokens-in-microsoft-excel.34727/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://www.</span><span class="ellipsis">elevenforum.com/t/introducing-</span><span class="invisible">value-tokens-in-microsoft-excel.34727/</span></a></p>
Ambassador Tablicek<p>Вот если развивать тему с локальным <a href="https://lor.sh/tags/%D0%98%D0%98" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ИИ</span></a> в каждый дом, на одном ядре проца и нетребовательный к памяти, да ещё и с выходом в Интернет, одно из офигенных применений, при сохранении fair use - это возможность входа через конкретное приложение с ограниченным доступом в.. <a href="https://lor.sh/tags/%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D1%8B" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>маркетплейсы</span></a>. Чтобы владельцы маркетплейсов не стонали - ограничивать рейтлимит. <a href="https://lor.sh/tags/%D0%A1%D0%BA%D1%80%D0%B0%D0%BF%D0%BF%D0%B5%D1%80%D1%8B" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Скрапперы</span></a> с ним всё равно толком ничего не сделают, а вот локальная ИИшница, которую напрягли сложными критериями поиска, которые _не_ будет реализовывать маркетплейс, потому что это требует больших вычислительных мощностей, могла бы повысить продажи.</p><p>Звучит так, будто это всё херня, но нет. Эта штука могла бы серьёзно так бустить <a href="https://lor.sh/tags/%D0%BF%D1%80%D0%BE%D0%B4%D0%B0%D0%B6%D0%B8" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>продажи</span></a> дорогих вещей, к выбору которых люди относятся серьёзно и долго тянут с принятием решения. Это могло бы выглядеть как задание формулы для сортировки подходящих товаров на стороне клиента. К примеру с видеокартами, которые я так долго высматривал, можно было бы выделить несколько характеристик как интересующие. Я их и так выделял, но для фильтрации, а сортировки по ним нет. Буквально данные есть, а не используются! А ведь их достаточно классифицировать по двум категориям - плюсы и минусы. Плюсы перемножаем, на минусы делим. Вот и коэффициент в попугаях готов.</p><p>- Энергопотребление - минус<br>- Число CUDA-ядер - плюс<br>- Частота ядер - плюс<br>- Частота памяти - плюс<br>- Объём памяти - плюс<br>- Размер - минус<br>- Версия PCI-E - плюс<br>- Число HDMI портов до 2 включительно - плюс, дальше минус<br>- Число DP портов до 2 включительно - плюс, дальше минус<br>- Гарантийный срок - плюс<br>- Цена - минус</p><p>Бинго. Вопрос выбора видеокарты решён за 10-15 минут. Дальше то же самое проворачиваем с _локальным_ поиском этой модели в десятке мест, где <a href="https://lor.sh/tags/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE%D0%BA%D0%B0%D1%80%D1%82%D0%B0" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>видеокарта</span></a> доступна к покупке с ранжированием этих мест по удобству и информацией о доставке в них (срок, расстояние для самовывоза, стоимость доставки курьером). Сейчас, без стандартизации формата этой информации о доставке и без стандартизации информации о товарах, текущий <a href="https://lor.sh/tags/%D1%80%D1%8B%D0%BD%D0%BE%D0%BA" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>рынок</span></a> скорее является препятствием на пути потребителя к покупке, чем подспорьем. Отсутствие возможности рационального выбора может вводить в паралич. Я не хочу видеть маркетплейс с рекламой, чтобы что-то выбрать, я хочу видеть сравнительную таблицу в <a href="https://lor.sh/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a>, в которой отобрана только важная для меня информация.</p><p>У меня нет и чёткого поиска. Кейс, когда юзер ошибается во вводе или вводит слишком человечный запрос, который _нужно поправить_, похоже, более частый для маркетплейса, чем ситуация, когда после такого исправления в поисковой выдаче помойка нерелевантной херни. Наверное поэтому я хотел бы, чтобы какая-нибудь ИИ, возможно встроенная прямо в браузер дофильтровывала за маркетплейсом. Для примера можно вбить на <a href="https://lor.sh/tags/Ozon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Ozon</span></a> "Wifi mqtt термометр". У меня в выдаче среди первых 8 товаров 1, 2, 3 и 5 не поддерживают MQTT, а 4, 6, 7 и 8 - разные модификации одного и того же товара, отличающиеся длиной выносного датчика. Спасибо, блядь.</p><p>И в случае с мелкими покупками это ещё как-то решается через <a href="https://lor.sh/tags/%D0%B8%D0%BC%D0%BF%D1%83%D0%BB%D1%8C%D1%81%D1%8B" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>импульсы</span></a>, но когда речь идёт о том, чтобы потратить от трети до нескольких зарплат - происходит какая-то жесть. В случае с выбором машины я сейчас пытаюсь даже не искать ничего в интернете. Только в какой-нибудь виртуальной машине с Kali Linux, через <a href="https://lor.sh/tags/Tor" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tor</span></a> браузер, рискуя немножко набутылиться, если он вдруг подумает побыть проксёй для какого-нибудь барыги или любителя ЦП, потому что <a href="https://lor.sh/tags/%D0%BF%D1%80%D0%BE%D0%B2%D0%B0%D0%B9%D0%B4%D0%B5%D1%80" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>провайдер</span></a>, сука, сольёт эту инфу и мою контактную информацию спамерам, которых не остановит ясное и понятное нет, не остановят их и угрозы. Мне 2-3 месяца каждые 2-3 дня наёбывали звонками какие-то пидорасы из какого-то местного дилера, хотя я просто зашёл с телефона на сайт автопроизводителя посмотреть, сколько стоит одна красивая машинка, которую увидел на улице.</p><p>Имхо <a href="https://lor.sh/tags/API" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>API</span></a> для такого машинного взаимодействия мог бы стать новым <a href="https://lor.sh/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> лет через 5-10, потому что начнут приносить доход, возможно даже больший чем поисковые системы, больший чем продвижение на маркетплейсах. Увы, даже через 15 лет мы будем жить в киберпанке, в котором всё это будет доступно только через облачные <a href="https://lor.sh/tags/%D1%81%D0%B5%D1%80%D0%B2%D0%B8%D1%81%D1%8B" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>сервисы</span></a>, которые введут все те же проблемы, которые должны были решать - рекламу, ранжирование предложений от тех, кто занёс денег, повыше и т.д.</p>
TechKeysX<p>Buffer To speed up Queries in Power Query <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://mastodon.social/tags/datascience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>datascience</span></a> <a href="https://mastodon.social/tags/microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoft</span></a> <a href="https://mastodon.social/tags/powerqueryeditor" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>powerqueryeditor</span></a> <a href="https://mastodon.social/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>data</span></a></p>
Andrew<p>Soo when you get an Excel sheet with tons of merged cells and you un-merge them... You expect tons of blank cells, right? Well, this report somehow filled them all in with the merged value. Convenient! But wait, I forgot something and need to undo the un-merge.</p><p>Cue this familiar popup message, but 800 TIMES IN A ROW. Once for each re-merged cell. 🤦🏼♂️</p><p>Holding ESC for 2 minutes worked but now the error sound effect is still glitching in the background as I work.</p><p><a href="https://mnstdn.monster/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://mnstdn.monster/tags/microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoft</span></a></p>
David Smith<p>Writing Regular Expressions in Excel is my new hammer. </p><p>I'm sure I'll confuse coworkers but I'm finding it a gain over nested Left/Right/Mid/Find functions. </p><p><a href="https://support.microsoft.com/en-us/office/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">support.microsoft.com/en-us/of</span><span class="invisible">fice/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57</span></a></p><p><a href="https://fosstodon.org/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Excel</span></a></p>
Laurențiu Leahu-Vlăducu<p>As some of you might know, I'm a co-maintainer of the XLNT library (or rather the xlnt-community fork) for parsing Excel files (xlsx / xlsm formats).</p><p>Today I have an important announcement: 5 years after the previous release, XLNT 1.6.0 has been released! 🎉 😀 <a href="https://github.com/xlnt-community/xlnt/releases/tag/v1.6.0" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/xlnt-community/xlnt</span><span class="invisible">/releases/tag/v1.6.0</span></a></p><p><a href="https://mastodon.social/tags/xlnt" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>xlnt</span></a> <a href="https://mastodon.social/tags/cpp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>cpp</span></a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a></p>
ExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload