Should software like #Obsidian, #Excel, and the various flavours of #PlainTextAccounting be wrestled into doing things that can often be done more easily with other apps, or with #analog solutions? Consider using the 3-step recipe from my latest newsletter for choosing tools that support your values and promote peaceful contentment.
anyone out there ever come across behaviour in #excel#ExcelTips where a scatter chart without connecting lines infuriatingly adds them every time you open the file? pls boost for reach
Künstliche Intelligenz: Diese Excel-Tabelle zeigt euch, wie GPT- Modelle funktionieren
Wolltet ihr schon immer die Grundzüge einer KI verstehen? Dabei hilft euch jetzt Schritt für Schritt eine Excel-Tabelle der etwas anderen Art (und mit einer Größe von über 1GB)
Feeling stuck with Excel for data analysis? You're not alone! Excel is fantastic, but for truly powerful insights and visualizations, it can fall short.
Here's what you'll gain:
🧐 * Advanced data manipulation & cleaning
💻 * Powerful statistical analysis & modeling
📉 * Eye-catching data visualizations
🌟 * Seamless integration back to Excel
One of the main problems is that Excel is being used (and promoted) for things it was not designed for. Working with real data in an efficient way. Use only #Python instead and you get everything (for free). No processing in the Microsoft/Excel/Python cloud (Grrrrrr, there is no cloud, just other people's computer clusters). No one will spy on your data or even steal your idea! #excel#microsoft#cloud#cluster#nofree#python
https://canarytokens.org - generate unique honeypot resources that should never be accessed by anyone. Unless they are scanning your network or there was a breach. Get notified by email or webhook. Sample resources: URL, DNS domain, #Word/#Excel/#PDF document (notify on open), etc.
Can also be used to detect leaks. For example, each developer can have a fake, unique AWS credentials on their machine. If someone attempts to use said credentials through API, you know whose computer was compromised
Unlock Excel's potential with "Extending Excel with Python and R"! Seamlessly integrate Python and R for advanced data analysis, visualization, and automation. Import/export data, automate tasks, execute VBA macros, perform statistical analysis, create ggplot2/matplotlib graphs, and call functions directly from VBA. Whether beginner or expert, this book elevates Excel skills. Pre-order! Amazon: https://www.amazon.com/dp/1804610690/ref=tsm_1_fb_lk
Unleash Excel date power in R! Convert formats to proper dates effortlessly. With as.Date() & convertToDateTime(), transform data for smoother analysis. Dive into R, empower your data journey! Try it yourself & elevate your analysis game!
LazyToot: Was für ein Ding kann ich in HomeAssistant benutzen, wenn ich einmal in der Woche meinen Stromzähler manuell ablese und das dort aber irgendwie loggen will? Gibt es da etwas, was Sinn macht? Oder mach ich doch lieber eine Excel-Tabelle?
I forget exactly when I bought this HP laptop I'm currently using. It was at least 5 years ago, and I grabbed it for school. It has Windows 10 that came on it preinstalled. I used it for a bunch of school stuff over the last few years, never had any issues.
Today, I'm trying to mess around in Excel, I'm logged into my Microsoft account like usual, and it's trying to tell me I have to pay now to keep using Excel? It just gives an option to pay or shut it down. After 5+ years of using legitimate, paid-for Microsoft Office products on here. SUCH weird garbage.
Super thankful for LibreOffice and being able to reset all my defaults to that.
I wonder how many data breaches there have been because someone filtered a spreadsheet and thought the recipient couldn't get to the data or notice that it was hidden.
What's that? Your #FOSS apps already completely replaced #Word and #Excel on my workstation years ago when Microsoft tried to charge a subscription for #MicrosoftOffice?
My internet research is not working today. On Friday, I had found a way to add a semi-colon at the end of each #Excel cell with the Custom format cell and I cannot for the life of me find it again. What's the "take whatever the text is and add a character at the end"?
🤦♀️
[Even better if someone knows how to take two columns in Excel, and merge them with a semicolon between the both of them.]