Ein zentraler Baustein bei der Umstrukturierung von Tabellen ist die TRANSPOSE-Funktion. Sie dient dazu, vertikale Zellbereiche in horizontale Ausrichtungen zu konvertieren und umgekehrt, wodurch die ...

Microsoft is changing a 40-year-old Excel rule by allowing a single cell to hold multiple values using new lists, arrays in cells, and nested arrays. Microsoft is testing a major Excel change that ...

Microsoft is expanding Excel with lists and arrays that hold multiple independently usable values in a single cell. Previously, the results of dynamic array formulas were distributed across adjacent ...

Wie Microsoft in seiner Ankündigung der Listen und Arrays in Excel erläutert, sollen zusammengehörige Werte in einer Zelle bleiben, ohne zu einer bloßen Zeichenfolge zu werden. So kann eine ...

Das Tabellenkalkulationsprogramm Excel ermöglicht künftig die Eingabe von mehreren Werten in einer einzelnen Zelle. "In der 40-jährigen Geschichte von Excel konnte man bisher nur einen Wert pro Zelle ...

As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ever imagined. These are the tips and tricks you need to know.

But a new study shows that work use cases make up less of the picture than AI companies claim. AI companies like Anthropic and OpenAI regularly publish reports on how people are using products like ...

Tony Phillips is an experienced Microsoft Office user with a dual-honors degree in Linguistics and Hispanic Studies. Prior to starting with How-to Geek in January 2024, he worked as a document ...

Ask a roomful of senior executives what AI can do for their business, and the answers will probably cluster around the same themes: lower costs, smaller headcount, faster processes, leaner operations.

It’s been three-and-a-half years since generative AI exploded onto the scene. In this past year, progress has continued its relentless pace: Vibe coding took off, companies embraced agentic workflows, ...

Dynamic arrays have brought significant flexibility to Excel, allowing formulas to automatically expand or contract across cells. However, this functionality introduces a common issue: formatting ...

Using AI chatbots for even just 10 minutes may have a shockingly negative impact on people’s ability to think and problem-solve, according to a new study from researchers at Carnegie Mellon, MIT, ...