Lýsing:
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key module in Microsoft Office--the number-one productivity suite--and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format.
Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you’ll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If you’re familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.
Annað
- Höfundur: Paul McFedries
- Útgáfa:4
- Útgáfudagur: 30-10-2018
- Hægt að prenta út 10 bls.
- Hægt að afrita 2 bls.
- Format:ePub
- ISBN 13: 9781119518228
- Print ISBN: 9781119518167
- ISBN 10: 1119518229
Efnisyfirlit
- Cover
- Introduction
- About This Book
- What You Can Safely Ignore
- Foolish Assumptions
- Icons Used in This Book
- Beyond the Book
- Where to Go from Here
- Part 1: Getting Started with Data Analysis
- Chapter 1: Learning Basic Data-Analysis Techniques
- What Is Data Analysis, Anyway?
- Analyzing Data with Conditional Formatting
- Summarizing Data with Subtotals
- Grouping Related Data
- Consolidating Data from Multiple Worksheets
- Chapter 2: Working with Data-Analysis Tools
- Working with Data Tables
- Analyzing Data with Goal Seek
- Analyzing Data with Scenarios
- Optimizing Data with Solver
- Chapter 3: Introducing Excel Tables
- What Is a Table and Why Should I Care?
- Building a Table
- Analyzing Table Information
- Chapter 4: Grabbing Data from External Sources
- What’s All This About External Data?
- Exporting Data from Other Programs
- Importing External Data into Excel
- Querying External Databases
- It's Sometimes a Raw Deal
- Chapter 5: Scrub-a-Dub-Dub: Cleaning Data
- Editing Your Imported Workbook
- Cleaning Data with Text Functions
- Using Validation to Keep Data Clean
- Chapter 6: Analyzing Table Data with Functions
- The Database Functions: Some General Remarks
- Retrieving a Value from a Table
- Summing a Column's Values
- Counting a Column’s Values
- Averaging a Column's Values
- Determining a Column’s Maximum and Minimum Values
- Multiplying a Column’s Values
- Deriving a Column’s Standard Deviation
- Calculating a Column’s Variance
- Chapter 1: Learning Basic Data-Analysis Techniques
- Chapter 7: Creating and Using PivotTables
- Understanding PivotTables
- Exploring PivotTable Features
- Building a PivotTable from an Excel Table
- Creating a PivotTable from External Data
- Refreshing PivotTable Data
- Adding Multiple Fields to a PivotTable Area
- Pivoting a Field to a Different Area
- Grouping PivotTable Values
- Filtering PivotTable Values
- Chapter 8: Performing PivotTable Calculations
- Messing around with PivotTable Summary Calculations
- Working with PivotTable Subtotals
- Introducing Custom Calculations
- Inserting a Custom Calculated Field
- Inserting a Custom Calculated Item
- Editing a Custom Calculation
- Deleting a Custom Calculation
- Chapter 9: Building PivotCharts
- Introducing the PivotChart
- Creating a PivotChart
- Working with PivotCharts
- Chapter 10: Tracking Trends and Making Forecasts
- Plotting a Best-Fit Trend line
- Calculating Best-Fit Values
- Plotting Forecasted Values
- Extending a Linear Trend
- Calculating Forecasted Linear Values
- Plotting an Exponential Trend Line
- Calculating Exponential Trend Values
- Plotting a Logarithmic Trend Line
- Plotting a Power Trend Line
- Plotting a Polynomial Trend Line
- Chapter 11: Analyzing Data with Statistics
- Counting Things
- Averaging Things
- Finding the Rank
- Determining the Nth Largest or Smallest Value
- Creating a Grouped Frequency Distribution
- Calculating the Variance
- Calculating the Standard Deviation
- Finding the Correlation
- Chapter 12: Analyzing Data with Descriptive Statistics
- Loading the Analysis ToolPak
- Generating Descriptive Statistics
- Calculating a Moving Average
- Determining Rank and Percentile
- Generating Random Numbers
- Creating a Frequency Distribution
- Chapter 13: Analyzing Data with Inferential Statistics
- Sampling Data
- Using the t-Test Tools
- Performing a z-Test
- Determining the Regression
- Calculating the Correlation
- Calculating the Covariance
- Using the Anova Tools
- Performing an f-test
- Chapter 14: Ten Things You Ought to Know about Statistics
- Descriptive Statistics Are Straightforward
- Averages Aren’t So Simple Sometimes
- Standard Deviations Describe Dispersion
- An Observation Is an Observation
- A Sample Is a Subset of Values
- Inferential Statistics Are Cool but Complicated
- Probability Distributions Aren't Always Confusing
- Parameters Aren't So Complicated
- Skewness and Kurtosis Describe a Probability Distribution’s Shape
- Confidence Intervals Seem Complicated at First, but Are Useful
- Chapter 15: Ten Ways to Analyze Financial Data
- Calculating Future Value
- Calculating Present Value
- Determining Loan Payments
- Calculating a Loan Payment's Principal and Interest
- Calculating Cumulative Loan Principal and Interest
- Finding the Required Interest Rate
- Determining the Internal Rate of Return
- Calculating Straight-Line Depreciation
- Returning the Fixed-Declining Balance Depreciation
- Determining the Double-Declining Balance Depreciation
- Chapter 16: Ten Ways to Raise Your PivotTable Game
- Turn the PivotTable Fields Task Pane On and Off
- Change the PivotTable Fields Task Pane Layout
- Display the Details Behind PivotTable Data
- Apply a PivotTable Style
- Create a Custom PivotTable Style
- Preserve PivotTable Formatting
- Rename the PivotTable
- Turn Off Grand Totals
- Reduce the Size of PivotTable Workbooks
- Use a PivotTable Value in a Formula
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 10231
- Útgáfuár : 2018
- Leyfi : 379