skip to content
Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables Preview this item
ClosePreview this item
Checking...

Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables

Author: Denise Etheridge; Jinjer L Simon
Publisher: Indianapolis, Ind. : Wiley, ©2010.
Series: Visual blueprint.; Visual read less, learn more.
Edition/Format:   eBook : Document : English : 3rd edView all editions and formats
Database:WorldCat
Summary:
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.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Excel data analysis.
Indianapolis, Ind. : Wiley, ©2010
(OCoLC)619115095
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Denise Etheridge; Jinjer L Simon
ISBN: 9781118983935 1118983939 9780470901724 0470901721 9781621984320 162198432X 9781118036235 1118036239
OCLC Number: 679603009
Description: 1 online resource (xii, 352 pages) : illustrations.
Contents: HOW TO USE THIS BOOK. 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. 2 FORMATTING A WORKSHEET. Using the Ribbon to Format Numbers. Using the Format Cells Dialog Box. Understanding Dates and Times. Format 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. 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. Hide Columns or Rows. Hide a Worksheet. Move or Copy a Worksheet. Freeze Worksheet Titles. Hide Gridlines, Headings, or the Formula Bar. 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. Trace Precedents and Dependents. 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. 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. Calculate Straight-Line Depreciation. Calculate Declining Balance Depreciation. Calculate Double-Declining Balance Depreciation. Calculate Sum-of-the-Years-Digits Depreciation. 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. Calculate Descriptive Statistics. 8 ORGANIZING WORKSHEET DATA. Enter Data with a Form. Perform Simple Sorts and Filters. Perform Multilevel Sorts. Perform a Custom Sort. Sort by Cell Color, Font Color, or Cell Icon. Perform Complex Filters. Enter Criteria to Find Records. Using Advanced Filtering Techniques. Filter Duplicate Records. Count Filtered Records. Subtotal Records. Using Auto Outline. Define Data as a Table. Modify a Table Style. Using Database Functions with a Table. 9 WORKING WITH PIVOTTABLES. Create a PivotTable. Modify a PivotTable Layout. Summarize PivotTable Values. Create a PivotTable Calculated Field. Group the Rows or Columns in a PivotTable. Apply a Style to a PivotTable. Filter a PivotTable. Sort a PivotTable. Retrieve Values from a PivotTable. Using Slicer. 10 CHARTING DATA. Create a Chart. Add Chart Details. Create a Combination Chart. Change the Chart Type. Add or Remove Chart Data. Add Sparklines. Create a Trendline. Add Error Bars. Create a Histogram. Chart Filtered Data. Create a PivotChart. Filter a PivotChart. 11 WORKING WITH EXTERNAL DATA. Paste Link into Word. Embed a Worksheet. Hyperlink a Worksheet. Query a Web Site. Import a Text File. Import an Access Database. Query an Access Database. 12 USING DATA ANALYSIS TOOLS AND TECHNIQUES. Perform What-If Analysis. Optimize a Result with Goal Seek. Using Solver. Solve a Formula with a Data Table. Extend a Series with Auto Fill. Join Text. Add a Calculator. Consolidate Worksheets. Highlight Cells that Meet Your Criteria. Find the Highest or Lowest Ranked Values. Add Data Bars to Your Worksheet. Add Icon Sets to Your Worksheet. Remove Conditional Formatting. Change Conditional Formatting Rules. Paste with Paste Special. 13 SHARING YOUR WORKBOOK WITH OTHERS. Validate with a Validation List. Validate with Data Entry Rules. Add Comments to Your Worksheet. Track Changes. Protect Your Worksheet. Save Your Workbook as a Template. Choose a Format When Saving a Workbook. Print Your Workbook. Print Multiple Areas of Your Worksheet. 14 AUTOMATING WITH MACROS. Introducing Macros. Set Macro Security. Create a Digital Signature. Record a Macro. Assign a Digital Signature to a Macro. Run a Macro. Create and Launch a Keyboard Shortcut. Assign a Macro to the Quick Access Toolbar. Delete a Macro. 15 ILLUSTRATING YOUR WORKSHEETS. Place a Screenshot in Your Worksheet. Insert Clip Art into Your Worksheet. Crop a Clip Art Illustration or a Photograph. Insert a Picture into Your Worksheet. Recolor a Picture. Adjust the Sharpness, Brightness, and Contrast. Compress a Picture. Add a Border. Add a Picture Effect. Apply a Picture Style. Add an Artistic Effect. Remove a Background. 16 ILLUSTRATING YOUR IDEAS. Insert a Text Box. Format a Text Box. Insert a Shape. Add Text to a Shape. Change the Size of an Object. Rotate an Object. Change the Stacking Order. Group Objects. Align Objects. Insert a Symbol. Using SmartArt Graphics. Modify a SmartArt Graphic. Apply a SmartArt Style. Apply a SmartArt Layout. 17 CUSTOMIZING EXCEL. Add a Form Control to a Worksheet. Assign Values to a Form Control. Add a Macro to a Form Control. Customize the Quick Access Toolbar. Customize the Ribbon. APPENDIX A: USING EXCEL KEYBOARD SHORTCUTS. Using Excel Keyboard Shortcuts. INDEX.
Series Title: Visual blueprint.; Visual read less, learn more.
Responsibility: by Denise Etheridge.
More information:

Abstract:

Advanced techniques for Excel power users Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques.  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/679603009> # Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
   library:oclcnum "679603009" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/794744118#Place/indianapolis_ind> ; # Indianapolis, Ind.
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
   rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/0128-1/{2CB712AF-B108-4E7A-A219-8E52AEF8E714}Img100.jpg'" ;
   rdfs:seeAlso <http://experiment.worldcat.org/entity/work/data/794744118#CreativeWork/excel_data_analysis> ; # Excel data analysis.
   schema:about <http://dewey.info/class/005.54/> ;
   schema:about <http://id.worldcat.org/fast/907465> ; # Electronic spreadsheets--Computer programs
   schema:about <http://id.loc.gov/authorities/subjects/sh86007613> ; # Electronic spreadsheets--Computer programs
   schema:about <http://experiment.worldcat.org/entity/work/data/794744118#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
   schema:about <http://experiment.worldcat.org/entity/work/data/794744118#Topic/computers_desktop_applications_spreadsheets> ; # COMPUTERS--Desktop Applications--Spreadsheets
   schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
   schema:about <http://experiment.worldcat.org/entity/work/data/794744118#Topic/electronic_spreadsheets_computer_programs> ; # Electronic spreadsheets / Computer programs
   schema:bookEdition "3rd ed." ;
   schema:bookFormat schema:EBook ;
   schema:contributor <http://viaf.org/viaf/39598043> ; # Jinjer L. Simon
   schema:copyrightYear "2010" ;
   schema:creator <http://viaf.org/viaf/76631715> ; # Denise Etheridge
   schema:datePublished "2010" ;
   schema: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."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/794744118> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/794744118#Series/visual_read_less_learn_more> ; # Visual read less, learn more.
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/794744118#Series/visual_blueprint> ; # Visual blueprint.
   schema:isSimilarTo <http://www.worldcat.org/oclc/619115095> ;
   schema:name "Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables"@en ;
   schema:productID "679603009" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/679603009#PublicationEvent/indianapolis_ind_wiley_2010> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/794744118#Agent/wiley> ; # Wiley
   schema:url "http://images.contentreserve.com/ImageType-100/0128-1/{2CB712AF-B108-4E7A-A219-8E52AEF8E714}Img100.jpg" ;
   schema:url <http://proquest.safaribooksonline.com/?fpi=9780470591604> ;
   schema:url <https://samples.overdrive.com/excel-data-analysis-2cb712?.epub-sample.overdrive.com> ;
   schema:url <http://proquest.safaribooksonline.com/9780470591604> ;
   schema:url <http://proquest.tech.safaribooksonline.de/9780470591604> ;
   schema:url <http://proquest.safaribooksonline.com/640> ;
   schema:url <https://www.overdrive.com/search?q=2CB712AF-B108-4E7A-A219-8E52AEF8E714> ;
   schema:url <http://onlinelibrary.wiley.com/book/10.1002/9781118983935> ;
   schema:url <http://swbplus.bsz-bw.de/bsz35541791xcov.htm> ;
   schema:url <http://ebookcentral.proquest.com/lib/oldscollege/detail.action?docID=540089> ;
   schema:url <http://dx.doi.org/10.1002/9781118983935> ;
   schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=330183> ;
   schema:url <http://catalogimages.wiley.com/images/db/jimages/9780470591604.jpg> ;
   schema:url <http://iclibezp1.cc.ic.ac.uk/login?url=http://onlinelibrary.wiley.com/book/10.1002/9781118983935> ;
   schema:url <http://ebookcentral.proquest.com/lib/norquest-ebooks/detail.action?docID=540089> ;
   schema:url <http://public.eblib.com/EBLPublic/PublicView.do?ptiID=540089> ;
   schema:url <http://site.ebrary.com/id/10394855> ;
   schema:url <http://app.knovel.com/web/toc.v/cid:kpEDAYVBC2> ;
   schema:workExample <http://worldcat.org/isbn/9781621984320> ;
   schema:workExample <http://worldcat.org/isbn/9781118036235> ;
   schema:workExample <http://worldcat.org/isbn/9780470901724> ;
   schema:workExample <http://worldcat.org/isbn/9781118983935> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/679603009> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/794744118#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/794744118#Place/indianapolis_ind> # Indianapolis, Ind.
    a schema:Place ;
   schema:name "Indianapolis, Ind." ;
    .

<http://experiment.worldcat.org/entity/work/data/794744118#Series/visual_blueprint> # Visual blueprint.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/679603009> ; # Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
   schema:name "Visual blueprint." ;
   schema:name "Visual blueprint" ;
    .

<http://experiment.worldcat.org/entity/work/data/794744118#Series/visual_read_less_learn_more> # Visual read less, learn more.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/679603009> ; # Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
   schema:name "Visual read less, learn more." ;
   schema:name "Visual read less, learn more" ;
    .

<http://experiment.worldcat.org/entity/work/data/794744118#Topic/computers_desktop_applications_spreadsheets> # COMPUTERS--Desktop Applications--Spreadsheets
    a schema:Intangible ;
   schema:name "COMPUTERS--Desktop Applications--Spreadsheets"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/794744118#Topic/electronic_spreadsheets_computer_programs> # Electronic spreadsheets / Computer programs
    a schema:Intangible ;
   schema:name "Electronic spreadsheets / Computer programs"@en ;
   schema:name "Electronic spreadsheets--Computer programs"@en ;
    .

<http://id.loc.gov/authorities/subjects/sh86007613> # Electronic spreadsheets--Computer programs
    a schema:Intangible ;
   schema:name "Electronic spreadsheets--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.worldcat.org/fast/907465> # Electronic spreadsheets--Computer programs
    a schema:Intangible ;
   schema:name "Electronic spreadsheets--Computer programs"@en ;
    .

<http://onlinelibrary.wiley.com/book/10.1002/9781118983935>
   rdfs:comment "URL des Erstveröffentlichers" ;
    .

<http://viaf.org/viaf/39598043> # Jinjer L. Simon
    a schema:Person ;
   schema:birthDate "1966" ;
   schema:familyName "Simon" ;
   schema:givenName "Jinjer L." ;
   schema:name "Jinjer L. Simon" ;
    .

<http://viaf.org/viaf/76631715> # Denise Etheridge
    a schema:Person ;
   schema:familyName "Etheridge" ;
   schema:givenName "Denise" ;
   schema:name "Denise Etheridge" ;
    .

<http://worldcat.org/isbn/9780470901724>
    a schema:ProductModel ;
   schema:isbn "0470901721" ;
   schema:isbn "9780470901724" ;
    .

<http://worldcat.org/isbn/9781118036235>
    a schema:ProductModel ;
   schema:isbn "1118036239" ;
   schema:isbn "9781118036235" ;
    .

<http://worldcat.org/isbn/9781118983935>
    a schema:ProductModel ;
   schema:isbn "1118983939" ;
   schema:isbn "9781118983935" ;
    .

<http://worldcat.org/isbn/9781621984320>
    a schema:ProductModel ;
   schema:isbn "162198432X" ;
   schema:isbn "9781621984320" ;
    .

<http://www.worldcat.org/oclc/619115095>
    a schema:CreativeWork ;
   rdfs:label "Excel data analysis." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/679603009> ; # Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
    .

<http://www.worldcat.org/title/-/oclc/679603009>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
   schema:about <http://www.worldcat.org/oclc/679603009> ; # Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
   schema:dateModified "2017-09-02" ;
   void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.