This VBA macro saves an Excel worksheet as a PDF. It sets and sorts the data, creates a temporary sheet with headers, formats and aligns the data, and adjusts column widths. The macro defines the PDF path, deletes any existing file, sets page orientation and footer, exports the sheet to PDF, deletes the temporary sheet, and shows a message with the PDF path. Modify to your needs if you find it useful.
Hiermit möchte ich #LibreOffice mal ein Kränzchen winden: Seit den 2000er Jahren benutze ich die freie Office-Suite. (Vor dem Fork war es #OpenOffice) Privat, wie geschäftlich. Die Schriftartenersetzung ermöglicht mir Vorlagen, die platformübergreifend funktionieren. Der mächtige Text-Importer von Calc begeistert mich im Gegensatz von #Excel immer wieder aufs Neue. Vielen Dank, liebe Opensource-Gemeinde, für die tolle Software!
(1/2) I have been following the work of @stevensanderson and David Kum for a few years now, and I am excited to see the release of their new book 🥳- Extending Excel with Python and R 🚀.
The book focuses on the common conjunction and collaboration between data scientists and Excel users. This includes scaling and automating #Excel tasks with #RStats and #Python and core data science applications such as data wrangling, working with APIs, data visualization, and modeling.
This project is actually a byproduct of another big thing I'm working on.
Currently, I use YNAB for budgeting, but I've been putting sustained effort into getting my data out of the cloud and self-hosting everything.
I started researching options for budgeting software, and I really couldn't find anything I liked or that felt like it had enough features.
I decided, then, to just whip up something in Excel... which led me to the discovery of Office.js and the ability to build Add-ins for Excel using web tech.
Thus, vue-excel was born.
I may eventually release my budgeting tool for Excel, when it's feeling a little more mature and stable. Stay tuned... ❤️
Mal was ohne Rollenspielbezug: Kennst sich hier jemand sehr gut mit #Excel aus?
Wenn ich aus einem anderen Fenster zurück zu Excel wechsle, wählt es nicht die Zelle aus, auf die ich klicke, sondern die, die ich zuletzt aktiviert hatte.
Bei Libre Office ist das anders - da lande ich immer dort, wo ich hinklicke. So möchte ich das auch gerne in Excel.
Ich hab mich halb tot gesucht in den Einstellungen, Google hilft mir gar nicht, und Copillot möchte mir irgendeinen dubiosen Code unterjubeln.
Dobra. W Was jedyna nadzieja, bo mnie coś trafi powiem szczerze. Nie umiem excela, chyba że takie proste rzeczy jak w gimnazjum. Tego nie ogarniam, a zostałem poproszony o pomoc. Ktoś wie jak się takie rzeczy robi? Bo podejrzewam, że tu trzeba machnąć przestawną, ale za żadne skarby świata nie wiem jak to działa.
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
For all that #dataScience seems like a specialized corner of academia, I end up teaching on a wide swath from #qualitative coding and #groundedTheory to high-performance computing. Yesterday it was #dataHygiene in #Excel - today the pendulum swings and I'm teaching #webscraping with #Python. At least it keeps my #adhd from turning into boredom though.