Excel data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge |
Autore | Etheridge Denise |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2010 |
Descrizione fisica | 1 online resource (371 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | SimonJinjer L. <1966-> |
Collana | Visual Blueprint |
Soggetto topico | Electronic spreadsheets - Computer programs |
ISBN |
1-118-03623-9
1-118-98393-9 1-62198-432-X 1-282-68507-4 9786612685071 0-470-90172-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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
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 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 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 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 Calculate Descriptive Statistics |
Record Nr. | UNINA-9910139202003321 |
Etheridge Denise
![]() |
||
Indianapolis, Ind., : Wiley, 2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge |
Autore | Etheridge Denise |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2010 |
Descrizione fisica | 1 online resource (371 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | SimonJinjer L. <1966-> |
Collana | Visual Blueprint |
Soggetto topico | Electronic spreadsheets - Computer programs |
ISBN |
1-118-03623-9
1-118-98393-9 1-62198-432-X 1-282-68507-4 9786612685071 0-470-90172-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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
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 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 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 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 Calculate Descriptive Statistics |
Record Nr. | UNINA-9910830980003321 |
Etheridge Denise
![]() |
||
Indianapolis, Ind., : Wiley, 2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|