Should you be experiencing issues storing data in Excel and need an online database to address these issues, Keene Systems, Inc. is the company to contact. They can create a database and web application that will most efficiently achieve those objectives.
I have an #Excel spreadsheet that for some reason reformats every single column when refreshed or a cell on the table is double clicked. This has just started happening and it's occurring with earlier versions of the same spreadsheet that presented no problems before. I have tried everything suggested by Microsoft to get Excel to stop reformatting the columns.
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
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.
Keene Systems, Inc.: Excel to Online Database (www.keenesystems.com)
Should you be experiencing issues storing data in Excel and need an online database to address these issues, Keene Systems, Inc. is the company to contact. They can create a database and web application that will most efficiently achieve those objectives.