Excel for auditors:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Uniontown, Ohio
Holy Macro Books
©2007
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Beschreibung: | Includes index Find audit red flags using techniques in Microsoft Excel. From pivot tables to formula auditing, learn the essential Excel skills for analyzing mounds of data. Learn important concepts as well as tips to make your use of Excel far more efficient. Covers Excel 97-2003 and shows off the new features in Excel 2007 Copying a worksheet -- Showing numbers in thousands -- Quickly seeing sum or average -- Adding subtotals -- Quickly filling a series -- Using a fixed value in your formula -- Replacing a thousand formulas with one -- Highlighting outliers -- Turning your data on its side with transpose -- Joining text -- Looking up data -- Sorting your data -- Dealing with dates -- Analyzing data with pivot tables -- Analyzing results by date -- Creating a random sample from a dataset -- Finding and analyzing records using AutoFilter -- Formula auditing -- Matching two lists -- Finding duplicates or unique values -- Finding missing dates in data -- Automating Excel with VBA -- Conclusion -- Index |
| Beschreibung: | 1 Online-Ressource (vi, b, 212 pages) |
| ISBN: | 9781932802634 1932802630 9781615473113 1615473114 1932802169 9781932802160 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043159436 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2007 |||| o||u| ||||||eng d | ||
| 020 | |a 9781932802634 |c electronic bk. |9 978-1-932802-63-4 | ||
| 020 | |a 1932802630 |c electronic bk. |9 1-932802-63-0 | ||
| 020 | |a 9781615473113 |c electronic bk. |9 978-1-61547-311-3 | ||
| 020 | |a 1615473114 |c electronic bk. |9 1-61547-311-4 | ||
| 020 | |a 1932802169 |9 1-932802-16-9 | ||
| 020 | |a 9781932802160 |9 978-1-932802-16-0 | ||
| 035 | |a (OCoLC)729252845 | ||
| 035 | |a (DE-599)BVBBV043159436 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 082 | 0 | |a 005.54 |2 22 | |
| 100 | 1 | |a Jelen, Bill |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Excel for auditors |c by Bill Jelen and Dwayne K. Dowell |
| 264 | 1 | |a Uniontown, Ohio |b Holy Macro Books |c ©2007 | |
| 300 | |a 1 Online-Ressource (vi, b, 212 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 500 | |a Find audit red flags using techniques in Microsoft Excel. From pivot tables to formula auditing, learn the essential Excel skills for analyzing mounds of data. Learn important concepts as well as tips to make your use of Excel far more efficient. Covers Excel 97-2003 and shows off the new features in Excel 2007 | ||
| 500 | |a Copying a worksheet -- Showing numbers in thousands -- Quickly seeing sum or average -- Adding subtotals -- Quickly filling a series -- Using a fixed value in your formula -- Replacing a thousand formulas with one -- Highlighting outliers -- Turning your data on its side with transpose -- Joining text -- Looking up data -- Sorting your data -- Dealing with dates -- Analyzing data with pivot tables -- Analyzing results by date -- Creating a random sample from a dataset -- Finding and analyzing records using AutoFilter -- Formula auditing -- Matching two lists -- Finding duplicates or unique values -- Finding missing dates in data -- Automating Excel with VBA -- Conclusion -- Index | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 7 | |a COMPUTERS / Desktop Applications / Spreadsheets |2 bisacsh | |
| 650 | 7 | |a Microsoft Excel (Computer file) |2 fast | |
| 650 | 7 | |a Auditing |2 fast | |
| 650 | 4 | |a Auditing |v Handbooks, manuals, etc | |
| 700 | 1 | |a Dowell, Dwayne K. |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=235109 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028583627 | ||
Datensatz im Suchindex
| _version_ | 1804175628216303616 |
|---|---|
| any_adam_object | |
| author | Jelen, Bill |
| author_facet | Jelen, Bill |
| author_role | aut |
| author_sort | Jelen, Bill |
| author_variant | b j bj |
| building | Verbundindex |
| bvnumber | BV043159436 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)729252845 (DE-599)BVBBV043159436 |
| 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 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02563nmm a2200445zc 4500</leader><controlfield tag="001">BV043159436</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2007 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781932802634</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-932802-63-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1932802630</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-932802-63-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615473113</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-61547-311-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1615473114</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-61547-311-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1932802169</subfield><subfield code="9">1-932802-16-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781932802160</subfield><subfield code="9">978-1-932802-16-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)729252845</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043159436</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Jelen, Bill</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel for auditors</subfield><subfield code="c">by Bill Jelen and Dwayne K. Dowell</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Uniontown, Ohio</subfield><subfield code="b">Holy Macro Books</subfield><subfield code="c">©2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (vi, b, 212 pages)</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">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Find audit red flags using techniques in Microsoft Excel. From pivot tables to formula auditing, learn the essential Excel skills for analyzing mounds of data. Learn important concepts as well as tips to make your use of Excel far more efficient. Covers Excel 97-2003 and shows off the new features in Excel 2007</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Copying a worksheet -- Showing numbers in thousands -- Quickly seeing sum or average -- Adding subtotals -- Quickly filling a series -- Using a fixed value in your formula -- Replacing a thousand formulas with one -- Highlighting outliers -- Turning your data on its side with transpose -- Joining text -- Looking up data -- Sorting your data -- Dealing with dates -- Analyzing data with pivot tables -- Analyzing results by date -- Creating a random sample from a dataset -- Finding and analyzing records using AutoFilter -- Formula auditing -- Matching two lists -- Finding duplicates or unique values -- Finding missing dates in data -- Automating Excel with VBA -- Conclusion -- Index</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Desktop Applications / Spreadsheets</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Auditing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Auditing</subfield><subfield code="v">Handbooks, manuals, etc</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Dowell, Dwayne K.</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=235109</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028583627</subfield></datafield></record></collection> |
| id | DE-604.BV043159436 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:19:18Z |
| institution | BVB |
| isbn | 9781932802634 1932802630 9781615473113 1615473114 1932802169 9781932802160 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028583627 |
| oclc_num | 729252845 |
| open_access_boolean | |
| physical | 1 Online-Ressource (vi, b, 212 pages) |
| psigel | ZDB-4-EBA |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Holy Macro Books |
| record_format | marc |
| spelling | Jelen, Bill Verfasser aut Excel for auditors by Bill Jelen and Dwayne K. Dowell Uniontown, Ohio Holy Macro Books ©2007 1 Online-Ressource (vi, b, 212 pages) txt rdacontent c rdamedia cr rdacarrier Includes index Find audit red flags using techniques in Microsoft Excel. From pivot tables to formula auditing, learn the essential Excel skills for analyzing mounds of data. Learn important concepts as well as tips to make your use of Excel far more efficient. Covers Excel 97-2003 and shows off the new features in Excel 2007 Copying a worksheet -- Showing numbers in thousands -- Quickly seeing sum or average -- Adding subtotals -- Quickly filling a series -- Using a fixed value in your formula -- Replacing a thousand formulas with one -- Highlighting outliers -- Turning your data on its side with transpose -- Joining text -- Looking up data -- Sorting your data -- Dealing with dates -- Analyzing data with pivot tables -- Analyzing results by date -- Creating a random sample from a dataset -- Finding and analyzing records using AutoFilter -- Formula auditing -- Matching two lists -- Finding duplicates or unique values -- Finding missing dates in data -- Automating Excel with VBA -- Conclusion -- Index Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Microsoft Excel (Computer file) fast Auditing fast Auditing Handbooks, manuals, etc Dowell, Dwayne K. Sonstige oth http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=235109 Aggregator Volltext |
| spellingShingle | Jelen, Bill Excel for auditors Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Microsoft Excel (Computer file) fast Auditing fast Auditing Handbooks, manuals, etc |
| title | Excel for auditors |
| title_auth | Excel for auditors |
| title_exact_search | Excel for auditors |
| title_full | Excel for auditors by Bill Jelen and Dwayne K. Dowell |
| title_fullStr | Excel for auditors by Bill Jelen and Dwayne K. Dowell |
| title_full_unstemmed | Excel for auditors by Bill Jelen and Dwayne K. Dowell |
| title_short | Excel for auditors |
| title_sort | excel for auditors |
| topic | Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Microsoft Excel (Computer file) fast Auditing fast Auditing Handbooks, manuals, etc |
| topic_facet | Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets Auditing Auditing Handbooks, manuals, etc |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=235109 |
| work_keys_str_mv | AT jelenbill excelforauditors AT dowelldwaynek excelforauditors |