How to 𝗰𝗼𝗻𝘃𝗲𝗿𝘁 𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗰𝗼𝗹𝘂𝗺𝗻 𝗶𝗻𝘁𝗼 𝗮 𝗰𝗼𝗺𝗺𝗮 𝘀𝗲𝗽𝗮𝗿𝗮𝘁𝗲𝗱 𝗹𝗶𝘀𝘁 in 1-2-3 steps? → kunal-chowdhury.com/2017/01/co

Let's learn how to quickly and easily copy a column of data to a comma separated list.

#Microsoft365 #office365 #spreadsheet #excel

Last updated 1 year ago

ts thank you ☕ · @tsyum
404 followers · 1104 posts · Server thepit.social

Give us random order, and ! It would be so useful.

At this point maybe we can do it in Excel but I don’t know how. Anyone here?

#airtable #excel

Last updated 1 year ago

Pybites · @pybites
133 followers · 122 posts · Server fosstodon.org

New podcast alert 📣

In our new episode 130, we delve into the groundbreaking integration of Python within Microsoft Excel and its transformative impact on non-tech professions. 💪📈

pybit.es/articles/excel-embrac

#python #developer #podcast #excel #pdi #coaching #careerchange

Last updated 1 year ago

· @gholk
81 followers · 2015 posts · Server g0v.social

試算表的 current 函數,怪東西, 引用自身來處理遞迴引用問題。 好像沒有

wiki.documentfoundation.org/Do

#libreoffice #excel

Last updated 1 year ago

Albert Sy 🐬 · @albertsy
135 followers · 598 posts · Server nerdculture.de

I was today years old when I frustratingly found out you should not sort a column in Excel if that column is formulas.

#excel #microsoftexcel

Last updated 1 year ago

Solver Max · @SolverMax
121 followers · 144 posts · Server mathstodon.xyz

Blog: Python embedded in Excel: First impressions

Microsoft recently announced a new Excel feature, Python embedded within Excel. This is great news, as it combines our two favourite tools: Excel and Python.

Since our focus is on optimization modelling, we immediately wondered if it is possible to use a Python library to solve optimization models directly within Excel. Spoiler alert, it is!

In this article, we experiment with building and solving a linear program in Excel using the Python SciPy library.


solvermax.com/blog/python-embe

#orms #optimization #scipy #python #excel

Last updated 1 year ago

Sheridan · @BasementDweller3000
106 followers · 531 posts · Server mas.to

Writing some VBA for PowerPoint that replaces placeholder text on slides with values from an Excel spreadsheet. Basically works like mail merge in Word.

#excel

Last updated 1 year ago

OddOpinions5 · @failedLyndonLaRouchite
326 followers · 3800 posts · Server mas.to

How on earth is it possible that making a simple scatter plot in excel 2021 is harder, way harder, then in Excel 2010, 2012, or 2016

Is the office 365 version better, and MS is deliberately making the non cloud version bad to drive people to the "cloud" where MS can spy on us ?

PS: on my brand new computer doesn't work

way to go

#redmond #microsoftteams #windows #office #excel #Microsoft

Last updated 1 year ago

Elias Dabbas :verified: · @elias
63 followers · 108 posts · Server seocommunity.social

Happy to announce a new cohort for my course:

Data Science with Python for SEO 🎉 🎉 🎉

🔵 For absolute beginners
🔵 Run, automate, and scale many SEO tasks with Python like crawling, analyzing XML sitemaps, text/keyword analysis
🔵 Intro to data manipulation and visualization skills
🔵 Get started with and
🔵 Make the transition from to
🔵 Online, live, cohort-based, interactive
🔵 Spans three days in one week

bit.ly/dsseo-course

#advertools #pandas #plotly #excel #python

Last updated 1 year ago

PCS Akademie · @pcsakademie
2 followers · 39 posts · Server hessen.social
Mr.Trunk · @mrtrunk
12 followers · 19600 posts · Server dromedary.seedoubleyou.me

Betanews: Get 'Excel All-in-One For Dummies' (worth $27) for FREE betanews.com/2023/09/06/excel- -in-OneForDummies

#excelall #office2021 #article #excel #wiley

Last updated 1 year ago

Damien VIDAL · @damienvidal
119 followers · 1414 posts · Server mastodon.zaclys.com

- : notre suite bureautique où j'essaye de la maintenir le plus à jour possible (difficile de rivaliser avec et surtout dans )
- Prochainement (ex ) où j'y développerais bien des modules pour combler des besoins : callcenter, portail de supervision ...

Et surtout : qui nous rend autonome sur le déploiement de produits , plus besoin de demander aux collègues des VM

⬇️

#linux #opensource #docker #openerp #odoo #excel #powerquery #office365 #libreoffice

Last updated 1 year ago

Peter Ramer · @peter_ramer
1 followers · 12 posts · Server techhub.social
Floooo · @Floooo
62 followers · 19 posts · Server piaille.fr

Songeons que sans la miniaturisation des transistors, sans ces avancées scientifiques majeures, nous n'aurions jamais eu ces magnifiques tableaux Excel infiniment plus importants (...) que les tables rudolphines.

#excel

Last updated 1 year ago

Stephen Smith · @stephensmith
175 followers · 338 posts · Server mastodon.gamedev.place

Really , you don't have to ask me *every* single time I save it.

#excel

Last updated 1 year ago

Alex Galbraith · @alexgalbraith
30 followers · 21 posts · Server techhub.social

So true! I often say if excel was to be compromised, all global business would collapse! 😂

#geekhumour #excel #digitaltransformation

Last updated 1 year ago

Mars 1024 · @mars1024
174 followers · 2509 posts · Server techhub.social

TIL:

Excel new-line character is ASCII 10, and you can use to specify it in formulas using =CHAR(10) !!!! 😱😱

You can also find the code of the left-most character - in cell A1 - by typing =CODE(A1) !!!!

#ascii #excel #formula #tip

Last updated 1 year ago

BigEatie · @BigEatie
64 followers · 487 posts · Server fosstodon.org

One of the most frustrating things about is the inability to bulk copy formulas without changing references.

I used to be able to show formulas, copy the formulas into an external text editor, and then copy those back into excel, a boorish workaround, but it worked. Now that doesn't even seem to work -- it just pates the calculated values into my text editor.

Anyone have a solution for this?

#excel

Last updated 1 year ago

I've always been an avid budgeter. As a data person, my early days were spent making my own in MS or Google Sheets.

However, over the last 3+ years I've been using "You Need A Budget" and have loved it! It strikes an excellent balance between easy to use, customizable, and spouse approved while still retaining that "fun" factor I always have when budgeting and setting goals.

Check it out here if you're interested!

ynab.com/referral/?ref=oDFDMyw

#budget #excel #ynab

Last updated 1 year ago