Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables /
Etheridge, Denise.
Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables / by Denise Etheridge. - 3rd ed. - Indianapolis, Ind. : Wiley, �2010. - 1 online resource (xii, 352 pages) : illustrations - Visual read less, learn more Visual blueprint . - Visual blueprint. Visual read less, learn more. .
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
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.
English.
9781118983935 1118983939 9780470901724 0470901721 9781621984320 162198432X 9781118036235 1118036239 9786612685071 6612685077 1282685074 9781282685079
CL0500000077 Safari Books Online 2CB712AF-B108-4E7A-A219-8E52AEF8E714 OverDrive, Inc. http://www.overdrive.com
2011285202
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
Tableurs--Logiciels.
COMPUTERS--Desktop Applications--Spreadsheets.
Electronic spreadsheets--Computer programs.
Electronic spreadsheets--Computer programs
HF5548.4.M523
005.54
Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables / by Denise Etheridge. - 3rd ed. - Indianapolis, Ind. : Wiley, �2010. - 1 online resource (xii, 352 pages) : illustrations - Visual read less, learn more Visual blueprint . - Visual blueprint. Visual read less, learn more. .
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
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.
English.
9781118983935 1118983939 9780470901724 0470901721 9781621984320 162198432X 9781118036235 1118036239 9786612685071 6612685077 1282685074 9781282685079
CL0500000077 Safari Books Online 2CB712AF-B108-4E7A-A219-8E52AEF8E714 OverDrive, Inc. http://www.overdrive.com
2011285202
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
Tableurs--Logiciels.
COMPUTERS--Desktop Applications--Spreadsheets.
Electronic spreadsheets--Computer programs.
Electronic spreadsheets--Computer programs
HF5548.4.M523
005.54