How to 𝗰𝗼𝗻𝘃𝗲𝗿𝘁 𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗰𝗼𝗹𝘂𝗺𝗻 𝗶𝗻𝘁𝗼 𝗮 𝗰𝗼𝗺𝗺𝗮 𝘀𝗲𝗽𝗮𝗿𝗮𝘁𝗲𝗱 𝗹𝗶𝘀𝘁 in 1-2-3 steps? → https://www.kunal-chowdhury.com/2017/01/convert-excel-column-into-comma-separated-list.html?utm_content=buffer73c8b&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

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

#Microsoft365 #Office365 #Spreadsheet #Excel

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

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

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. 💪📈

https://pybit.es/articles/excel-embraces-python-opening-doors-to-new-roles-and-how-pdi-can-help/

#python #developer #podcast #excel #PDI #coaching #careerchange

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

https://wiki.documentfoundation.org/Documentation/Calc_Functions/CURRENT

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

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.

#Excel #Python #SciPy #optimization #orms
https://www.solvermax.com/blog/python-embedded-in-excel-first-impressions

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

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 ?

#MicroSoft #Excel #Office

PS: on my brand new #Windows computer #MicrosoftTeams doesn't work

way to go #Redmond

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 #advertools #pandas and #plotly
🔵 Make the transition from #Excel to #Python
🔵 Online, live, cohort-based, interactive
🔵 Spans three days in one week

https://bit.ly/dsseo-course

Bei uns gibt es interessante und abwechslungsreiche neue Seminare für 2024.

Alle auf einen Blick:
https://www.pcs-akademie.de/neue-seminare/

#seminare #neueseminare #onlineseminare #weiterbildung #excel #office #sketchnotes #suchmaschinenmarketing #pcsakademie

Betanews: Get 'Excel All-in-One For Dummies' (worth $27) for FREE https://betanews.com/2023/09/06/excel-all-in-one-for-dummies/ #ExcelAll-in-OneForDummies #Office2021 #Article #Excel #Wiley

【Excel】誤変換しても再入力無用！ 再変換機能でリカバー効率をアップ【いまさら聞けないExcelの使い方講座】
https://forest.watch.impress.co.jp/docs/serial/exceltips/1528992.html
#forest_watch_impress #Microsoft #Office #Excel #オフィス #エクセル #オフィス_ドキュメント #Windows #ドキュメント #tips

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

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

⬇️

There are several different ways you can get data out of Microsoft Dynamics 365 for Finance and Operations. Learn how to write x++ code to write data to a file in D365.
#Dynamics365 #Dynamics365Musings #MSDyn365 #MSDyn365Community #DYN365O #D365FO #Microsoft #d365ug #xppgroupies #D365 #Excel #WriteData #WriteToFile #Integration #datamanagement #data #Export #CSV
https://dynamics365musings.com/write-a-file-in-d365

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

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

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

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 #ASCII code of the left-most character - in cell A1 - by typing =CODE(A1) !!!!

#Excel #formula #tip

One of the most frustrating things about #Excel 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?

I've always been an avid budgeter. As a data person, my early days were spent making my own #budget in MS #Excel 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!

https://ynab.com/referral/?ref=oDFDMyw2MdfeEUnJ

#YNAB