MS Excel 2016 - Kompakt Pivot-Tabellen:
Gespeichert in:
| Körperschaft: | |
|---|---|
| Format: | Buch |
| Sprache: | German |
| Veröffentlicht: |
Brunn/Gebirge
ikon VerlagsGesmbH
September 2016
|
| Ausgabe: | September 2016 |
| Schriftenreihe: | Redmond's Kompakt Training
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Auf der Haupttitelseite : Microsoft Excel 2016 : Pivot-Tabellen inkl. PowerPivot |
| Beschreibung: | 48 Seiten Illustrationen |
| ISBN: | 9783990234488 399023448X |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV044762705 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 180216s2016 au a||| |||| 00||| ger d | ||
| 015 | |a 16,N38 |2 dnb | ||
| 015 | |a 17,A50 |2 dnb | ||
| 016 | 7 | |a 1113885084 |2 DE-101 | |
| 020 | |a 9783990234488 |c Broschur : EUR 8.90 (DE), EUR 8.90 (AT) |9 978-3-99023-448-8 | ||
| 020 | |a 399023448X |9 3-99023-448-X | ||
| 024 | 3 | |a 9783990234488 | |
| 028 | 5 | 2 | |a Bestellnummer: RE-23448 |
| 035 | |a (OCoLC)1024121931 | ||
| 035 | |a (DE-599)DNB1113885084 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a ger | |
| 044 | |a au |c XA-AT | ||
| 049 | |a DE-573 | ||
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 110 | 2 | |a Team ALGE |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a MS Excel 2016 - Kompakt Pivot-Tabellen |c Team ALGE |
| 250 | |a September 2016 | ||
| 264 | 1 | |a Brunn/Gebirge |b ikon VerlagsGesmbH |c September 2016 | |
| 300 | |a 48 Seiten |b Illustrationen | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Redmond's Kompakt Training | |
| 500 | |a Auf der Haupttitelseite : Microsoft Excel 2016 : Pivot-Tabellen inkl. PowerPivot | ||
| 650 | 0 | 7 | |a Excel 2016 |0 (DE-588)1078432899 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Pivottabelle |0 (DE-588)7758348-6 |2 gnd |9 rswk-swf |
| 653 | |a Excel 2016 | ||
| 653 | |a Pivot-Tabellen | ||
| 653 | |a PowerPivot | ||
| 689 | 0 | 0 | |a Pivottabelle |0 (DE-588)7758348-6 |D s |
| 689 | 0 | 1 | |a Excel 2016 |0 (DE-588)1078432899 |D s |
| 689 | 0 | |5 DE-604 | |
| 710 | 2 | |a ikon VerlagsGesmbH |0 (DE-588)1065864094 |4 pbl | |
| 856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030158062&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-030158062 | ||
Datensatz im Suchindex
| _version_ | 1804178284408209408 |
|---|---|
| adam_text | I
NHALT
1 PIVOT-TABELLEN 7
1.1 DAS ZIEL: BASISDATEN STRUKTURIERT
DARZUSTELLEN...............................................7
1.2 W OZU KOENNEN SIE EINE PIVOT-TABELLE
EINSETZEN?..........................................7
2 ERSTELLEN EINER PIVOT-TABELLE 9
2.1 DATEN FUER PIVOT-TABELLEN
AUFBEREITEN.............................................................9
2.2 PIVOT-T ABEL LE ERSTEL
LEN.....................................................................................10
2.2.1 DATENBEREICH AUSWAEHLEN UND PIVOT-TABELLENPOSITION FESTLEGEN
.......................
10
2.2.2 PIVOT-TABELLENFELDER
FESTLEGEN...........................................................................
11
2.2.3
BERECHNUNGSFORM..............................................................................................
12
2.2.4 DARSTELLUNGSFORMEN DER SPALTEN UND ZEILENEINTRAEGE
.........................................
13
2.3 DATENQUELLE AENDERN UND PIVOT-TABELLE AKTUALISIEREN
................................
13
2.3.1
DATENAENDERUNGEN..............................................................................................
13
2.3.2
DATENBEREICHSAENDERUNG.....................................................................................15
2.3.3 FELDER HINZUFUEGEN, LOESCHEN ODER UMGRUPPIEREN
...............................................
15
2.3.4 PIVOT-TABELLE FILTERN,
SORTIEREN...........................................................................
16
2.3.5 DATEN AUTOMATISCH ODER MANUELL
GRUPPIEREN....................................................16
2.3.6 BERECHNUNGSTYPEN IN PIVOT-TABELLEN
................................................................
21
2.3.7 BERECHNETES
FELD...............................................................................................
22
2.4 FORMATIERUNG UND
LAYOUT...............................................................................24
2.4.1 EMPFOHLENE
DARSTELLUNGSFORMEN.......................................................................24
2.4.2 VERFUEGBARE
TABELLENOPTIONEN............................................................................25
2.4.3 ZELLEN
FORMATIEREN.............................................................................................25
3 DATENSCHNITT 27
3.1 ERSTELLEN VON
DATENSCHNITTEN........................................................................
27
3.2 VERWENDEN DES
DATENSCHNITTS......................................................................28
4 V O M PIVOTTABLE ZU M PIVOTCHART 29
4.1 FORMATIERUNG DES D IAGRAM M
S......................................................................30
5 POWERPIVOT 31
5.1 INSTALLIEREN UND STARTEN VON
POWERPIVOT.....................................................31
5.2 POWERPIVOT ANSCHAUUNGSBEISPIEL
................................................................
32
6 UEBUNGEN 37
6.1 DATENVERGLEICH M IT DER PIVOT-TABELLE
...........................................................
40
6.2
GRUPPIERUNG....................................................................................................
43
6.3 PIVOT-TABELLEN FORM
ATIEREN.............................................................................45
INDEX 47
|
| any_adam_object | 1 |
| author_corporate | Team ALGE |
| author_corporate_role | aut |
| author_facet | Team ALGE |
| author_sort | Team ALGE |
| building | Verbundindex |
| bvnumber | BV044762705 |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)1024121931 (DE-599)DNB1113885084 |
| discipline | Informatik |
| edition | September 2016 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01873nam a2200517 c 4500</leader><controlfield tag="001">BV044762705</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">180216s2016 au a||| |||| 00||| ger d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">16,N38</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">17,A50</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">1113885084</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9783990234488</subfield><subfield code="c">Broschur : EUR 8.90 (DE), EUR 8.90 (AT)</subfield><subfield code="9">978-3-99023-448-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">399023448X</subfield><subfield code="9">3-99023-448-X</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9783990234488</subfield></datafield><datafield tag="028" ind1="5" ind2="2"><subfield code="a">Bestellnummer: RE-23448</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1024121931</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)DNB1113885084</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">ger</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">au</subfield><subfield code="c">XA-AT</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-573</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="110" ind1="2" ind2=" "><subfield code="a">Team ALGE</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MS Excel 2016 - Kompakt Pivot-Tabellen</subfield><subfield code="c">Team ALGE</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">September 2016</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Brunn/Gebirge</subfield><subfield code="b">ikon VerlagsGesmbH</subfield><subfield code="c">September 2016</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">48 Seiten</subfield><subfield code="b">Illustrationen</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Redmond's Kompakt Training</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Auf der Haupttitelseite : Microsoft Excel 2016 : Pivot-Tabellen inkl. PowerPivot</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2016</subfield><subfield code="0">(DE-588)1078432899</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Pivottabelle</subfield><subfield code="0">(DE-588)7758348-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Excel 2016</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Pivot-Tabellen</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">PowerPivot</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Pivottabelle</subfield><subfield code="0">(DE-588)7758348-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Excel 2016</subfield><subfield code="0">(DE-588)1078432899</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">ikon VerlagsGesmbH</subfield><subfield code="0">(DE-588)1065864094</subfield><subfield code="4">pbl</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030158062&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-030158062</subfield></datafield></record></collection> |
| id | DE-604.BV044762705 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T08:01:32Z |
| institution | BVB |
| institution_GND | (DE-588)1065864094 |
| isbn | 9783990234488 399023448X |
| language | German |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-030158062 |
| oclc_num | 1024121931 |
| open_access_boolean | |
| owner | DE-573 |
| owner_facet | DE-573 |
| physical | 48 Seiten Illustrationen |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | ikon VerlagsGesmbH |
| record_format | marc |
| series2 | Redmond's Kompakt Training |
| spelling | Team ALGE Verfasser aut MS Excel 2016 - Kompakt Pivot-Tabellen Team ALGE September 2016 Brunn/Gebirge ikon VerlagsGesmbH September 2016 48 Seiten Illustrationen txt rdacontent n rdamedia nc rdacarrier Redmond's Kompakt Training Auf der Haupttitelseite : Microsoft Excel 2016 : Pivot-Tabellen inkl. PowerPivot Excel 2016 (DE-588)1078432899 gnd rswk-swf Pivottabelle (DE-588)7758348-6 gnd rswk-swf Excel 2016 Pivot-Tabellen PowerPivot Pivottabelle (DE-588)7758348-6 s Excel 2016 (DE-588)1078432899 s DE-604 ikon VerlagsGesmbH (DE-588)1065864094 pbl DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030158062&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | MS Excel 2016 - Kompakt Pivot-Tabellen Excel 2016 (DE-588)1078432899 gnd Pivottabelle (DE-588)7758348-6 gnd |
| subject_GND | (DE-588)1078432899 (DE-588)7758348-6 |
| title | MS Excel 2016 - Kompakt Pivot-Tabellen |
| title_auth | MS Excel 2016 - Kompakt Pivot-Tabellen |
| title_exact_search | MS Excel 2016 - Kompakt Pivot-Tabellen |
| title_full | MS Excel 2016 - Kompakt Pivot-Tabellen Team ALGE |
| title_fullStr | MS Excel 2016 - Kompakt Pivot-Tabellen Team ALGE |
| title_full_unstemmed | MS Excel 2016 - Kompakt Pivot-Tabellen Team ALGE |
| title_short | MS Excel 2016 - Kompakt Pivot-Tabellen |
| title_sort | ms excel 2016 kompakt pivot tabellen |
| topic | Excel 2016 (DE-588)1078432899 gnd Pivottabelle (DE-588)7758348-6 gnd |
| topic_facet | Excel 2016 Pivottabelle |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030158062&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT teamalge msexcel2016kompaktpivottabellen AT ikonverlagsgesmbh msexcel2016kompaktpivottabellen |