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

Bibliographic Details
Main Author: Etheridge, Denise
Other Authors: Simon, Jinjer L.
Format: eBook
Language:English
Published: Indianapolis, Ind. Wiley 2010
Edition:3rd ed
Series:Visual read less, learn more
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 05146nmm a2200649 u 4500
001 EB001920333
003 EBX01000000000000001083235
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781118036235 
020 |a 1118036239 
020 |a 1118983939 
020 |a 162198432X 
020 |a 1282685074 
020 |a 9786612685071 
020 |a 6612685077 
020 |a 0470901721 
020 |a 9781621984320 
020 |a 9781118983935 
020 |a 9780470901724 
050 4 |a HF5548.4.M523 
100 1 |a Etheridge, Denise 
245 0 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 xii, 352 pages  |b illustrations 
505 0 |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 
505 0 |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 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 0 |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 0 |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 
653 |a Electronic spreadsheets / Computer programs / fast 
653 |a Microsoft Excel (Computer file) / blmlsh 
653 |a Electronic spreadsheets / Computer programs / blmlsh 
653 |a Microsoft Excel (Computer file) / fast 
653 |a COMPUTERS / Desktop Applications / Spreadsheets / bisacsh 
653 |a Tableurs / Logiciels 
653 |a Electronic spreadsheets / Computer programs / http://id.loc.gov/authorities/subjects/sh86007613 
653 |a Microsoft Excel (Computer file) / http://id.loc.gov/authorities/names/n86025775 
700 1 |a Simon, Jinjer L. 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a Visual read less, learn more 
776 |z 9780470901724 
776 |z 9781118036235 
776 |z 9780470591604 
776 |z 9781621984320 
776 |z 0470591609 
776 |z 1118983939 
776 |z 1118036239 
776 |z 162198432X 
776 |z 9781118983935 
776 |z 0470901721 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780470591604/?ar  |x Verlag  |3 Volltext 
082 0 |a 005.54 
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