Stop using SUMIF in Excel
In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a favourite for many, we're here to introduce you to a more powerful alternative - the SUMIFS (plural!) function. The SUMIFS function not only replicates the capabiliti...
Gespeichert in:
| Körperschaft: | |
|---|---|
| Format: | Elektronisch Video |
| Sprache: | English |
| Veröffentlicht: |
[Place of publication not identified]
Assemble You
2024
|
| Ausgabe: | [First edition]. |
| Schlagworte: | |
| Online-Zugang: | lizenzpflichtig |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
MARC
| LEADER | 00000ngm a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-102208115 | ||
| 003 | DE-627-1 | ||
| 005 | 20240404083424.0 | ||
| 006 | m o | | | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 240404s2024 xx ||| |o o ||eng c | ||
| 035 | |a (DE-627-1)102208115 | ||
| 035 | |a (DE-599)KEP102208115 | ||
| 035 | |a (ORHE)2000009AYMSTIKTOK | ||
| 035 | |a (DE-627-1)102208115 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.54 |2 23/eng/20240320 | |
| 245 | 1 | 0 | |a Stop using SUMIF in Excel |
| 250 | |a [First edition]. | ||
| 264 | 1 | |a [Place of publication not identified] |b Assemble You |c 2024 | |
| 300 | |a 1 online resource (1 video file (4 min.)) |b sound, color. | ||
| 336 | |a zweidimensionales bewegtes Bild |b tdi |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Online resource; title from title details screen (O'Reilly, viewed March 20, 2024) | ||
| 520 | |a In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a favourite for many, we're here to introduce you to a more powerful alternative - the SUMIFS (plural!) function. The SUMIFS function not only replicates the capabilities of SUMIF but takes it a step further by accommodating multiple criteria seamlessly. No longer bound by the limitations of SUMIF, SUMIFS empowers you to handle complex conditions. Join us as we showcase how SUMIFS can efficiently replace SUMIF in both single and multiple-criterion scenarios. Embrace the efficiency, simplicity, and versatility of SUMIFS to revolutionise the way you approach data analysis. | ||
| 630 | 2 | 0 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs | |
| 650 | 0 | |a Business |x Computer programs | |
| 650 | 4 | |a Instructional films | |
| 650 | 4 | |a Nonfiction films | |
| 650 | 4 | |a Internet videos | |
| 710 | 2 | |a Assemble You Limited, |e MitwirkendeR |4 ctb | |
| 856 | 4 | 0 | |l TUM01 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/2000009AYMSTIKTOK/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 935 | |c vide | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-102208115 |
|---|---|
| _version_ | 1818767371450449920 |
| adam_text | |
| any_adam_object | |
| author_corporate | Assemble You Limited |
| author_corporate_role | ctb |
| author_facet | Assemble You Limited |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)102208115 (DE-599)KEP102208115 (ORHE)2000009AYMSTIKTOK |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | [First edition]. |
| format | Electronic Video |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02154ngm a22004212 4500</leader><controlfield tag="001">ZDB-30-ORH-102208115</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240404083424.0</controlfield><controlfield tag="006">m o | | </controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">240404s2024 xx ||| |o o ||eng c</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)102208115</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP102208115</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)2000009AYMSTIKTOK</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)102208115</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">23/eng/20240320</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Stop using SUMIF in Excel</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">[First edition].</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Place of publication not identified]</subfield><subfield code="b">Assemble You</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 video file (4 min.))</subfield><subfield code="b">sound, color.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">zweidimensionales bewegtes Bild</subfield><subfield code="b">tdi</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Online resource; title from title details screen (O'Reilly, viewed March 20, 2024)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a favourite for many, we're here to introduce you to a more powerful alternative - the SUMIFS (plural!) function. The SUMIFS function not only replicates the capabilities of SUMIF but takes it a step further by accommodating multiple criteria seamlessly. No longer bound by the limitations of SUMIF, SUMIFS empowers you to handle complex conditions. Join us as we showcase how SUMIFS can efficiently replace SUMIF in both single and multiple-criterion scenarios. Embrace the efficiency, simplicity, and versatility of SUMIFS to revolutionise the way you approach data analysis.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Electronic spreadsheets</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Instructional films</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Nonfiction films</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Internet videos</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Assemble You Limited,</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">TUM01</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/2000009AYMSTIKTOK/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="935" ind1=" " ind2=" "><subfield code="c">vide</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-102208115 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-18T08:48:49Z |
| institution | BVB |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 online resource (1 video file (4 min.)) sound, color. |
| psigel | ZDB-30-ORH |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Assemble You |
| record_format | marc |
| spelling | Stop using SUMIF in Excel [First edition]. [Place of publication not identified] Assemble You 2024 1 online resource (1 video file (4 min.)) sound, color. zweidimensionales bewegtes Bild tdi rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Online resource; title from title details screen (O'Reilly, viewed March 20, 2024) In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a favourite for many, we're here to introduce you to a more powerful alternative - the SUMIFS (plural!) function. The SUMIFS function not only replicates the capabilities of SUMIF but takes it a step further by accommodating multiple criteria seamlessly. No longer bound by the limitations of SUMIF, SUMIFS empowers you to handle complex conditions. Join us as we showcase how SUMIFS can efficiently replace SUMIF in both single and multiple-criterion scenarios. Embrace the efficiency, simplicity, and versatility of SUMIFS to revolutionise the way you approach data analysis. Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs Instructional films Nonfiction films Internet videos Assemble You Limited, MitwirkendeR ctb TUM01 ZDB-30-ORH TUM_PDA_ORH https://learning.oreilly.com/library/view/-/2000009AYMSTIKTOK/?ar X:ORHE Aggregator lizenzpflichtig Volltext |
| spellingShingle | Stop using SUMIF in Excel Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs Instructional films Nonfiction films Internet videos |
| title | Stop using SUMIF in Excel |
| title_auth | Stop using SUMIF in Excel |
| title_exact_search | Stop using SUMIF in Excel |
| title_full | Stop using SUMIF in Excel |
| title_fullStr | Stop using SUMIF in Excel |
| title_full_unstemmed | Stop using SUMIF in Excel |
| title_short | Stop using SUMIF in Excel |
| title_sort | stop using sumif in excel |
| topic | Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs Instructional films Nonfiction films Internet videos |
| topic_facet | Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs Instructional films Nonfiction films Internet videos |
| url | https://learning.oreilly.com/library/view/-/2000009AYMSTIKTOK/?ar |
| work_keys_str_mv | AT assembleyoulimited stopusingsumifinexcel |