Free #book alert
As #health #tech and #policy assessment graduates from proprietary spreadsheet apps (like #Microsoft #Excel) to open, generalizable, and powerful systems like #Rstats, a generation of researchers need to retool.
This book is for them: https://gianluca.statistica.it/books/online/r-hta/
Microsoft bringt neue "Formel erklären"-Funktion für #Excel, die komplexe Formeln durch KI-Unterstützung verständlicher macht. Der #Copilot soll direkt im Tabellenraster Hilfestellungen geben. https://winfuture.de/news,152879.html?utm_source=Mastodon&utm_medium=ManualStatus&utm_campaign=SocialMedia
#python #excel #automation
#technology #dashboard
#datascience #dataanalytics
#datavisualization #datamanagement
Synergizing MS Excel & Python Batch Processing Hands Down
A Beginner-Friendly One-Stop Python Automation Shop of Excel Tasks & Reports to Increase Productivity in the Workplace: from Fast File I/O to Low-Code AutoEDA & Interactive Dashboards for Business to Grow
@Haikyoneko @stinerman @anon_opin Or maybe even VisiCalc?
#Excel -Lifehack: Vermutlich wisst Ihr das schon längst, ich habe es eben "entdeckt".
Um eine Formel oder Reihe in die darunterliegenden Zellen zu kopieren, habe ich immer das grüne Quadrat am rechten unteren Zellenrand geklickt und nach unten bis zum Ende des gewünschten Bereiches gezogen.
Eben habe ich mehr aus Versehen einen Doppelklick darauf gemacht und schwupps, war die Formel in alle Zellen darunter kopiert.
Ein echter Gamechanger bei Tabellen mit x.000 Zeilen...
I just remembered I have a photograph of it. it was originally a pillow but I recently had it framed for my daughter/grandkids.
GUESS WHAT GUESS WHAT GUESS WHAT!!!! The next version of Excel will have auto-updating pivot tables!!!
I just found out about 'Spreadsheet Champions' - a first of a kind documentary about people competing in an official Microsoft #Excel competition 
I so want to watch this!!!
Might be difficult to find a place to stream it, any ideas, send them my way 
New documentary Spreadsheet Champions follows six competitors as they head to the Microsoft Office Specialist world championship in Florida
[…]
Six years ago, Melbourne-based film-maker Kristina Kraskov read an article about an international Microsoft Excel competition and had two thoughts. The first: “What the hell, that can’t be real.” The second: “There’s got to be a film about this – I want to watch it so badly.”
“Six years ago, #Melbourne-based film-maker #KristinaKraskov read an article about an international #MicrosoftExcel competition and had two thoughts. The first: “What the hell, that can’t be real.” The second: “There’s got to be a film about this – I want to watch it so badly.”
There wasn’t a film about competitive #spreadsheeting, so Kraskov decided to make it herself. The subject appealed to the director, whose work captures “different inner worlds that are a bit unusual on the outside”, including a short film titled Party in the Back, about a mullet festival.
#Spreadsheet Champions, which will screen at the Melbourne international film festival, follows six young competitors from around the world as they head to Florida for the 2023 #MicrosoftOffice Specialist world championship to showcase their skills. It might sound silly, but Excel is an incredibly sophisticated #application – according to the #documentary, the average person uses only 10-15% of its capabilities, but would-be competitors are required to understand closer to 70% of what it can do.”
Joel Spolsky (MS Excel PM) would get a kick out of this.
#Microsoft / #applications / #MSOffice / #Excel<https://www.theguardian.com/film/2025/aug/02/excelling-in-excel-inside-the-high-stakes-secretive-world-of-competitive-spreadsheeting>
#Microsoft to disable #Excel workbook links to blocked file types
Automate API Requests from Excel Using Power Automate!
Take control of your workflow with a no-code solution that seamlessly integrates Excel and API calls. 
Leverage Power Automate to dynamically process multiple API requests from Excel data.
Set up an automated flow that reads, loops, and calls APIs efficiently.
Simplify response handling and data storage without manual coding.
Spreadsheets have been with us forever. The pic shows an Egyptian monthly accounts from the archive of a temple, similar to a modern spreadsheet in analysis. From the Louvre's collection. #spreadsheets #excel
Spreadsheets like Excel can act like a virus in organizations, spreading uncontrollably and causing data management chaos. Unchecked use leads to errors, security risks, and inefficiencies, much like a viral infection. #DataManagement #Excel #OrganizationalRisks 𝗵𝘁𝘁𝗽𝘀://𝗼𝘀-𝘀𝗰𝗶.𝗰𝗼𝗺/𝗯𝗹𝗼𝗴/𝗼𝘂𝗿-𝗯𝗹𝗼𝗴-𝗽𝗼𝘀𝘁𝘀-𝟭/𝘁𝗵𝗲-𝘃𝗶𝗿𝗮𝗹-𝗻𝗮𝘁𝘂𝗿𝗲-𝗼𝗳-𝘀𝗽𝗿𝗲𝗮𝗱𝘀𝗵𝗲𝗲𝘁-𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝘀-𝗹𝗶𝗸𝗲-𝗲𝘅𝗰𝗲𝗹-𝗶𝗻-𝗼𝗿𝗴𝗮𝗻𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝗮𝗹-𝗱𝗮𝘁𝗮-𝗺𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁-𝟲𝟱
Microsoft finally fixes the worst thing about Excel's pivot tables - PC World
Today's Poll... 
Which is your favorite Python package for working with Excel files?
Have you ever wanted to UNHIDE a specific row in Excel amidst a lot of hidden rows?
1. F5 & enter the cell of the row to unhide
2. Ctrl-Shift-( & it will unhide the row
(Ctrl-Shift-) & it will unhide the column)
Excel - How To Unhide A Specific Row - Episode 2561b
https://www.youtube.com/watch?v=wQUwpdDw7g8
#excel #mrexcel #tips #microsoft
Argh!!!
Classic #Microsoft fail move. Exporting an #Excel spreadsheet to CSV (for further processing later via Python scripts), I've found a niggling `\ufeff` character leading it off, which has bombed my pipelines. It looks like this zero-width, non-breaking space is used as a BOM (byte order mark) by Excel (though explicitly exporting to UTF-8).
Unfortunately the Unicode spec clearly discourages this strongly:
> The serialized order of the bytes must not depart from the order defined by the UTF-8 encoding form. Use of a BOM is neither required nor recommended for UTF-8
Why does this evil empire have to make everything unnecessarily difficult???
Attn Lawyers & Legal Assistants. Continuously updated guides for Legal Professionals are also available by subscription for Word, Excel, PowerPoint, Outlook & a special ed. for Word for Macintosh.
Original post: https://bsky.app/profile/did:plc:gwp6j2luj75mdlqd7enhl6xw/post/3luaztbvrvj2f
#legal #office #word #Excel #powerpoint #outlook #Microsoft
♬ 
CSV Dateien waren bei mir mit 
