CHF21.00
Download est disponible immédiatement
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.
Auteur
Paul McFedries is the president of Logophilia Limited, a technical writing company, and has worked with computers large and small since 1975. Although now primarily a writer, Paul has worked as a programmer, consultant, database developer, and website developer. Paul has written more than 90 books that have sold over four million copies worldwide.
Texte du rabat
Make the most of the latest features of Excel 2019 Take your Excel data-analysis skills to the next level If you can get data into Excel, then you have a giant basket of data analysis tools at your fingertips. This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. So 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 Excel to use for you. Inside...
Résumé
Take Excel to the next level
Excel is the world's leading spreadsheet application. It's a key module in Microsoft Officethe number-one productivity suiteand 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.
Contenu
Introduction 1
About This Book 1
What You Can Safely Ignore 2
Foolish Assumptions 3
Icons Used in This Book 3
Beyond the Book 4
Where to Go from Here 4
Part 1: Getting Started with Data Analysis 5
Chapter 1: Learning Basic Data-Analysis Techniques 7
What Is Data Analysis, Anyway? 8
Cooking raw data 8
Dealing with data 8
Building data models 9
Performing what-if analysis 9
Analyzing Data with Conditional Formatting 9
Highlighting cells that meet some criteria 10
Showing pesky duplicate values 12
Highlighting the top or bottom values in a range 13
Analyzing cell values with data bars 14
Analyzing cell values with color scales 16
Analyzing cell values with icon sets 16
Creating a custom conditional formatting rule 17
Editing a conditional formatting rule 20
Removing conditional formatting rules 22
Summarizing Data with Subtotals 23
Grouping Related Data 24
Consolidating Data from Multiple Worksheets 26
Consolidating by position 27
Consolidating by category 28
Chapter 2: Working with Data-Analysis Tools 31
Working with Data Tables 31
Creating a basic data table 32
Creating a two-input data table 34
Skipping data tables when calculating workbooks 36
Analyzing Data with Goal Seek 37
Analyzing Data with Scenarios 39
Create a scenario 39
Apply a scenario 41
Edit a scenario 41
Delete a scenario 42
Optimizing Data with Solver 42
Understanding Solver 43
The advantages of Solver 43
When should you use Solver? 43
Loading the Solver add-in 45
Optimizing a result with Solver 46
Adding constraints to Solver 48
Save a Solver solution as a scenario 51
Chapter 3: Introducing Excel Tables 53
What Is a Table and Why Should I Care? 53
Building a Table 55
Getting the data from an external source 56
Converting a range to a table 56
Basic table maintenance 58
Analyzing Table Information 59
Displaying simple statistics 59
Adding a column subtotal 60
Sorting table records 62
Filtering table records 64
Clearing a filter 66
Turning off AutoFilter 66
Applying a predefined AutoFilter 66
Applying multiple filters 69
Applying advanced filters 69
Chapter 4: Grabbing Data from External Sources 75
What's All This About External Data? 75
Exporting Data from Other Programs 77
Importing External Data into Excel 78
Importing data from an Access table 78
Importing data from a Word table 79
Introducing text file importing 80
Importing a delimited text file 81
Importing a fixed-width text file 82
Importing data from a web page 83
Importing an XML file 85
Querying External Databases 87
Defining a data source 88
Querying a data source 91
It's Sometimes a Raw Deal 95
Chapter 5: Scrub-a-Dub-Dub: Cleaning Data 97
Editing Your Imported Workbook 97
Deleting unnecessary columns 98
Deleting unnecessary rows 99
Resizing columns 99
Resizing rows 99
Erasing unneeded contents in a cell or range 100
Formatting numeric values 100
Copying worksheet data 101
Moving worksheet data 101
Replacing data in fields 102
Cleaning Data with Text Functions 103
The CLEAN function 103 The CON...