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

Mostrar otras versiones (1)

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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: McFedries, Paul
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : John Wiley & Sons, ©2013.
Edición:4th ed.
Colección:Visual blueprint.
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Tableurs > Logiciels.
Industrial management > Statistical methods > Computer programs.
Decision making > Computer programs.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • About the Author; Table of Contents; Chapter 1: Building Formulas for Data Analysis; Introducing Data Analysis; Introducing Formulas; Understanding Formula Types; Build a Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; Switc h to Absolute Cell References; Create an Array Formula; Turn On Iterative Calculations; Chapter 2: Troubleshooting Formulas; Understanding Error Values in Excel; Show Formulas Instead of Results; Use a Watch Window to Monitor a Cell Value; Step Through a Formula; Display Text Instead of Error Values
  • Check for Formula Errors in a WorksheetAudit a Formula to Locate Errors; Chapter 3: Enhancing Formulas with Functions; Understanding Excel Functions; Understanding Function Types; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve a Column or Row Number; Look Up a Value; Determine the Location of a Value; Return a Cell Value with INDEX; Perform Date and Time Calculations; Chapter 4: Analyzing Financial Data
  • Calculate Future ValueCalculate Present Value; Determine the Loan Payments; Calculate the Principal or Interest; Find the Required Interest Rate; Determine the Internal Rate of Return; Calculate Straight-Line Depreciation; Return the Fixed-Declining Balance Depreciation; Determine the Double-Declining Balance Depreciation; Figure the Sum-of-the-Years-Digits Depreciation; Chapter 5: Analyzing Statistical Data; Calculate an Average; Calculate a Conditional Average; Determine the Median or the Mode; Find the Rank; Determine the Nth Largest or Smallest Value
  • Create a Grouped Frequency DistributionCalculate the Variance and Standard Deviation; Find the Correlation; Chapter 6: Building Tables for Data Analysis; Understanding Tables; Introducing Table Features; Convert a Range to a Table; Select Table Data; Insert a Table Row; Insert a Table Column; Delete a Table Row; Delete a Table Column; Add a Column Subtotal; Chapter 7: Sorting and Filtering Data; Perform a Simple Sort or Filter; Perform a Multilevel Sort; Create a Custom Sort; Sort by Cell Color, Font Color, or Cell Icon; Using Quick Filters for Complex Sorting; Enter Criteria to Find Records
  • Create an Advanced FilterDisplay Unique Records in the Filter Results; Count Filtered Records; Chapter 8: Learning Data Analysis Techniques; Highlight Cells That Meet Some Criteria; Highlight the Top or Bottom Values in a Range; Show Duplicate Values; Show Cells That Are Above or Below Average; Analyze Cell Values with Data Bars; Analyze Cell Values with Color Scales; Analyze Cell Values with Icon Sets; Create a Custom Conditional Formatting Rule; Highlight Cells Based On a Formula; Modify a Conditional Formatting Rule; Remove Conditional Formatting from a Range

Ejemplares similares