@teezeh Auf jeden Fall ist das etwas, wo mich der Microsoft 365 #Copilot auf ein höheres Level bringt.

#PivotTable #Excel

I have always had a soft spot for Pivot Tables. And recently discovered that LibreOffice supports Pivot Tables too, although I'm not sure how feature complete it is. Anyone?

#LibreOffice #PivotTable #OpenSource

https://getpocket.com/explore/item/the-history-of-the-pivot-table-the-spreadsheet-s-most-powerful-tool?utm_source=firefox-newtab-en-us

Nice (hi)story about pivot tables, and why they will 'never die'. https://www.rilldata.com/blog/why-pivot-tables-never-die#the-origin-story

#pivottable #excel #spreadsheet

Looker connected sheets triples pivot table row limit to 100,000 rows: Major update to Looker Connected Sheets increases pivot table row limit from 30,000 to 100,000 rows for enhanced data analysis. https://ppc.land/looker-connected-sheets-triples-pivot-table-row-limit-to-100-000-rows/?utm_source=dlvr.it&utm_medium=mastodon #Looker #DataAnalysis #PivotTable #ConnectedSheets #DataVisualization

Looking at the Data Cube Ontology. See: . #LinkedData #SmartData #BigData #SpreadSheet #PivotTable #SemanticWeb

Create interactive excel dashboard in 5 simple steps #exceldashboard #exceltutorial #pivottable

In this video we will set up an amazing dashboard in microsoft excel from scratch. We will learn lots of concepts in this video. source

https://quadexcel.com/wp/create-interactive-excel-dashboard-in-5-simple-steps-exceldashboard-exceltutorial-pivottable/

How to Create Pivot Table in Microsoft Excel | Pivot Table in Excel

In this video we will learn to use Pivot Table in Microsoft Excel step by step #pivot_table_in_excel #pivot #pivottables #pivottable ... source

https://quadexcel.com/wp/how-to-create-pivot-table-in-microsoft-excel-pivot-table-in-excel/

August 6

This day in history:

• 1926 – First public screening using the Vitaphone process
• 1958 – Law of Permanent Defense of Democracy, outlawing the Communist Party of Chile and banning 26,650 persons from the electoral lists, is repealed in Chile.
• 1986 – A low-pressure system that redeveloped off the New South Wales coast dumps a record 328 millimeters (13 inches) of rain in a day on Sydney, New South Wales, Australia.
• 1942 – Queen Wilhelmina of the Netherlands becomes the first reigning queen to address a joint session of the United States Congress.

Births:

• 1960 – Dale Ellis, American basketball player
• 1946 – Allan Holdsworth, English guitarist, songwriter, and producer (d. 2017)
• 1923 – Paul Hellyer, Canadian engineer and politician, 16th Canadian Minister of Defence (d. 2021)

Deaths:

• 2005 – Creme Puff, tabby domestic cat, oldest recorded cat (b. 1967)
• 2001 – Wilhelm Mohnke, German general (b. 1911)
• 1946 – Tony Lazzeri, American baseball player and coach (b. 1903)

Holidays:

• Hiroshima Peace Memorial Ceremony (Hiroshima, Japan)
• Independence Day (Bolivia), celebrates the independence of Bolivia from Spain in 1825.
• Sheikh Zayed bin Sultan Al Nahyan's Accession Day. (United Arab Emirates)

Random Article of the day:

Pivot table

A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table (such as from a database, spreadsheet, or business intelligence program) within one or more discrete categories. The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics. A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.
Although pivot table is a generic term, Microsoft held a trademark on the term in the United States from 1994 to 2020.

Pandas Melt Fonksiyonuyla Verilerinizi Yeniden Şekillendirin.

Bu yazı ile, Pandas'ın melt() fonksiyonunun nasıl kullanacağını öğreneceğiz.

https://m-halil.medium.com/pandas%C4%B1n-melt-fonksiyonuyla-verilerinizi-yeniden-%C5%9Fekillendirin-cd07074cd418

#python #pandas #melt #programming #reshape #pivot #pivottable

Snack zu meiner Morgenbrezn „Einfach und schnell #Excel-Listen auswerten und Daten analysieren"
2:47 Std., Fortgeschrittene

Vermittelte Kenntnisse u.Fähigkeiten
#Datenmanagement
#MicrosoftExcel
#StatistischeDatenanalyse

#Autofilter #Datenbalken
#Datenbank #XVerweis
#Layouttabelle #Ergebniszeile #Datenschnitt
#Pivottabelle #Pivot #PivotTable #Berichtslayout #AutomatischeDatenanalyse #Datenanalyse
#DynamischeArrays #EINDEUTIG #Array
#PowerQuery #PowerQueryEditor
https://www.linkedin.com/learning/excel-listen-auswerten-daten-analysieren?trk=share_android_course_learning&shareId=XNoawPJaQf2tMWMzN19Nzw%3D%3D

The May issue has been released! This month we look at the D-Bus architecture, which creates a powerful channel for applications to communicate. Order your copy! today https://bit.ly/Linux-Magazine-catalog #Linux #OpenSource #DBus #DataManagement #SSH #LibreOffice #PivotTable #Tiger #Bash #Shell #Julia #Jellyfin #RDAP #FOSS #Zint #Clonezilla #Kubuntu

Calc - taula dinamikoa iragazkiekin sortzen

https://peertube.eus/videos/watch/0507a4e2-ac73-4463-8398-8dc500324cb7

I'm sorry, but how does one get to be a senior #engineering #manager in this day and age without knowing how to use a #PivotTable in #Excel?

Conjecture: If one uses a #PivotTable in an #OpenOffice spreadsheet, then one is unable to edit that spreadsheet file on #Android without losing the pivot table.

Contradictions and counterexamples are very welcome!

Great to see #Matlab getting those really cutting edge features in 2023 😆 /s

#PivotTable #JustUsePythonAlready