Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables /
Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Otros Autores: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Indianapolis, Ind. :
Wiley,
©2010.
|
Edición: | 3rd ed. |
Colección: | Visual blueprint.
Visual read less, learn more. |
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
LEADER | 00000cam a2200000Ia 4500 | ||
---|---|---|---|
001 | OR_ocn679603009 | ||
003 | OCoLC | ||
005 | 20231017213018.0 | ||
006 | m o d | ||
007 | cr unu|||||||| | ||
008 | 101108s2010 inua o 001 0 eng d | ||
010 | |a 2011285202 | ||
040 | |a UMI |b eng |e pn |c UMI |d CEF |d E7B |d OCLCQ |d DEBSZ |d YDXCP |d OCLCQ |d N$T |d KNOVL |d C6I |d KNOVL |d OCLCF |d OCLCQ |d DG1 |d OCLCQ |d TEFOD |d OCLCQ |d DEBBG |d DG1 |d CNNOR |d Z5A |d LIP |d OCLCQ |d OCLCO |d NJR |d OCLCQ |d OCLCO |d BRL |d STF |d OCLCQ |d OCLCO |d WYU |d U3W |d UAB |d OCLCQ |d A6Q |d VT2 |d OCLCQ |d UHL |d VLY |d UKAHL |d OCLCO |d OCLCQ | ||
019 | |a 649913190 |a 712991358 |a 803455385 |a 988779331 |a 1037527374 |a 1053879389 |a 1064151668 |a 1083607450 |a 1103265306 |a 1113502581 |a 1129348413 |a 1162051676 | ||
020 | |a 9781118983935 |q (electronic bk.) | ||
020 | |a 1118983939 |q (electronic bk.) | ||
020 | |a 9780470901724 |q (electronic bk.) | ||
020 | |a 0470901721 |q (electronic bk.) | ||
020 | |a 9781621984320 |q (electronic bk.) | ||
020 | |a 162198432X |q (electronic bk.) | ||
020 | |a 9781118036235 |q (electronic bk.) | ||
020 | |a 1118036239 |q (electronic bk.) | ||
020 | |a 9786612685071 | ||
020 | |a 6612685077 | ||
020 | |z 9780470591604 |q (pbk.) | ||
020 | |z 0470591609 |q (pbk.) | ||
020 | |a 1282685074 | ||
020 | |a 9781282685079 | ||
029 | 1 | |a AU@ |b 000056814221 | |
029 | 1 | |a CHNEW |b 000936864 | |
029 | 1 | |a CHVBK |b 480171718 | |
029 | 1 | |a DEBBG |b BV043392450 | |
029 | 1 | |a DEBSZ |b 35541791X | |
029 | 1 | |a DEBSZ |b 48499543X | |
029 | 1 | |a HEBIS |b 291489842 | |
029 | 1 | |a NZ1 |b 15915344 | |
035 | |a (OCoLC)679603009 |z (OCoLC)649913190 |z (OCoLC)712991358 |z (OCoLC)803455385 |z (OCoLC)988779331 |z (OCoLC)1037527374 |z (OCoLC)1053879389 |z (OCoLC)1064151668 |z (OCoLC)1083607450 |z (OCoLC)1103265306 |z (OCoLC)1113502581 |z (OCoLC)1129348413 |z (OCoLC)1162051676 | ||
037 | |a CL0500000077 |b Safari Books Online | ||
037 | |a 2CB712AF-B108-4E7A-A219-8E52AEF8E714 |b OverDrive, Inc. |n http://www.overdrive.com | ||
050 | 4 | |a HF5548.4.M523 | |
072 | 7 | |a COM |x 054000 |2 bisacsh | |
082 | 0 | 4 | |a 005.54 |
049 | |a UAMI | ||
100 | 1 | |a Etheridge, Denise. | |
245 | 1 | 0 | |a Excel data analysis : |b your visual blueprint for creating and analyzing data, charts and PivotTables / |c by Denise Etheridge. |
250 | |a 3rd ed. | ||
260 | |a Indianapolis, Ind. : |b Wiley, |c ©2010. | ||
300 | |a 1 online resource (xii, 352 pages) : |b illustrations | ||
336 | |a text |b txt |2 rdacontent | ||
337 | |a computer |b c |2 rdamedia | ||
338 | |a online resource |b cr |2 rdacarrier | ||
490 | 1 | |a Visual read less, learn more | |
490 | 1 | |a Visual blueprint | |
588 | 0 | |a Print version record. | |
520 | |a Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros. | ||
505 | 0 | |a Excel® Data Analysis: Your visual blueprintTM for creating and analyzing data, charts, and PivotTables, 3rd Edition; TABLE OF CONTENTS; Chapter 1: Getting Started; Introducing Data Analysis with Excel; Tour the Excel Window; Explore the Ribbon; Using the Mini Toolbar and Context Menu; Select Options on the Status Bar; Take a Look at Backstage View; Upload a File to Excel's Web-based Application; Create a File Using Excel's Web-based Application; Enter Data; Select Cells; Chapter 2: Formatting a Worksheet; Using the Ribbon to Format Numbers; Using the Format Cells Dialog Box | |
505 | 8 | |a Understanding Dates and TimesFormat Percentages; Format Fractions; Format in Scientific Notation; Format as Text; Add a Border; Change the Font or Font Size; Add a Background Color; Change the Font Color; Bold, Underline, or Italicize; Align Data; Rotate Data; Wrap Text; Merge and Center; Apply a Style; Using Format Painter; Clear Formats; Chapter 3: Structuring Your Workbook; Cut, Copy, and Paste Cells; Using Live Preview with Paste; Paste from the Office Clipboard; Insert or Delete; Find and Replace Information; Change the Name of a Worksheet; Change Column Widths or Row Heights | |
505 | 8 | |a Hide Columns or RowsHide a Worksheet; Move or Copy a Worksheet; Freeze Worksheet Titles; Hide Gridlines, Headings, or the Formula Bar; Chapter 4: Creating Formulas; Understanding Formulas; Calculate with an Operator; Calculate Using a Function and Cell Addresses; Create an Array Formula; Using the Sum, Average, Count, Min, and Max Functions; Create a Formula that Refers to Another Worksheet; Understanding Relative and Absolute Cell Addresses; Edit Formulas; Name Cells and Ranges; Define and Display Constants; Create Formulas That Include Names; Check Formulas for Errors | |
505 | 8 | |a Trace Precedents and DependentsChapter 5: Using Functions; Understanding the Function Wizard; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve Column or Row Numbers; Using VLOOKUP; Determine the Location of a Value; Using INDEX; Perform Date and Time Calculations; Chapter 6: Using Financial Functions; Calculate Future Value; Calculate Present Value; Calculate Loan Payments; Calculate Principal or Interest; Calculate the Interest Rate; Calculate the Internal Rate of Return | |
505 | 8 | |a Calculate Straight-Line DepreciationCalculate Declining Balance Depreciation; Calculate Double-Declining Balance Depreciation; Calculate Sum-of-the-Years-Digits Depreciation; Chapter 7: Using Statistical Functions and Tools; Calculate an Average; Calculate a Conditional Average; Calculate the Median or the Mode; Calculate Rank; Determine the Nth Largest Value; Calculate Frequency; Calculate Variance and Standard Deviation; Find the Correlation; Install Excel Add-Ins; Calculate a Moving Average; Compare Variances; Using the Data Analysis Toolpak to Determine Rank and Percentile | |
546 | |a English. | ||
590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
630 | 0 | 0 | |a Microsoft Excel (Computer file) |
630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 blmlsh |
630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |0 (OCoLC)fst01366659 |
650 | 0 | |a Electronic spreadsheets |x Computer programs. | |
650 | 6 | |a Tableurs |x Logiciels. | |
650 | 7 | |a COMPUTERS |x Desktop Applications |x Spreadsheets. |2 bisacsh | |
650 | 7 | |a Electronic spreadsheets |x Computer programs. |2 blmlsh | |
650 | 7 | |a Electronic spreadsheets |x Computer programs. |2 fast |0 (OCoLC)fst00907465 | |
700 | 1 | |a Simon, Jinjer L., |d 1966- |t Excel data analysis. | |
776 | 0 | 8 | |i Print version: |t Excel data analysis. |d Indianapolis, Ind. : Wiley, ©2010 |z 9780470591604 |w (OCoLC)619115095 |
830 | 0 | |a Visual blueprint. | |
830 | 0 | |a Visual read less, learn more. | |
856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780470591604/?ar |z Texto completo (Requiere registro previo con correo institucional) |
938 | |a Askews and Holts Library Services |b ASKH |n AH21621944 | ||
938 | |a ebrary |b EBRY |n ebr10394855 | ||
938 | |a EBSCOhost |b EBSC |n 330183 | ||
938 | |a YBP Library Services |b YANK |n 3330859 | ||
938 | |a YBP Library Services |b YANK |n 11903881 | ||
994 | |a 92 |b IZTAP |