Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
(eBook)
Author
Contributors
Published
Indianapolis, Ind. : Wiley, ©2010.
Format
eBook
Edition
3rd ed.
ISBN
0470901721, 1118036239, 1118983939, 1282685074, 162198432X, 6612685077, 9780470901724, 9781118036235, 9781118983935, 9781282685079, 9781621984320, 9786612685071
Physical Desc
1 online resource (xii, 352 pages) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
Subjects
OCLC Fast Subjects
Other Subjects
More Details
Language
English
Notes
Description
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.
Language
English.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Etheridge, D., & Simon, J. L. (2010). Excel data analysis: your visual blueprint for creating and analyzing data, charts and PivotTables (3rd ed.). Wiley.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Etheridge, Denise and Jinjer L. Simon. 2010. Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables. Wiley.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Etheridge, Denise and Jinjer L. Simon. Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables Wiley, 2010.
MLA Citation, 9th Edition (style guide)Etheridge, Denise., and Jinjer L. Simon. Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables 3rd ed., Wiley, 2010.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
bf4a0575-b492-440c-c8d9-33537c8e30e0-eng
Grouping Information
| Grouped Work ID | bf4a0575-b492-440c-c8d9-33537c8e30e0-eng |
|---|---|
| Full title | excel data analysis your visual blueprint for creating and analyzing data charts and pivottables |
| Author | etheridge denise |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-14 04:00:11AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Sep 18, 2024 |
| Last Used | Sep 18, 2024 |
Marc Record
| First Detected | Jul 29, 2024 03:58:00 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:33:58 PM |
MARC Record
| LEADER | 06465cam a2200709 a 4500 | ||
|---|---|---|---|
| 001 | ocn679603009 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 101108s2010 inua o 001 0 eng d | ||
| 010 | |a 2011285202 | ||
| 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 0470901721|q (electronic bk.) | ||
| 020 | |a 1118036239|q (electronic bk.) | ||
| 020 | |a 1118983939|q (electronic bk.) | ||
| 020 | |a 1282685074 | ||
| 020 | |a 162198432X|q (electronic bk.) | ||
| 020 | |a 6612685077 | ||
| 020 | |a 9780470901724|q (electronic bk.) | ||
| 020 | |a 9781118036235|q (electronic bk.) | ||
| 020 | |a 9781118983935|q (electronic bk.) | ||
| 020 | |a 9781282685079 | ||
| 020 | |a 9781621984320|q (electronic bk.) | ||
| 020 | |a 9786612685071 | ||
| 020 | |z 0470591609|q (pbk.) | ||
| 020 | |z 9780470591604|q (pbk.) | ||
| 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 2CB712AF-B108-4E7A-A219-8E52AEF8E714|b OverDrive, Inc.|n http://www.overdrive.com | ||
| 037 | |a CL0500000077|b Safari Books Online | ||
| 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|d OCLCO|d OCLCQ|d OCLCL | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a HF5548.4.M523 | |
| 082 | 0 | 4 | |a 005.54 |
| 100 | 1 | |a Etheridge, Denise.|0 http://id.loc.gov/authorities/names/n2002019597 | |
| 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 | |
| 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 | |
| 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. | ||
| 546 | |a English. | ||
| 588 | 0 | |a Print version record. | |
| 630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast |
| 650 | 0 | |a Electronic spreadsheets|x Computer programs.|0 http://id.loc.gov/authorities/subjects/sh86007613 | |
| 700 | 1 | |a Simon, Jinjer L.,|d 1966-|t Excel data analysis. | |
| 758 | |i has work:|a Excel data analysis (Text)|1 https://id.oclc.org/worldcat/entity/E39PCGGwQtfhrYRPyfbYpb87gX|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 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.|0 http://id.loc.gov/authorities/names/no2008034422 | |
| 830 | 0 | |a Visual read less, learn more.|0 http://id.loc.gov/authorities/names/n2001005165 | |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |