{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Verketten","Datenschnitt","Übung","Wiederholung ","Wechseln","Makro"],"not_rendered":{"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Verketten","index":0,"n_rows":13,"n_cols":9,"rows_kept":13}
[]
[null,"Umsatz","Abteilung","Monat","Vorname","Nachname","Teilnehmernamen","Emailadresse","Abteilung"]
[null,{"v":1200,"d":"1,200.00 €"},5,"Januar","Marcus","Wagner",{"$f":"CONCATENATE(E3,\" \",F3)","v":"Marcus Wagner"},{"$f":"CONCATENATE(E3,\".\",F3,\"@web.de\")","v":"Marcus.Wagner@web.de"},{"$f":"CONCATENATE(E3,\" ist in Abteilung \",C3)","v":"Marcus ist in Abteilung 5"}]
[null,{"v":2470,"d":"2,470.00 €"},6,"Februar","Lisa","Maier"]
[null,{"v":1600,"d":"1,600.00 €"},5,"März","Peter","Karlson"]
[null,{"v":500,"d":"500.00 €"},6,"April","Jörg","Schmitz"]
[null,{"v":900,"d":"900.00 €"},7,"Mai","Heidi","Hendrick"]
[null,{"v":800,"d":"800.00 €"},8,"Juni","Achmet","Hansen"]
[null,{"v":450,"d":"450.00 €"},9,"Juli","Sonja","Aurich"]
[null,{"v":250,"d":"250.00 €"},1,"August","Bernd","Conrad"]
[null,{"v":690,"d":"690.00 €"},8,"September","Markus","Kroeker"]
[null,{"v":370,"d":"370.00 €"},5,"Oktober","Hansi","Hensel"]
[null,{"v":2000,"d":"2,000.00 €"},6,"November","Klaus","Konrad"]

{"sheet":"Datenschnitt","index":1,"n_rows":12,"n_cols":5,"rows_kept":12}
["Umsatz","Abteilung","Monat","Vorname","Nachname"]
[{"v":1200,"d":"1,200.00 €"},5,"Januar","Marcus","Wagner"]
[{"v":2470,"d":"2,470.00 €"},6,"Februar","Lisa","Maier"]
[{"v":1600,"d":"1,600.00 €"},5,"März","Peter","Karlson"]
[{"v":500,"d":"500.00 €"},6,"April","Jörg","Schmitz"]
[{"v":900,"d":"900.00 €"},7,"Mai","Heidi","Hendrick"]
[{"v":800,"d":"800.00 €"},8,"Juni","Achmet","Hansen"]
[{"v":450,"d":"450.00 €"},9,"Juli","Sonja","Aurich"]
[{"v":250,"d":"250.00 €"},1,"August","Bernd","Conrad"]
[{"v":690,"d":"690.00 €"},8,"September","Markus","Kroeker"]
[{"v":370,"d":"370.00 €"},5,"Oktober","Hansi","Hensel"]
[{"v":2000,"d":"2,000.00 €"},6,"November","Klaus","Konrad"]

{"sheet":"Übung","index":2,"n_rows":61,"n_cols":8,"rows_kept":61}
["Stadt","Abteilung","Status",null,null,"1. Die Vorbereitung"]
["Berlin","IT","Aktiv"]
["Hamburg","Marketing","Inaktiv"]
["Berlin","Marketing","Aktiv"]
["München","IT","Aktiv",null,null,"Stadt","Abteilung","Status"]
[{"$nulls":5},"Berlin","IT","Aktiv"]
[{"$nulls":5},"Hamburg","Marketing","Inaktiv"]
[{"$nulls":5},"Berlin","Marketing","Aktiv"]
[{"$nulls":5},"München","IT","Aktiv"]
[]
[]
[{"$nulls":5},"2. Schritt 1: Die \"Magische Verwandlung\""]
[]
[{"$nulls":5},"Damit der Datenschnitt funktioniert, müssen wir Excel sagen: \"Das hier ist zusammenhängender Datensatz\"."]
[]
[{"$nulls":5},"1. Klicke irgendwo in deine Daten (z. B. auf \"Berlin\")."]
[]
[{"$nulls":5},"2. Drücke die Tastenkombination Strg + T (T wie Tabelle)."]
[]
[{"$nulls":5},"3. Ein kleines Fenster erscheint (\"Tabelle erstellen\"). Achte darauf, dass das Häkchen bei \"Tabelle hat Überschriften\" gesetzt ist."]
[]
[{"$nulls":5},"4. Bestätige mit OK."]
[]
[]
[{"$nulls":5},"Ergebnis: Deine Daten haben jetzt automatisch blaue Streifen und Filterpfeile bekommen."]
[]
[]
[]
[{"$nulls":5},"3. Schritt 2: Die Fernbedienung (Datenschnitt) hinzufügen"]
[]
[{"$nulls":5},"Jetzt, wo Excel die Liste als Tabelle erkennt, schalten wir die Profi-Steuerung ein:"]
[]
[{"$nulls":5},"1. Klicke irgendwo in deine neue blau-weiße Tabelle."]
[]
[{"$nulls":5},"2. Oben im Menüband erscheint ein neuer Reiter namens Tabellenentwurf (ganz rechts). Klicke darauf."]
[]
[{"$nulls":5},"3. Klicke in der Mitte des Menüs auf Datenschnitt einfügen."]
[]
[{"$nulls":5},"4. Ein Fenster öffnet sich. Setze ein Häkchen bei Stadt und Abteilung."]
[]
[{"$nulls":5},"5. Bestätige mit OK."]
[]
[]
[]
[{"$nulls":5},"4. Schritt 3: Die Bedienung"]
[]
[{"$nulls":5},"Du hast nun zwei schwebende Fenster (Slicer) auf deinem Blatt."]
[]
[{"$nulls":5},"Einfach-Auswahl: Klicke im Slicer \"Stadt\" auf Berlin. Die Tabelle zeigt sofort nur noch Berlin an."]
[]
[{"$nulls":5},"Mehrfach-Auswahl: Halte die Strg-Taste gedrückt und klicke auf München. Jetzt siehst du beide Städte."]
[]
[{"$nulls":5},"Filter löschen: Klicke auf das kleine Trichter-Symbol mit dem roten X in der oberen Ecke des Slicers."]
[]
[{"$nulls":5},"Warum ist das besser als die normalen Filterpfeile?"]
[]
[{"$nulls":5},"Sichtbarkeit: Du siehst auf einen Blick, was gerade gefiltert ist, ohne in jedes Menü klicken zu müssen."]
[]
[{"$nulls":5},"Präsentation: Es sieht in Berichten oder Dashboards extrem professionell aus."]
[]
[{"$nulls":5},"Touch-Friendly: Es lässt sich auch auf Tablets super bedienen."]

{"sheet":"Wiederholung ","index":3,"n_rows":35,"n_cols":10,"rows_kept":35,"merged":[[5,1,5,2]]}
[]
[]
[{"$nulls":3},"Filter über das Menü > Start > Bearbeiten>Sortieren und Filtern>Filtern"]
["Abteilung 7","Umsatz Sonja",null,"Umsatz","Abteilung","Monat","Vorname","Nachname","Umsatz nach Abteilung"]
[{"$f":"SUMIFS(D5:D15,E5:E15,7,G5:G15,\"Heidi\")","v":{"v":900,"d":"900.00 €"}},{"$f":"SUMIF(H5:H15,\"Lisa\",D5:D15)","v":{"v":2300,"d":"2,300.00 €"}},null,{"v":2850,"d":"2,850.00 €"},5,"Januar","Marcus","Wagner",{"$f":"IF(D5>2000,E5, \"\")","v":5},"´=WENN(D5>2000;E5; \"\")"]
["´=SUMMEWENNS(D5:D15;E5:E15;7;G5:G15;\"Heidi\")","´=SUMMEWENN(H5:H15;\"Lisa\";D5:D15)",null,{"v":2470,"d":"2,470.00 €"},6,"Februar","Lisa","Maier",{"$f":"IF(D6>2000,E6, \"\")","v":6}]
[{"$nulls":3},{"v":1600,"d":"1,600.00 €"},5,"März","Peter","Karlson",""]
[{"$nulls":3},{"v":500,"d":"500.00 €"},6,"April","Jörg","Schmitz",""]
[{"$nulls":3},{"v":900,"d":"900.00 €"},7,"Mai","Heidi","Hendrick",""]
[{"$nulls":3},{"v":2900,"d":"2,900.00 €"},8,"Juni","Achmet","Hansen",8]
[{"$nulls":3},{"v":450,"d":"450.00 €"},9,"Juli","Sonja","Aurich",""]
[{"$nulls":3},{"v":250,"d":"250.00 €"},1,"August","Bernd","Conrad",""]
[{"$nulls":3},{"v":690,"d":"690.00 €"},8,"September","Markus","Kroeker",""]
[{"$nulls":3},{"v":370,"d":"370.00 €"},5,"Oktober","Hansi","Hensel",""]
[{"$nulls":3},{"v":2300,"d":"2,300.00 €"},6,"November","Klaus","Lisa",6]
[{"$nulls":3},{"$f":"SUM(D5:D15)","v":{"v":15280,"d":"15,280.00 €"}}]
[{"$nulls":3},"´=SUMME(D5:D15)",{"$nulls":3},"Anzahl Teilnehmer",{"$f":"COUNTA(H5:H15)","v":11},"´=ANZAHL2(H5:H15)"]
[{"$nulls":7},"Anzahl Zahlen in Zellen",{"$f":"COUNT(I5:I15)","v":4},"´=ANZAHL(I5:I15)"]
[]
[{"$nulls":3},"Vollständiger Name"]
[null,"´=VERKETTEN(G5;\" \";H5)",null,{"$f":"CONCATENATE(G5,\" \",H5)","v":"Marcus Wagner"}]
[{"$nulls":3},{"$f":"CONCATENATE(G6,\" \",H6)","v":"Lisa Maier"}]
[{"$nulls":3},"Peter Karlson"]
[{"$nulls":3},"Jörg Schmitz"]
[{"$nulls":3},"Heidi Hendrick"]
[{"$nulls":3},"Achmet Hansen"]
[{"$nulls":3},"Sonja Aurich"]
[{"$nulls":3},"Bernd Conrad"]
[{"$nulls":3},"Markus Kroeker"]
[{"$nulls":3},"Hansi Hensel"]
[{"$nulls":3},"Klaus Lisa"]
[]
[]
[]
[{"$nulls":3}," "]

{"sheet":"Wechseln","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[28,7,28,8],[29,7,29,8],[30,7,30,8]]}
["Rohdaten ","Typ","Wunschformat"]
["089-123-456","Telefon",89123456,{"$nulls":3},"Die Formel lautet: =WECHSELN(Text; Alter_Text; Neuer_Text)"]
["Art.Nr. 5.112","Code","ArtNr 5112"]
["0221-543-767","IBAN-Rest","DE8810020",{"$nulls":3},"Text: Wo steht das Problem? (z.B. A2)"]
[]
[{"$nulls":6},"Alter_Text: Was soll weg? (Muss in Anführungszeichen, z.B. \"-\")"]
[]
[{"$nulls":6},"Neuer_Text: Was soll stattdessen hin? (Wenn es gelöscht werden soll, nutzt man zwei Anführungszeichen ohne Inhalt: \"\")"]
["Rohdaten ","Typ","Wunschformat"]
[{"$f":"SUBSTITUTE(A2,\"-\",\"\")","v":"089123456"},{"$nulls":5},"Aufgabe A: Bindestriche entfernen"]
[]
[{"$nulls":6},"Entferne bei der Telefonnummer (A2) alle Bindestriche."]
[]
[{"$nulls":6},"Formel: =WECHSELN(A2; \"-\"; \"\")"]
[]
[{"$nulls":6},"Ergebnis: 089123456"]
[]
["´=WECHSELN(A2;\"-\";\"\")",{"$nulls":5},"Aufgabe B: Punkte entfernen"]
[]
[{"$nulls":6},"Entferne bei der IBAN (A4) alle Punkte."]
[]
[{"$nulls":6},"Formel: =WECHSELN(A4; \".\"; \"\")"]
[]
[{"$nulls":6},"Ergebnis: DE8810020"]
[]
[{"$nulls":6},"Die Lösungen im Überblick"]
[]
[{"$nulls":6},"Ziel","Formel-Vorschlag"]
[{"$nulls":6},"Ohne Bindestrich","´=WECHSELN(A2; \"-\"; \"\")"]
[{"$nulls":6},"Ohne Punkt","´=WECHSELN(A4; \".\"; \"\")"]
[{"$nulls":6},"Ohne Punkt & Leerzeichen","´=WECHSELN(WECHSELN(A3; \".\"; \"\"); \" \"; \"\")"]

{"sheet":"Makro","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[3,9,5,10]]}
["Umsatz","Abteilung","Monat","Vorname","Nachname"]
[1200,5,"Januar","Marcus","Wagner"]
[2470,6,"Februar","Lisa","Maier"]
[1600,5,"März","Peter","Karlson"]
[500,6,"April","Jörg","Schmitz"]
[900,7,"Mai","Heidi","Hendrick"]
[800,8,"Juni","Achmet","Hansen"]
[450,9,"Juli","Sonja","Aurich"]
[250,1,"August","Bernd","Conrad"]
[690,8,"September","Markus","Kroeker"]
[370,5,"Oktober","Hansi","Hensel"]
[2000,6,"November","Klaus","Konrad"]