Bienvenue chez nous !
Logo Ex Libris
 Laissez-vous inspirer ! 

Excel Data Analysis For Dummies

  • eBook (epub)
  • 352 Nombre de pages
(0) Donner la première évaluation
Évaluations
(0)
(0)
(0)
(0)
(0)
Afficher toutes les évaluations
Take Excel to the next level Excel is the world's leading spreadsheet application. It's a key module in Microsoft Office... Lire la suite
Lisez confortablement vos ebooks dans l’appli gratuite Ex Libris Reader. Vous obtiendrez ici votre lien de téléchargement.
CHF 28.00
Download est disponible immédiatement
Informations sur les eBooks
Les eBooks conviennent également aux appareils mobiles (voir les instructions).
Les eBooks d'Ex Libris sont protégés contre la copie par ADOBE DRM: apprenez-en plus.
Pour plus d'informations, cliquez ici.
Commande avec livraison dans une succursale

Description

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.



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.

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

  • Navigate and analyze complicated data
  • Work with external databases, PivotTables, and PivotCharts
  • 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...

  • Work with external databases
  • Start data sharing
  • Get familiar with Solver
  • Clean your data
  • Use PivotTables and PivotCharts
  • Track trends and make forecasts


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.

  • 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.



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...

Informations sur le produit

Titre: Excel Data Analysis For Dummies
Auteur:
Code EAN: 9781119518228
Protection contre la copie numérique: Adobe DRM
Format: eBook (epub)
Producteur: Wiley
Genre: Logiciels
nombre de pages: 352
Parution: 30.10.2018
Taille de fichier: 8.0 MB