top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.

Biblioteca

MARC Lista (tabellare)
Excel 2007 data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Excel 2007 data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Autore Etheridge Denise
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, N.J., : Wiley, c2007
Descrizione fisica 1 online resource (305 p.)
Disciplina 005.54
Collana Read less-learn more
Soggetto topico Business - Computer software
Spreadsheet software
Soggetto genere / forma Electronic books.
ISBN 1-281-23789-2
9786611237899
0-470-37749-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and Pivot Tables; Credits; About the Author; Author's Acknowledgments; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Chapter 1: Getting Started; Introduction to Data Analysis with Excel; Understanding the Excel Window; Enter Data; Format Numbers; Format Cells; Select Data; Copy, Cut, and Paste Cells; Copy with the Office Clipboard; Insert and Delete Cells; Find and Replace; Find and Replace Formats; Chapter 2: Creating Formulas; Understanding Formulas; Create Formulas; Edit Formulas; Name Cells and Ranges
Define and Display Constants Create Formulas that Include Names; Check Formulas for Errors; Trace Precedents and Dependents; Chapter 3: Creating and Using Functions; Understanding the Function Wizard; Round a Number; Determine the Nth Largest Value; Create a Conditional Formula; Calculate a Conditional Sum; Calculate Products and Square Roots; Look Up Information; Determine the Location of a Value; Perform Time Calculations; Perform Date Calculations; Chapter 4: 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; Chapter 5: Using Statistical Functions and Tools; Calculate an Average; Calculate the Median or the Mode; Calculate Rank; 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 Chapter 6: Organizing Worksheet Data; Enter Data with a Form; Filter Duplicate Records; Perform Simple Sorts and Filters; Perform Complex Sorts; Sort by Cell Color, Font Color, or Icon; Perform Complex Filters; Enter Criteria to Find Records; Filter by Multiple Criteria; Subtotal Sorted Data; Count Filtered Records; Define Data as a Table; Modify a Table Style; Chapter 7: Working with PivotTables; Create a PivotTable; Modify PivotTable Data and Layout; Compute Subtotals and Grand Totals; Create a Pivot Table Calculated Field; Hide Rows or Columns in a PivotTable
Sort a PivotTable Retrieve Values from a PivotTable; Chapter 8: Charting Data; Create a Chart; Add Chart Details; Change the Chart Type; Add a Trendline; Add and Remove Chart Data; Add Error Bars; Create a Histogram; Chart Filtered Data; Create a PivotChart; Create a Combination Chart; Chapter 9: 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; Chapter 10: Useful Data Analysis Tools and Techniques; Perform What-If Analysis; Optimize a Result with Goal Seek
Solve a Formula with a Data Table
Record Nr. UNINA-9910451195003321
Etheridge Denise  
Hoboken, N.J., : Wiley, c2007
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel 2007 data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Excel 2007 data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Autore Etheridge Denise
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, N.J., : Wiley, c2007
Descrizione fisica 1 online resource (305 p.)
Disciplina 005.54
Collana Read less-learn more
Soggetto topico Business - Computer software
Spreadsheet software
ISBN 1-118-07940-X
1-281-23789-2
9786611237899
0-470-37749-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and Pivot Tables; Credits; About the Author; Author's Acknowledgments; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Chapter 1: Getting Started; Introduction to Data Analysis with Excel; Understanding the Excel Window; Enter Data; Format Numbers; Format Cells; Select Data; Copy, Cut, and Paste Cells; Copy with the Office Clipboard; Insert and Delete Cells; Find and Replace; Find and Replace Formats; Chapter 2: Creating Formulas; Understanding Formulas; Create Formulas; Edit Formulas; Name Cells and Ranges
Define and Display Constants Create Formulas that Include Names; Check Formulas for Errors; Trace Precedents and Dependents; Chapter 3: Creating and Using Functions; Understanding the Function Wizard; Round a Number; Determine the Nth Largest Value; Create a Conditional Formula; Calculate a Conditional Sum; Calculate Products and Square Roots; Look Up Information; Determine the Location of a Value; Perform Time Calculations; Perform Date Calculations; Chapter 4: 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; Chapter 5: Using Statistical Functions and Tools; Calculate an Average; Calculate the Median or the Mode; Calculate Rank; 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 Chapter 6: Organizing Worksheet Data; Enter Data with a Form; Filter Duplicate Records; Perform Simple Sorts and Filters; Perform Complex Sorts; Sort by Cell Color, Font Color, or Icon; Perform Complex Filters; Enter Criteria to Find Records; Filter by Multiple Criteria; Subtotal Sorted Data; Count Filtered Records; Define Data as a Table; Modify a Table Style; Chapter 7: Working with PivotTables; Create a PivotTable; Modify PivotTable Data and Layout; Compute Subtotals and Grand Totals; Create a Pivot Table Calculated Field; Hide Rows or Columns in a PivotTable
Sort a PivotTable Retrieve Values from a PivotTable; Chapter 8: Charting Data; Create a Chart; Add Chart Details; Change the Chart Type; Add a Trendline; Add and Remove Chart Data; Add Error Bars; Create a Histogram; Chart Filtered Data; Create a PivotChart; Create a Combination Chart; Chapter 9: 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; Chapter 10: Useful Data Analysis Tools and Techniques; Perform What-If Analysis; Optimize a Result with Goal Seek
Solve a Formula with a Data Table
Record Nr. UNINA-9910784707803321
Etheridge Denise  
Hoboken, N.J., : Wiley, c2007
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel 2007 data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Excel 2007 data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Autore Etheridge Denise
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, N.J., : Wiley, c2007
Descrizione fisica 1 online resource (305 p.)
Disciplina 005.54
Collana Read less-learn more
Soggetto topico Business - Computer software
Spreadsheet software
ISBN 1-118-07940-X
1-281-23789-2
9786611237899
0-470-37749-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and Pivot Tables; Credits; About the Author; Author's Acknowledgments; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Chapter 1: Getting Started; Introduction to Data Analysis with Excel; Understanding the Excel Window; Enter Data; Format Numbers; Format Cells; Select Data; Copy, Cut, and Paste Cells; Copy with the Office Clipboard; Insert and Delete Cells; Find and Replace; Find and Replace Formats; Chapter 2: Creating Formulas; Understanding Formulas; Create Formulas; Edit Formulas; Name Cells and Ranges
Define and Display Constants Create Formulas that Include Names; Check Formulas for Errors; Trace Precedents and Dependents; Chapter 3: Creating and Using Functions; Understanding the Function Wizard; Round a Number; Determine the Nth Largest Value; Create a Conditional Formula; Calculate a Conditional Sum; Calculate Products and Square Roots; Look Up Information; Determine the Location of a Value; Perform Time Calculations; Perform Date Calculations; Chapter 4: 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; Chapter 5: Using Statistical Functions and Tools; Calculate an Average; Calculate the Median or the Mode; Calculate Rank; 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 Chapter 6: Organizing Worksheet Data; Enter Data with a Form; Filter Duplicate Records; Perform Simple Sorts and Filters; Perform Complex Sorts; Sort by Cell Color, Font Color, or Icon; Perform Complex Filters; Enter Criteria to Find Records; Filter by Multiple Criteria; Subtotal Sorted Data; Count Filtered Records; Define Data as a Table; Modify a Table Style; Chapter 7: Working with PivotTables; Create a PivotTable; Modify PivotTable Data and Layout; Compute Subtotals and Grand Totals; Create a Pivot Table Calculated Field; Hide Rows or Columns in a PivotTable
Sort a PivotTable Retrieve Values from a PivotTable; Chapter 8: Charting Data; Create a Chart; Add Chart Details; Change the Chart Type; Add a Trendline; Add and Remove Chart Data; Add Error Bars; Create a Histogram; Chart Filtered Data; Create a PivotChart; Create a Combination Chart; Chapter 9: 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; Chapter 10: Useful Data Analysis Tools and Techniques; Perform What-If Analysis; Optimize a Result with Goal Seek
Solve a Formula with a Data Table
Record Nr. UNINA-9910824828403321
Etheridge Denise  
Hoboken, N.J., : Wiley, c2007
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel 2007 top 100 simplified tips & tricks [[electronic resource] /] / Denise Etheridge
Excel 2007 top 100 simplified tips & tricks [[electronic resource] /] / Denise Etheridge
Autore Etheridge Denise
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, NJ, : Wiley Pub.
Descrizione fisica 1 online resource (258 p.)
Disciplina 005.54
Collana Visual read less, learn more
Top 100 simplified tips & tricks
Soggetto topico Electronic spreadsheets - Computer programs
Business - Computer programs
Soggetto genere / forma Electronic books.
ISBN 1-118-07895-0
1-281-23788-4
9786611237882
0-470-37748-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel 2007 Top 100 Simplified Tips & Tricks; Table of Contents; Chapter 1 Boost Your Efficiency; Validate with a VALIDATION LIST; Validate with DATA ENTRY RULES; Extend a series with AUTOFILL; Insert SYMBOLS OR SPECIAL CHARACTERS; Hide rows by GROUPING AND OUTLINING; FIND AND REPLACE formats; ADD COMMENTS to your worksheet; Let Excel READ BACK YOUR DATA; Create your own SORT OR AUTOFILL; Chapter 2 Work with Formulas and Functions; ENTER FORMULAS using a variety of methods; Name CELLS AND RANGES; Define a CONSTANT; CREATE FORMULAS that include names; Calculate with THE FUNCTION WIZARD
Figure out LOAN TERMS Determine the INTERNAL RATE OF RETURN; Determine the NTH LARGEST VALUE; Create a CONDITIONAL FORMULA; Calculate a CONDITIONAL SUM; Add a CALCULATOR; Find PRODUCTS AND SQUARE ROOTS; Perform TIME CALCULATIONS; Perform DATE CALCULATIONS; Chapter 3 Copy, Format, and More; CHECK YOUR FORMULAS for errors; TRACE precedents and dependents; Change TEXT TO NUMBERS; CONVERT A ROW to a column; Copy with the OFFICE CLIPBOARD; Adjust column widths with PASTE SPECIAL; Specify how to paste with PASTE SPECIAL; Create your own STYLE; COPY STYLES to another workbook
Conditionally FORMAT YOUR WORKSHEET TRACK CHANGES while editing; CONSOLIDATE worksheets; Chapter 4 Manipulate Records; ENTER DATA with a form; Filter DUPLICATE RECORDS; Perform simple SORTS AND FILTERS; Perform COMPLEX SORTS; SORT by cell color, font color, or icon; Perform COMPLEX FILTERS; Filter by MULTIPLE CRITERIA; SUBTOTAL sorted data; CHART FILTERED DATA easily; COUNT filtered records; LOOK UP INFORMATION in your worksheet; DEFINE DATA as a table; Modify a TABLE STYLE; Chapter 5 Explore the Patterns inYour Data; Create a PIVOTTABLE; Modify PIVOTTABLE DATA AND LAYOUT
Compute Pivot Table SUB AND GRAND TOTALS Create a PivotTable CALCULATED FIELD; HIDE ROWS OR COLUMNS in a PivotTable; SORT a PivotTable; Create a PIVOTCHART; DESCRIBE DATA with statistics; FIND THE CORRELATION between variables; Explore outcomes with WHAT-IF ANALYSIS; Optimize a result with GOAL SEEK; Chapter 6 Create Charts; CREATE A CHART that has visual appeal; Add CHART DETAILS; Change the CHART TYPE; Add a TRENDLINE; Add and remove CHART DATA; Add ERRORS BARS; Create a HISTOGRAM; Create a COMBINATION CHART; Chapter 7 Present Worksheets; FORMAT numbers, dates, and times
APPLY FORMATS to cells Fill with a GRADIENT; Format quickly with FORMAT PAINTER; INSERT SHAPES into your worksheet; INSERT TEXT BOXES into your worksheet; INSERT PHOTOGRAPHS into your worksheet; ARRANGE THE GRAPHICS in your worksheet; Insert a BACKGROUND IMAGE; TAKE A PICTURE of your worksheet; Chapter 8 Protect, Save, and Print; PROTECT your worksheet; Save a workbook as A TEMPLATE; CHOOSE A FORMAT when saving a workbook; PRINT MULTIPLE AREAS of a workbook; PRINT MULTIPLE WORKSHEETS from a workbook; Chapter 9 Extend Excel; PASTE LINK into Word or PowerPoint; EMBED a worksheet
CREATE A LINK from an Excel workbook
Record Nr. UNINA-9910450674903321
Etheridge Denise  
Hoboken, NJ, : Wiley Pub.
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel 2007 top 100 simplified tips & tricks [[electronic resource] /] / Denise Etheridge
Excel 2007 top 100 simplified tips & tricks [[electronic resource] /] / Denise Etheridge
Autore Etheridge Denise
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, NJ, : Wiley Pub.
Descrizione fisica 1 online resource (258 p.)
Disciplina 005.54
Collana Visual read less, learn more
Top 100 simplified tips & tricks
Soggetto topico Electronic spreadsheets - Computer programs
Business - Computer programs
ISBN 1-118-07895-0
1-281-23788-4
9786611237882
0-470-37748-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel 2007 Top 100 Simplified Tips & Tricks; Table of Contents; Chapter 1 Boost Your Efficiency; Validate with a VALIDATION LIST; Validate with DATA ENTRY RULES; Extend a series with AUTOFILL; Insert SYMBOLS OR SPECIAL CHARACTERS; Hide rows by GROUPING AND OUTLINING; FIND AND REPLACE formats; ADD COMMENTS to your worksheet; Let Excel READ BACK YOUR DATA; Create your own SORT OR AUTOFILL; Chapter 2 Work with Formulas and Functions; ENTER FORMULAS using a variety of methods; Name CELLS AND RANGES; Define a CONSTANT; CREATE FORMULAS that include names; Calculate with THE FUNCTION WIZARD
Figure out LOAN TERMS Determine the INTERNAL RATE OF RETURN; Determine the NTH LARGEST VALUE; Create a CONDITIONAL FORMULA; Calculate a CONDITIONAL SUM; Add a CALCULATOR; Find PRODUCTS AND SQUARE ROOTS; Perform TIME CALCULATIONS; Perform DATE CALCULATIONS; Chapter 3 Copy, Format, and More; CHECK YOUR FORMULAS for errors; TRACE precedents and dependents; Change TEXT TO NUMBERS; CONVERT A ROW to a column; Copy with the OFFICE CLIPBOARD; Adjust column widths with PASTE SPECIAL; Specify how to paste with PASTE SPECIAL; Create your own STYLE; COPY STYLES to another workbook
Conditionally FORMAT YOUR WORKSHEET TRACK CHANGES while editing; CONSOLIDATE worksheets; Chapter 4 Manipulate Records; ENTER DATA with a form; Filter DUPLICATE RECORDS; Perform simple SORTS AND FILTERS; Perform COMPLEX SORTS; SORT by cell color, font color, or icon; Perform COMPLEX FILTERS; Filter by MULTIPLE CRITERIA; SUBTOTAL sorted data; CHART FILTERED DATA easily; COUNT filtered records; LOOK UP INFORMATION in your worksheet; DEFINE DATA as a table; Modify a TABLE STYLE; Chapter 5 Explore the Patterns inYour Data; Create a PIVOTTABLE; Modify PIVOTTABLE DATA AND LAYOUT
Compute Pivot Table SUB AND GRAND TOTALS Create a PivotTable CALCULATED FIELD; HIDE ROWS OR COLUMNS in a PivotTable; SORT a PivotTable; Create a PIVOTCHART; DESCRIBE DATA with statistics; FIND THE CORRELATION between variables; Explore outcomes with WHAT-IF ANALYSIS; Optimize a result with GOAL SEEK; Chapter 6 Create Charts; CREATE A CHART that has visual appeal; Add CHART DETAILS; Change the CHART TYPE; Add a TRENDLINE; Add and remove CHART DATA; Add ERRORS BARS; Create a HISTOGRAM; Create a COMBINATION CHART; Chapter 7 Present Worksheets; FORMAT numbers, dates, and times
APPLY FORMATS to cells Fill with a GRADIENT; Format quickly with FORMAT PAINTER; INSERT SHAPES into your worksheet; INSERT TEXT BOXES into your worksheet; INSERT PHOTOGRAPHS into your worksheet; ARRANGE THE GRAPHICS in your worksheet; Insert a BACKGROUND IMAGE; TAKE A PICTURE of your worksheet; Chapter 8 Protect, Save, and Print; PROTECT your worksheet; Save a workbook as A TEMPLATE; CHOOSE A FORMAT when saving a workbook; PRINT MULTIPLE AREAS of a workbook; PRINT MULTIPLE WORKSHEETS from a workbook; Chapter 9 Extend Excel; PASTE LINK into Word or PowerPoint; EMBED a worksheet
CREATE A LINK from an Excel workbook
Record Nr. UNINA-9910777307603321
Etheridge Denise  
Hoboken, NJ, : Wiley Pub.
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel 2007 top 100 simplified tips & tricks [[electronic resource] /] / Denise Etheridge
Excel 2007 top 100 simplified tips & tricks [[electronic resource] /] / Denise Etheridge
Autore Etheridge Denise
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, NJ, : Wiley Pub.
Descrizione fisica 1 online resource (258 p.)
Disciplina 005.54
Collana Visual read less, learn more
Top 100 simplified tips & tricks
Soggetto topico Electronic spreadsheets - Computer programs
Business - Computer programs
ISBN 1-118-07895-0
1-281-23788-4
9786611237882
0-470-37748-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel 2007 Top 100 Simplified Tips & Tricks; Table of Contents; Chapter 1 Boost Your Efficiency; Validate with a VALIDATION LIST; Validate with DATA ENTRY RULES; Extend a series with AUTOFILL; Insert SYMBOLS OR SPECIAL CHARACTERS; Hide rows by GROUPING AND OUTLINING; FIND AND REPLACE formats; ADD COMMENTS to your worksheet; Let Excel READ BACK YOUR DATA; Create your own SORT OR AUTOFILL; Chapter 2 Work with Formulas and Functions; ENTER FORMULAS using a variety of methods; Name CELLS AND RANGES; Define a CONSTANT; CREATE FORMULAS that include names; Calculate with THE FUNCTION WIZARD
Figure out LOAN TERMS Determine the INTERNAL RATE OF RETURN; Determine the NTH LARGEST VALUE; Create a CONDITIONAL FORMULA; Calculate a CONDITIONAL SUM; Add a CALCULATOR; Find PRODUCTS AND SQUARE ROOTS; Perform TIME CALCULATIONS; Perform DATE CALCULATIONS; Chapter 3 Copy, Format, and More; CHECK YOUR FORMULAS for errors; TRACE precedents and dependents; Change TEXT TO NUMBERS; CONVERT A ROW to a column; Copy with the OFFICE CLIPBOARD; Adjust column widths with PASTE SPECIAL; Specify how to paste with PASTE SPECIAL; Create your own STYLE; COPY STYLES to another workbook
Conditionally FORMAT YOUR WORKSHEET TRACK CHANGES while editing; CONSOLIDATE worksheets; Chapter 4 Manipulate Records; ENTER DATA with a form; Filter DUPLICATE RECORDS; Perform simple SORTS AND FILTERS; Perform COMPLEX SORTS; SORT by cell color, font color, or icon; Perform COMPLEX FILTERS; Filter by MULTIPLE CRITERIA; SUBTOTAL sorted data; CHART FILTERED DATA easily; COUNT filtered records; LOOK UP INFORMATION in your worksheet; DEFINE DATA as a table; Modify a TABLE STYLE; Chapter 5 Explore the Patterns inYour Data; Create a PIVOTTABLE; Modify PIVOTTABLE DATA AND LAYOUT
Compute Pivot Table SUB AND GRAND TOTALS Create a PivotTable CALCULATED FIELD; HIDE ROWS OR COLUMNS in a PivotTable; SORT a PivotTable; Create a PIVOTCHART; DESCRIBE DATA with statistics; FIND THE CORRELATION between variables; Explore outcomes with WHAT-IF ANALYSIS; Optimize a result with GOAL SEEK; Chapter 6 Create Charts; CREATE A CHART that has visual appeal; Add CHART DETAILS; Change the CHART TYPE; Add a TRENDLINE; Add and remove CHART DATA; Add ERRORS BARS; Create a HISTOGRAM; Create a COMBINATION CHART; Chapter 7 Present Worksheets; FORMAT numbers, dates, and times
APPLY FORMATS to cells Fill with a GRADIENT; Format quickly with FORMAT PAINTER; INSERT SHAPES into your worksheet; INSERT TEXT BOXES into your worksheet; INSERT PHOTOGRAPHS into your worksheet; ARRANGE THE GRAPHICS in your worksheet; Insert a BACKGROUND IMAGE; TAKE A PICTURE of your worksheet; Chapter 8 Protect, Save, and Print; PROTECT your worksheet; Save a workbook as A TEMPLATE; CHOOSE A FORMAT when saving a workbook; PRINT MULTIPLE AREAS of a workbook; PRINT MULTIPLE WORKSHEETS from a workbook; Chapter 9 Extend Excel; PASTE LINK into Word or PowerPoint; EMBED a worksheet
CREATE A LINK from an Excel workbook
Record Nr. UNINA-9910821673503321
Etheridge Denise  
Hoboken, NJ, : Wiley Pub.
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
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
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel data analysis [[electronic resource] ] : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
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
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables / / by Denise Etheridge
Excel data analysis : 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-9910841253303321
Etheridge Denise  
Indianapolis, Ind., : Wiley, 2010
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui