Cargando…

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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Etheridge, Denise
Otros Autores: Simon, Jinjer L., 1966-
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